산자부03

테이블 (6)

equipment_alarm

  • id — BIGINT
  • tray_run_id — BIGINT — 외래 키 → tray_run.id
  • error_code — INT — NOT NULL
  • error_name — VARCHAR(200) — NOT NULL
  • occurred_at — DATETIME — NOT NULL
  • cleared_at — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

process_event

  • id — BIGINT
  • tray_run_id — BIGINT — 외래 키 → tray_run.id
  • tray_slot_id — BIGINT — 외래 키 → tray_slot.id
  • stack_group_id — BIGINT — 외래 키 → stack_group.id
  • tray_type — VARCHAR(20)
  • row_no — INT
  • col_no — INT
  • slot_no — INT
  • group_no — INT
  • event_type — VARCHAR(50) — NOT NULL
  • plc_address — VARCHAR(20)
  • event_value — VARCHAR(50)
  • message — VARCHAR(255)
  • event_time — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

stack_group

  • id — BIGINT
  • tray_run_id — BIGINT — 외래 키 → tray_run.id — NOT NULL
  • group_no — INT — NOT NULL
  • board_row_no — INT — NOT NULL
  • board_col_no — INT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • laminated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

stack_group_item

  • id — BIGINT
  • stack_group_id — BIGINT — 외래 키 → stack_group.id — NOT NULL
  • tray_slot_id — BIGINT — 외래 키 → tray_slot.id — NOT NULL
  • pick_order — INT — NOT NULL
  • picked_at — DATETIME
  • created_at — DATETIME — NOT NULL

tray_run

  • id — BIGINT
  • tray_run_no — VARCHAR(50) — NOT NULL
  • tray_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • loading_completed_at — DATETIME
  • nano_completed_at — DATETIME
  • dry_started_at — DATETIME
  • dry_completed_at — DATETIME
  • stacking_started_at — DATETIME
  • completed_at — DATETIME
  • total_slots — INT — NOT NULL
  • loaded_slots — INT — NOT NULL
  • nano_completed_slots — INT — NOT NULL
  • unloaded_slots — INT — NOT NULL
  • laminated_groups — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tray_slot

  • id — BIGINT
  • tray_run_id — BIGINT — 외래 키 → tray_run.id — NOT NULL
  • slot_no — INT — NOT NULL
  • row_no — INT — NOT NULL
  • col_no — INT — NOT NULL
  • glass_no — INT — NOT NULL
  • glass_lot_no — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • loading_started_at — DATETIME
  • loading_completed_at — DATETIME
  • nano_completed_at — DATETIME
  • slot_completed_at — DATETIME
  • slot_elapsed_seconds — INT
  • unloaded_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL