중간고사_김하영
테이블 (7)
Untitled (author)
- Key (aID) — char(13) — 기본 키 — NOT NULL
- Field (name) — char(5)
- Field (address) — char(30)
- Field (email) — char(50)
Untitled (book)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Key (kID) — char(3) — 외래 키 → Untitled.Key — NOT NULL
- Field (pDate) — date
- Field (price) — int(6)
- Field (quantity) — int(3)
- Key (pID) — char(5) — 외래 키 → Untitled.Key — NOT NULL
Untitled (topic)
- Key (tno) — int(2) — 기본 키 — NOT NULL
- Field (tName) — char(10)
Untitled (publisher)
- Key (pID) — char(5) — 기본 키 — NOT NULL
- Field (pName) — char(30)
- Field (address) — char(30)
- Field (phone) — char(11)
Untitled (mainbook)
- Key (aID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
Untitled (book_topic)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (tno) — int(2) — 외래 키 → Untitled.Key — NOT NULL
Untitled (KDC)
- Key (kID) — char(3) — 기본 키 — NOT NULL
- Field (kName) — char(5)