수상작별 도서
테이블 (6)
BOOK
- Key (bookID) — char(20) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (ISBN) — char(20)
- Field (pubYear) — int(6)
- Field (price) — int(10)
- Key (awardID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (ssn) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(12)
- Field (phone) — char(10)
- Field (address) — (10)
- Field (joinDate) — date
- Field (number_of_overdue) — date
Untitled (AUTHOR)
- Key (authorID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(10)
- Field (bookAward) — text
- Field (description) — text
- Field (phone) — char(5)
Untitled (BOOK_MEMBER)
- Key (bmID) — char(10) — 기본 키 — NOT NULL
- Field (loanDate) — date
- Field (returnDate) — date
- Key (bookID) — char(20) — 외래 키 → BOOK.Key — NOT NULL
- Key (ssn) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK_AWARD)
- Key (awardID) — char(20) — 기본 키 — NOT NULL
- Field (caldecott) — char(5)
- Field2 (newbery) — char(3)
- Field3 (carnegie) — char(5)
- Field (bangjungwhan) — char(3)
- Field (koreanbook_award) — char(4)
- Field (description) — text
- Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK_AUTHOR)
- Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (bookID) — char(20) — 외래 키 → BOOK.Key — NOT NULL
- Field (role) — char(10)