실습
테이블 (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