생산 이력

테이블 (5)

DUT TEST (DUT)

  • TEST ID — CHAR — 기본 키 — NOT NULL
  • LOT START INFO (LOT Start Info) — CHAR
  • TEST 구분 — INT
  • TIME (Time) — TIME
  • BIN INFO (Bin Info) — CHAR
  • START ID — CHAR — 외래 키 → LOT 시작.START ID — NOT NULL
  • LOT ID — CHAR — 외래 키 → LOT 시작.LOT ID — NOT NULL

LOT 시작 (LOT Start)

  • START ID — CHAR — 기본 키 — NOT NULL
  • LOT ID — CHAR — 외래 키 → LOT 정보.LOT ID — NOT NULL
  • TIME (Time) — TIME
  • LOT Info — CHAR

LOT 정보 (LOT INFO)

  • LOT ID — CHAR — 기본 키 — NOT NULL
  • Operator — CHAR
  • Package Name — CHAR
  • Para — INT
  • Step — INT
  • Set Temp — INT

LOT 종료 (LOT End)

  • END ID — CHAR — 기본 키 — NOT NULL
  • START ID — CHAR — 외래 키 → LOT 시작.START ID — NOT NULL
  • LOT ID — CHAR — 외래 키 → LOT 시작.LOT ID — NOT NULL
  • LOT START Info (LOT Start Info) — CHAR
  • TIME (Time) — TIME
  • LOADING COUNT (Loading Count) — INT
  • UNLOADING COUNT (Unloading Count) — INT
  • Bin 1~8 COUNT (Bin Count) — INT

TRAY TEST (TRAY)

  • TEST ID — CHAR — 기본 키 — NOT NULL
  • LOT 시작 정보 (LOT Start Info) — CHAR
  • TEST 구분 — INT
  • TRAY ID — INT
  • TIME (Time) — TIME
  • BIN INFO (Bin Info) — CHAR
  • START ID — CHAR — 외래 키 → LOT 시작.START ID — NOT NULL
  • LOT ID — CHAR — 외래 키 → LOT 시작.LOT ID — NOT NULL