산자부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