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