데이터베이스 기말고사
테이블 (9)
Untitled (WORK)
- Key (workID) — int(20) — 기본 키 — NOT NULL
- Field (workTiltle) — char(50)
Untitled (AUTHOR)
- Key (autjID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (alternativeName) — char(30)
- Field (nationality) — char(20)
Untitled (WORK_AUTHOR)
- Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (autjID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (ILLUSTRATOR)
- Key (illuID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (alternativeName) — char(30)
- Field (nationality) — char(20)
Untitled (WORK_ILLUSTRATOR)
- Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (illuID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (pubDate) — date
- Field (type) — char(10)
- Field (KDC) — char(20)
- Field (page) — char(10)
- Field (price) — integer
- Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (pubID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PUBLISHER)
- Key (pubID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
- Field (phone) — char(20)
- Field (fax) — char(20)
- Field (email) — char(30)
- Field (homepage)
Untitled (SUBJECT)
- Key (subID) — int(20) — 기본 키 — NOT NULL
- Field (subjectHeading) — char(30)
- Field (description) — text
Untitled (WORK_SUBJECT)
- Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (subID) — int(20) — 외래 키 → Untitled.Key — NOT NULL