적재적소
테이블 (20)
amr_position_log
- id — INT — NOT NULL
- amr_id — VARCHAR(32) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- position — JSON
- speed_mps — DOUBLE — NOT NULL
- battery_pct — DOUBLE — NOT NULL
- recorded_at — DATETIME — NOT NULL
amr_snapshot
- id — INT — NOT NULL
- amr_id — VARCHAR(32) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- position — JSON
- orientation_deg — DOUBLE — NOT NULL
- speed_mps — DOUBLE — NOT NULL
- battery — JSON
- payload — JSON
- path — JSON
- status_changed_at — DATETIME
- updated_at — DATETIME — NOT NULL
asset_robot_arm_snapshot
- id — INT — NOT NULL
- asset_id — VARCHAR(32) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- cell_id — VARCHAR(32) — NOT NULL
- program_name — VARCHAR(64) — NOT NULL
- payload_kg — DECIMAL(8,2)
- joint_state — JSON
- handoff_id — VARCHAR(32) — NOT NULL
- material_code — VARCHAR(64) — NOT NULL
- load_count — INT — NOT NULL
- overload_warning — TINYINT(1) — NOT NULL
- work_order_no — VARCHAR(32) — NOT NULL
- metadata — JSON
- updated_at — DATETIME — NOT NULL
auth_user
- id — INT — NOT NULL
- username — VARCHAR(150) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- password — VARCHAR(128) — NOT NULL
bottleneck_measurement
- id — INT — NOT NULL
- zone_label — VARCHAR(32) — NOT NULL
- time_label — VARCHAR(32) — NOT NULL
- congestion_pct — INT — NOT NULL
- zone_order — INT — NOT NULL
- time_order — INT — NOT NULL
conveyor_belt
- id — INT — NOT NULL
- belt_id — VARCHAR(32) — NOT NULL
- belt_type — VARCHAR(16) — NOT NULL
- label — VARCHAR(64) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- current_speed_mps — DOUBLE — NOT NULL
- target_speed_mps — DOUBLE — NOT NULL
- is_paused — TINYINT(1) — NOT NULL
- box_on_belt_count — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
conveyor_belt_log
- id — INT — NOT NULL
- belt_id — VARCHAR(32) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- current_speed_mps — DOUBLE — NOT NULL
- is_paused — TINYINT(1) — NOT NULL
- box_on_belt_count — INT — NOT NULL
- recorded_at — DATETIME — NOT NULL
daily_report_note
- id — INT — NOT NULL
- report_date — DATE — NOT NULL
- notes — TEXT — NOT NULL
- updated_at — DATETIME — NOT NULL
- updated_by — VARCHAR(100) — NOT NULL
dashboard_kpi_snapshot
- id — INT — NOT NULL
- avg_travel_time_min — DECIMAL(6,2) — NOT NULL
- throughput_per_hour — INT — NOT NULL
- loading_success_rate — DECIMAL(5,2) — NOT NULL
- avg_health_score — INT — NOT NULL
- danger_agv_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
device_command
- id — INT — NOT NULL
- device_type — VARCHAR(16) — NOT NULL
- device_id — VARCHAR(32) — NOT NULL
- command_type — VARCHAR(32) — NOT NULL
- parameters — JSON
- status — VARCHAR(16) — NOT NULL
- issued_by_id — INT — 외래 키 → auth_user.id
- issued_by_name — VARCHAR(64) — NOT NULL
- recommendation_id — INT — 외래 키 → recommendation_action.id
- result — JSON
- issued_at — DATETIME — NOT NULL
- executed_at — DATETIME
factory_cell_event
- id — INT — NOT NULL
- asset_id — VARCHAR(32) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- event_type — VARCHAR(64) — NOT NULL
- active_assets — JSON
- alert_level — VARCHAR(16) — NOT NULL
- work_order_no — VARCHAR(32) — NOT NULL
- metadata — JSON
- updated_at — DATETIME — NOT NULL
inbound_queue
- id — INT — NOT NULL
- zone — VARCHAR(32) — NOT NULL
- waiting_box_count — INT — NOT NULL
- estimated_wait_min — DOUBLE — NOT NULL
- capacity_pct — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
load_transfer
- id — INT — NOT NULL
- handoff_id — VARCHAR(32) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- work_order_no — VARCHAR(32) — NOT NULL
- material_code — VARCHAR(64) — NOT NULL
- cell_id — VARCHAR(32) — NOT NULL
- agv_id — VARCHAR(32) — NOT NULL
- robot_arm_id — VARCHAR(32) — NOT NULL
- load_kg — DECIMAL(8,2)
- load_count — INT — NOT NULL
- destination_zone — VARCHAR(32) — NOT NULL
- overload_warning — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
recommendation_action
- id — INT — NOT NULL
- agv_id — VARCHAR(32) — NOT NULL
- level — VARCHAR(16) — NOT NULL
- title — VARCHAR(120) — NOT NULL
- message — TEXT — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- suggested_command — VARCHAR(32)
- acknowledged — TINYINT(1) — NOT NULL
- acknowledged_by — VARCHAR(64)
- acknowledged_at — DATETIME
- updated_at — DATETIME — NOT NULL
report_template
- id — INT — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100) — NOT NULL
- signature_label — VARCHAR(100) — NOT NULL
- report_title — VARCHAR(200) — NOT NULL
- show_kpi — TINYINT(1) — NOT NULL
- show_safety_events — TINYINT(1) — NOT NULL
- show_amr — TINYINT(1) — NOT NULL
- show_robot_arm — TINYINT(1) — NOT NULL
- show_actions — TINYINT(1) — NOT NULL
- show_notes — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
robot_arm_log
- id — INT — NOT NULL
- arm_id — VARCHAR(32) — NOT NULL
- line_id — VARCHAR(16) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- cycle_count_today — INT — NOT NULL
- error_code — VARCHAR(32)
- last_pick_success — TINYINT(1) — NOT NULL
- suction_active — TINYINT(1) — NOT NULL
- arm_phase — VARCHAR(32)
- phase_tick — INT — NOT NULL
- boxes_target — INT — NOT NULL
- conveyor_running — TINYINT(1) — NOT NULL
- is_moving — TINYINT(1) — NOT NULL
- recorded_at — DATETIME — NOT NULL
robot_arm_snapshot
- id — INT — NOT NULL
- arm_id — VARCHAR(32) — NOT NULL
- line_id — VARCHAR(16) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- cycle_count_today — INT — NOT NULL
- error_code — VARCHAR(32)
- last_pick_success — TINYINT(1) — NOT NULL
- suction_active — TINYINT(1) — NOT NULL
- arm_phase — VARCHAR(32)
- phase_tick — INT — NOT NULL
- boxes_target — INT — NOT NULL
- conveyor_running — TINYINT(1) — NOT NULL
- joint_positions_deg — JSON
- is_moving — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
safety_event
- id — INT — NOT NULL
- event_type — VARCHAR(32) — NOT NULL
- severity — VARCHAR(16) — NOT NULL
- source_type — VARCHAR(16) — NOT NULL
- source_id — VARCHAR(32) — NOT NULL
- position — JSON
- details — JSON
- occurred_at — DATETIME — NOT NULL
- acknowledged — TINYINT(1) — NOT NULL
- acknowledged_by_id — INT — 외래 키 → auth_user.id
- acknowledged_at — DATETIME
travel_time_snapshot
- id — INT — NOT NULL
- label — VARCHAR(32) — NOT NULL
- before_value — DECIMAL(6,2) — NOT NULL
- after_value — DECIMAL(6,2) — NOT NULL
- display_order — INT — NOT NULL
work_order_alert_acknowledgement
- id — INT — NOT NULL
- work_order_no — VARCHAR(32) — NOT NULL
- actor — VARCHAR(64) — NOT NULL
- note — TEXT — NOT NULL
- cleared — TINYINT(1) — NOT NULL
- acknowledged_at — DATETIME — NOT NULL