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