적재적소

테이블 (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