중간고사 2023913018 손지원
테이블 (5)
Untitled (BOOK)
- Key (ISBN) — char(20) — 기본 키 — NOT NULL
- Key (ssn2) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (Name) — char(20)
- Field (Date) — date
- Field (publisher) — char(20)
- Field (kdc) — char(20)
- Field (description) — text
- Key (ssn) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (ssn3) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PUBLISHER)
- Key (ssn) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (supervisor) — char(20)
- Field (callnumber) — char(20)
Untitled (PRINTING HOUSE)
- Key (ssn) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (deadline) — date
Untitled (WRITER)
- Key (ssn) — char(20) — 기본 키 — NOT NULL
- Field (Name) — char(20)
- Field (address) — char(20)
- Field (bestbook) — char(20)
Untitled (BOOKSTORE)
- Key (ssn) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (warehousingdate) — date
- Key (ssn2) — char(20) — 외래 키 → Untitled.Key — NOT NULL