기말과제12-28
테이블 (9)
Untitled (BOOK)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (title) — char(70)
- Field (originalTitle) — char(70)
- Field (KDC_6th) — char(20)
- Field (pubYear) — int(4)
- Field (type) — char(10)
- Field (bookID) — char(10)
- Key (awardID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (publisherID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (prizedYear) — int(4)
Untitled (AUTHOR)
- Key (authorID) — char(10) — 기본 키 — NOT NULL
- Field (nationality) — char(30)
- Field (name) — char(30)
- Field (alternativeName) — char(30)
- Field (description) — text
- Field (email) — email
Untitled (ILLUSTRATOR)
- Key (illustratorID) — char(10) — 기본 키 — NOT NULL
- Field (nationality) — char(30)
- Field (name) — char(30)
- Field (alternativeName) — char(30)
- Field (description) — tex
- Field (email) — email
Untitled (BOOK_AUTHOR)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (bookID) — char(10)
- Field (role) — char(20)
Untitled (AWARD)
- Key (awardID) — char(10) — 기본 키 — NOT NULL
- Field (caldecott) — char(30)
- Field (newbery) — char(30)
- Field (carnegie) — char(30)
- Field (andersen) — char(30)
- Field (bolognaragazzi) — char(30)
- Field (kategreenaway) — char(30)
- Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (illustratorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK_ILLUSTRATOR)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (illustratorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (bookID) — char(10)
- Field (role) — char(20)
Untitled (PUBLISHER)
- Key (publisherID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
- Field (phone) — charr(20)
- Field (email) — email
Untitled (BOOK_TRANSLATOR)
- Key (translatorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (bookID) — char(10)
- Field (roie) — char(20)
Untitled (TRANSLATOR)
- Key (translatorID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — tex
- Field (email) — email