마지막 과제
테이블 (12)
Untitled (Book)
- Key (ISBN) — varchar(20) — 기본 키 — NOT NULL
- Field (title) — varchar(255)
- Field (publicationDate) — date
- Key (publisherID) — int — 외래 키 → Untitled2.Key — NOT NULL
Untitled (Book_Author)
- Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (authorID) — int — 외래 키 → Untitled3.Key — NOT NULL
Untitled (RelatedItem)
- Key (itemID) — int — 기본 키 — NOT NULL
- Field (type) — enum
- Field (title) — varchar(255)
- Field (description) — text
Untitled (Books_RelatedItems)
- Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (itemID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Author_NotableWorks)
- Key (authorID) — int — 외래 키 → Untitled3.Key — NOT NULL
- Key (workID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (NotableWorks)
- Key (workID) — int — 기본 키 — NOT NULL
- Field (title) — varchar(255)
- Field (publicationDate) — date
- Field (description) — tevt
Untitled2 (Publisher)
- Key (publisherID) — int — 기본 키 — NOT NULL
- Field (name) — varchar(255)
- Field (address) — varchar(255)
Untitled3 (Author)
- Key (authorID) — int — 기본 키 — NOT NULL
- Field (name) — varchar(255)
- Field (address) — varchar(255)
Untitled4 (Printer)
- Key (printerID) — int — 기본 키 — NOT NULL
- Field (name) — varchar(255)
- Field (address) — varchar(255)
Untitled5 (Subject)
- Key (subjectID) — int — 기본 키 — NOT NULL
- Field (KDCNumber) — varchar(10)
- Field (subjectName) — varchar(255)
Untitled6 (Book_Subject)
- Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (subjectID) — int — 외래 키 → Untitled5.Key — NOT NULL
Untitled7 (Contract)
- Key (ContractID) — int — 기본 키 — NOT NULL
- Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (printerID) — int — 외래 키 → Untitled4.Key — NOT NULL
- Field (printQuantity) — int
- Field2 (deadline) — date