2024.10.22준서서B반이혜청
테이블 (5)
Untitled (BOOK)
- Key (bookID) — char(10) — 기본 키 — NOT NULL
- Field (ISBN) — char(13)
- Field (title) — char(30)
- Field (writer) — char(2)
- Field (publisher) — char(10)
- Field (publication Date) — Date
Untitled (PUBLISHR)
- Key (publisherID) — char(10) — 기본 키 — NOT NULL
- Field (publisherNane) — char(20)
- Field (address) — char(50)
- Field (phone) — char(20)
- Field (email) — email
- Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WRITER)
- Key (writerID) — char(10) — 기본 키 — NOT NULL
- Key (quintityID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (bookID2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (writerName) — char(20)
- Field (representativeTitle) — char(30)
- Field
- Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PRINTING)
- Key (printingID) — char(10) — 기본 키 — NOT NULL
- Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (printingName) — char(20)
- Field (address) — char(50)
- Field (phone) — char(20)
- Field (email) — email
Untitled (CONTRACT)
- Key (quintityID) — char(10) — 기본 키 — NOT NULL
- Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL