2024_10_22 중간고사
테이블 (8)
Untitled (BOOK)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (bookName) — char(40)
- Field (pubDate) — char(10)
- Field (description) — text
- Key (pubID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PUBLISHER)
- Key (pubID) — char(20) — 기본 키 — NOT NULL
- Field (pubName) — char(40)
- Field (address) — char(30)
- Field (description) — text
Untitled (AUTHOR)
- Field (autName) — char(30) — 기본 키
- Field (address) — char(30)
- Field (majorBook) — char(40)
- Field (desription) — text
Untitled (PRINT)
- Key (priID) — char(20) — 기본 키 — NOT NULL
- Field (priName) — char(40)
- Field (address) — char(30)
Untitled (KDC)
- Key (kdcNum) — char(9) — 기본 키 — NOT NULL
- Field (authorizedKeyword) — text — 기본 키
Untitled (DESCRIPTION)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (autName) — char(30) — 외래 키 → Untitled.Field
- Key (kdcNum) — char(9) — 외래 키 → Untitled.Key — NOT NULL
- Field (authorizedKeyword) — text — 외래 키 → Untitled.Field
- Field (relatedStory) — text
- Field (relatedPerson) — text
Untitled (WORK)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (autName) — char(30) — 외래 키 → Untitled.Field
Untitled (CONTRACT)
- Key (priID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (priAmount) — char(10)
- Field (contDate) — char(10)