4족보행로봇/안전관리플랫폼

테이블 (24)

activity_logs

  • id — BIGINT — 기본 키
  • activity_type — VARCHAR(100) — NOT NULL
  • target_type — VARCHAR(100)
  • target_id — BIGINT
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL

event_actions

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

events

  • id — BIGINT — 기본 키
  • 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
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL
  • image_file_id — BIGINT — 외래 키 → files.id

files

  • id — BIGINT — 기본 키
  • 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

hazard_report_files

  • id — BIGINT — 기본 키 — NOT NULL
  • hazard_report_files (hazard_report_id) — BIGINT — 외래 키 → hazard_reports.id
  • file_id — BIGINT — 외래 키 → files.id

hazard_reports

  • id — BIGINT — 기본 키
  • category — VARCHAR(100) — NOT NULL
  • hazard_name — VARCHAR(150)
  • danger_level — VARCHAR(50)
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • reported_by — BIGINT — 외래 키 → users.id — NOT NULL

map_anchor_points

  • id — BIGINT — 기본 키 — NOT NULL
  • label — VARCHAR(100)
  • raw_x — DECIMAL(12,4) — NOT NULL
  • raw_y — DECIMAL(12,4) — NOT NULL
  • map_x — DECIMAL(12,4) — NOT NULL
  • map_y — DECIMAL(12,4) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • site_map_id — BIGINT — 외래 키 → site_maps.id

notifications

  • id — BIGINT — 기본 키
  • 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

ppe_logs

  • id — BIGINT — 기본 키
  • 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
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL
  • image_file_id — BIGINT — 외래 키 → files.id

risk_assessment_files

  • id — BIGINT — 기본 키 — NOT NULL
  • risk_assessment_id — BIGINT — 외래 키 → risk_assessments.id
  • file_id — BIGINT — 외래 키 → files.id

risk_assessments

  • id — BIGINT — 기본 키
  • category — VARCHAR(100) — NOT NULL
  • hazard_name — VARCHAR(150) — NOT NULL
  • description — TEXT
  • likelihood_score — INT — NOT NULL
  • severity_score — INT — NOT NULL
  • risk_score — INT — NOT NULL
  • action_plan — TEXT
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • hazard_report_id — BIGINT — 외래 키 → hazard_reports.id
  • created_by — BIGINT — 외래 키 → users.id — NOT NULL

robot_command_status_histories

  • id — BIGINT — 기본 키
  • 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

robot_commands

  • id — BIGINT — 기본 키
  • 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
  • robot_id — BIGINT — 외래 키 → robots.id — NOT NULL
  • requested_by — BIGINT — 외래 키 → users.id — NOT NULL

robot_location_logs

  • id — BIGINT — 기본 키
  • 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 — 기본 키
  • 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 — 기본 키
  • requested_by — 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

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
  • 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

site_maps

  • id — BIGINT — 기본 키
  • name — VARCHAR(150) — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • width — INT
  • height — INT
  • 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

sites

  • id — BIGINT — 기본 키
  • 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

tasks

  • id — BIGINT — 기본 키
  • task_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT
  • scheduled_date — TIMESTAMP
  • status — VARCHAR(50) — NOT NULL
  • memo — TEXT
  • checklist_json — TEXT
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • site_id — BIGINT — 외래 키 → sites.id
  • zone_id — BIGINT — 외래 키 → zones.id — NOT NULL
  • assigned_to — BIGINT — 외래 키 → users.id — NOT NULL
  • created_by — BIGINT — 외래 키 → users.id — NOT NULL
  • updated_by — BIGINT — 외래 키 → users.id — NOT NULL
  • completed_by — BIGINT — 외래 키 → users.id — 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

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_hazardous — BOOLEAN — NOT NULL
  • 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