중간고사2024
테이블 (8)
Untitled (Book)
- Key (ISBN) — int — 기본 키 — NOT NULL
- Field (boTitle) — char(30)
- Field (boPublicationDate) — date
- Key (pubID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Publisher)
- Key (pubID) — int — 기본 키 — NOT NULL
- Field (pubName) — char(20)
- Field (pubAddress) — text
Untitled (Author)
- Key (AutID) — int — 기본 키 — NOT NULL
- Field (autName) — char(20)
- Field (autAddress) — text
Untitled (BookAuthor)
- Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (AutID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Subject)
- Key (subID) — int — 기본 키 — NOT NULL
- Field (KDCNumber) — int
- Field (subKeyword) — char(30)
Untitled (BookSubject)
- Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (subID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (User)
- Key (usID) — int — 기본 키 — NOT NULL
- Field (usName) — char(20)
- Field (usAddress) — text
- Field (usPhoneNumber) — char(11)
- Field (usEmail) — char(30)
Untitled (Loan)
- Key (loanID) — int — 기본 키 — NOT NULL
- Field (loanDate) — date
- Field (loanReturnDate) — date
- Key (usID) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL