실습

테이블 (5)

DUT TEST (DUTTEST)

  • TEST ID (TESTID) — 기본 키 — NOT NULL
  • LOTID — 외래 키 → LOT정보.LOTID — NOT NULL
  • LOT START INFO (LOTSTARTINFO) — NOT NULL
  • TEST SPEC (TESTSPECIFI) — NOT NULL
  • TIME — NOT NULL
  • BIN INFO (BININFO) — NOT NULL

LOT시작 (LOTSTART)

  • Start ID (STARTID) — 기본 키 — NOT NULL
  • LOTID — 외래 키 → LOT정보.LOTID — NOT NULL
  • Time (TIME) — NOT NULL

LOT정보 (LOTINFO)

  • LOTID — 기본 키 — NOT NULL
  • ENGNAME — NOT NULL
  • Pkg Name (PKGNAME) — NOT NULL
  • Para (PARA) — NOT NULL
  • Step (STEP) — NOT NULL
  • SetTemp (SETTEMP) — NOT NULL

LOT종료 (LOTEND)

  • End ID (ENDID) — 기본 키 — NOT NULL
  • Start ID (STARTID) — 외래 키 → LOT시작.Start ID — NOT NULL
  • LOTID — 외래 키 → LOT시작.LOTID — NOT NULL
  • LOT START INFO (LOTSTARTINFO) — NOT NULL
  • TIME(END) (ENDTIME) — NOT NULL
  • LOAD EA (LOAD_UNIT) — NOT NULL
  • UNLOAD EA (UNLOAD_UNIT) — NOT NULL
  • BIN1 — NOT NULL
  • BIN2 — NOT NULL
  • BIN3 — NOT NULL
  • BIN4 — NOT NULL
  • BIN5 — NOT NULL
  • BIN6 — NOT NULL
  • BIN7 — NOT NULL
  • BIN8 — NOT NULL

TRAY TEST (TRAYTEST)

  • TEST ID (TESTID) — 기본 키 — NOT NULL
  • LOTID — 외래 키 → LOT정보.LOTID — NOT NULL
  • LOT START INFO (LOTSTARTINFO) — NOT NULL
  • TEST SPEC (TESTSPECIFI) — NOT NULL
  • TRAY ID (TRAYID) — NOT NULL
  • TIME — NOT NULL
  • BIN INFO (BININFO) — NOT NULL