안전하개(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