안전하개(MVP)

테이블 (18)

event_actions

  • id — BIGINT — 기본 키 — NOT NULL
  • action_note — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • action_by — BIGINT — 외래 키 → users.id — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • after_image_file_id — BIGINT — 외래 키 → files.id — NOT NULL

events

  • id — BIGINT — 기본 키 — NOT NULL
  • event_code — VARCHAR(100) — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • x — DECIMAL(12,4)
  • y — DECIMAL(12,4)
  • description — TEXT
  • sensor_data_json — TEXT
  • occurred_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id — NOT NULL
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL
  • image_file_id — BIGINT — 외래 키 → files.id — NOT NULL

files

  • id — BIGINT — 기본 키 — NOT NULL
  • file_type — VARCHAR(50)
  • original_name — VARCHAR(255) — NOT NULL
  • stored_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • mime_type — VARCHAR(100)
  • file_size — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • uploaded_by — BIGINT — 외래 키 → users.id — NOT NULL

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • notification_type — VARCHAR(100) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • related_entity_type — VARCHAR(100)
  • related_entity_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • read_at — TIMESTAMP
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id — NOT NULL

patrol_schedule_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • execution_status — VARCHAR(50) — NOT NULL
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP
  • result_message — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL
  • patrol_schedule_id — BIGINT — 외래 키 → patrol_schedules.id — NOT NULL

patrol_schedules

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • description — TEXT
  • schedule_type — VARCHAR(50) — NOT NULL
  • schedule_expression — VARCHAR(255) — NOT NULL
  • waypoint_json — TEXT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — BIGINT — 외래 키 → users.id — NOT NULL
  • updated_by — BIGINT — 외래 키 → users.id — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id — NOT NULL
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL

ppe_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • log_code — VARCHAR(100) — NOT NULL
  • ppe_type — VARCHAR(50) — NOT NULL
  • x — DECIMAL(12,4)
  • y — DECIMAL(12,4)
  • warning_broadcasted — BOOLEAN — NOT NULL
  • detected_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id — NOT NULL
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL
  • image_file_id — BIGINT — 외래 키 → files.id — NOT NULL

robot_command_status_histories

  • id — BIGINT — 기본 키 — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • reason_code — VARCHAR(100)
  • reason_message — VARCHAR(255)
  • changed_at — TIMESTAMP — NOT NULL
  • robot_command_id — BIGINT — 외래 키 → robot_commands.id — NOT NULL

robot_commands

  • id — BIGINT — 기본 키 — NOT NULL
  • command_id — VARCHAR(100) — NOT NULL
  • command_type — VARCHAR(50) — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL
  • is_emergency — BOOLEAN — NOT NULL
  • queue_order — INT
  • payload_json — TEXT
  • final_status — VARCHAR(50)
  • final_reason_code — VARCHAR(100)
  • final_reason_message — VARCHAR(255)
  • responded_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • requested_by — BIGINT — 외래 키 → users.id — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL

robot_location_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • x — DECIMAL(12,4) — NOT NULL
  • y — DECIMAL(12,4) — NOT NULL
  • heading — DECIMAL(8,2)
  • logged_at — TIMESTAMP — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL

robot_status_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • robot_state — VARCHAR(50) — NOT NULL
  • state_reason — VARCHAR(255)
  • is_busy — BOOLEAN — NOT NULL
  • logged_at — TIMESTAMP — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL

robot_stream_sessions

  • id — BIGINT
  • session_status — VARCHAR(50) — NOT NULL
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL
  • requested_by — BIGINT — 외래 키 → users.id — NOT NULL

robots

  • id — BIGINT — 기본 키 — NOT NULL
  • robot_code — VARCHAR(100) — NOT NULL
  • serial_number — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • model_name — VARCHAR(100)
  • shared_secret — VARCHAR(255)
  • current_state — VARCHAR(50)
  • last_heartbeat_at — TIMESTAMP
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id — NOT NULL
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL

roles

  • id — BIGINT — 기본 키 — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sites

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • address — VARCHAR(255)
  • description — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_site_roles

  • id — BIGINT — 기본 키 — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • role_id — BIGINT — 외래 키 → roles.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • employee_id — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(50)
  • email — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

zones

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • description — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • mapping_json — TEXT
  • site_id — BIGINT — 외래 키 → sites.id — NOT NULL