산자부 mes
테이블 (6)
ALARM_HISTORY
- alarm_id — BIGINT — 기본 키 — NOT NULL
- alarm_code — INT — NOT NULL
- alarm_name — VARCHAR(100) — NOT NULL
- alarm_started_at — DATETIME — NOT NULL
- alarm_ended_at — DATETIME
GLASS_ITEM
- glass_id — BIGINT — 기본 키 — NOT NULL
- tray_work_id — BIGINT — 외래 키 → TRAY_WORK.tray_work_id — NOT NULL
- glass_no — INT — NOT NULL
- loaded_at — DATETIME
- nano_dispensed_at — DATETIME
- dry_completed_at — DATETIME
- status — VARCHAR(30) — NOT NULL
STACK_GROUP
- stack_group_id — BIGINT — 기본 키 — NOT NULL
- tray_work_id — BIGINT — 외래 키 → TRAY_WORK.tray_work_id — NOT NULL
- stack_pos_no — INT — NOT NULL
- first_glass_stacked_at — DATETIME
- uv_dotting_completed_at — DATETIME
- uv_completed_at — DATETIME
- stack_completed_at — DATETIME
- status — VARCHAR(30) — NOT NULL
STACK_GROUP_GLASS
- stack_group_glass_id — BIGINT — 기본 키 — NOT NULL
- stack_group_id — BIGINT — 외래 키 → STACK_GROUP.stack_group_id — NOT NULL
- glass_id — BIGINT — 외래 키 → GLASS_ITEM.glass_id — NOT NULL
- layer_no — INT — NOT NULL
- stacked_at — DATETIME
TRAY
- tray_id — BIGINT — 기본 키 — NOT NULL
- tray_name — VARCHAR(20) — NOT NULL
- tray_code — VARCHAR(20) — NOT NULL
- capacity — INT — NOT NULL
TRAY_WORK
- tray_work_id — BIGINT — 기본 키 — NOT NULL
- tray_id — BIGINT — 외래 키 → TRAY.tray_id — NOT NULL
- first_glass_loaded_at — DATETIME
- load_completed_at — DATETIME
- nano_completed_at — DATETIME
- dry_started_at — DATETIME
- dry_completed_at — DATETIME
- completed_at — DATETIME
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL