연습문제 6
테이블 (6)
BOOKINFOR
- Key (isbn) — char(20) — 기본 키 — NOT NULL
- Field (signature) — char(30)
- Field (pubDate) — date
- Field (review) — text
- Key (pubID) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (pubInfor) — text
Untitled (AUTHOR)
- Key (ssn) — char(13) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (profile) — text
Untitled (BOOKAUTHOR)
- Key (isbn) — char(20) — 외래 키 → BOOKINFOR.Key — NOT NULL
- Key (ssn) — char(13) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PRINTSHOP)
- Key (printID) — int(10) — 기본 키 — NOT NULL
- Field (appellation) — char(10)
- Field (address) — char(20)
Untitled (PUBLISHER)
- Key (pubID) — int — 기본 키 — NOT NULL
- Field (appellation) — char(10)
- Field (address) — char(20)
Untitled (CONTRACT INFOR)
- Key (isbn) — char(20) — 외래 키 → BOOKINFOR.Key — NOT NULL
- Key (printID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (volume) — int
- Field (closingDate) — date