기말과제
테이블 (4)
Untitled (book)
- Key (ISBN) — int(13) — 기본 키 — NOT NULL
- Key (pubID) — int(5) — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — char(30)
- Field (pubYear) — int(4)
- Field (pubMonth) — int(2)
- Field (description) — LONGTEXT
- Field (award) — LONGTEXT
- Field (price) — int(10)
- Field (bookType) — ENUM
Untitled (publisher)
- Key (pubID) — int(5) — 기본 키 — NOT NULL
- Field (pubName) — char(20)
- Field (address) — TEXT
- Field (CEO) — char(50)
- Field (website) — char(50)
Untitled (author)
- Key (authID) — int(10) — 기본 키 — NOT NULL
- Field (authName) — char(20)
- Field (description) — LONGTEXT
- Field (award) — LONGTEXT
Untitled (book_author)
- Key (ISBN) — int(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (pubID) — int(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (authID) — int(10) — 외래 키 → Untitled.Key — NOT NULL