중간고사대체과제(24-1)
테이블 (9)
BOOK
- Key (book_ID) — int(20) — 기본 키 — NOT NULL
- Key (publisher-ID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — char(40)
- Field (isbn) — char(18)
- Field (publisher) — char(20)
- Field (summary) — text
- Field (status) — char(3)
- Field (type) — char(10)
- Field (price) — int(10)
- Field
Untitled (PUBLISHER)
- Key (publisher-ID) — int(20) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(40)
- Field (publication_Year) — int(4)
Untitled (MEMBER)
- Key (member_ID) — int(20) — 기본 키 — NOT NULL
- Key (loan_ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(40)
- Field (phone) — char(13)
- Field (e-mail) — char(30)
Untitled (LOAN)
- Key (loan_ID) — char(30) — 기본 키 — NOT NULL
- Field (book_ID) — int(20)
- Field (member_ID) — int(20)
- Field (loan_Date) — date
- Field (due_Date) — date
- Field (return_Date) — date
- Field (overdue_Fee) — int(10)
Untitled (AUTHOR)
- Key (authorID) — int(20) — 기본 키 — NOT NULL
- Key (book_ID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (publisher-ID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(40)
- Field (address) — char(40)
Untitled (CATEGORY)
- Key (KDC) — int(3) — 기본 키 — NOT NULL
- Field (keyword) — text
Untitled (BOOK_AUTHOR)
- Key (book_ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
- Key (publisher-ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
- Field (bookID) — int(20)
- Field (authorID) — int(20)
Untitled (BOOK_CATEGORY)
- Key (bookID) — int(20) — 기본 키 — NOT NULL
- Key (book_ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
- Key (publisher-ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
- Key (KDC) — int(3) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK_LOAN)
- Key (book_ID) — int(20) — 기본 키 — NOT NULL
- Key (book_ID2) — int(20) — 외래 키 → BOOK.Key — NOT NULL
- Key (publisher-ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
- Key (loan_ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (member_ID) — int(20)