중간고사
테이블 (6)
Untitled (PUBLISHER)
- Key (pubID) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (email) — char(30)
- Field (number) — char(10)
Untitled (AUTHOR)
- Key (ssn) — char(14) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (email) — char(30)
- Field (number) — char(10)
Untitled (BOOK_AUTHOR)
- Key (ISBN) — char(20) — 외래 키 → 책.Key — NOT NULL
- Key (ssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (TOPIC)
- Key (keyword) — char(10) — 기본 키 — NOT NULL
- Field (keyName) — char(20)
Untitled (BOOK_INFO)
- Key (ISBN) — char(20) — 외래 키 → 책.Key — NOT NULL
- Key (keyword) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (KDC) — int
- Field (event) — text
책 (BOOK)
- Key (ISBN) — char(20) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (pubDate) — date
- Key (pubID) — char(20) — 외래 키 → Untitled.Key — NOT NULL