중간고사복습
테이블 (7)
Untitled (BOOK)
- Key (ISBN) — int(13) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (pubdate) — date
- Field (pageNumber) — int(4)
- Field (edition) — int(3)
- Field (price) — int(10)
- Key (pubID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (code) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PUBLISHER)
- Key (pubID) — char(10) — 기본 키 — NOT NULL
- Field (pubNAME) — char(20)
- Field (add) — char(30)
- Field (email) — char(30)
- Field (phone) — int(11)
- Field (fax) — int(11)
- Field (homepage) — char(30)
- Field (ceoNAME) — char(20)
Untitled (CONTRACT)
- Key (contractID) — char(100) — 기본 키 — NOT NULL
- Field (quantity) — int(10)
- Field (price) — int(15)
- Field (deadline) — date
- Field (contractdate) — date
- Key (printerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (KDC)
- Key (code) — char(10) — 기본 키 — NOT NULL
- Key (name) — char(50) — NOT NULL
- Field (DES) — text
Untitled (PRINTER)
- Key (printerID) — char(10) — 기본 키 — NOT NULL
- Field (printerNAME) — char(20)
- Field (add) — char(30)
- Field2 (phone) — int(11)
- Field4 (fax) — int(11)
- Field (DES) — longtext
- Field (capacity) — int(10)
Untitled (AUTHOR)
- Key (authorID) — char(10) — 기본 키 — NOT NULL
- Field (authorNAME) — char(30)
- Field (ssn) — char(14)
- Field (add) — char(30)
- Field (biography) — longtext
- Field (phone) — char(14)
- Field (email) — char(30)
- Field (materpeace) — char(30)
Untitled (BOOK_AUTHOR)
- Key (ISBN) — int(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (role) — char(30)