기말고사
테이블 (5)
Untitled (Member)
- Key (ssn) — char(13) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (phone) — char(11)
- Field (address) — char(30)
Untitled (Book)
- Key (BookID) — char(13) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (author) — char(30)
- Field (publisher) — char(30)
- Field (pubyear) — int(4)
Untitled (Program)
- Key (ProgramID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field (date) — char(20)
- Field (capacity) — integer(3)
Untitled (Enroll)
- Key (ProgramID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (ssn) — char(13) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Bookloan)
- Key (BookloanID) — char(13) — 기본 키 — NOT NULL
- Field (loandate) — char(20)
- Field (returndate) — char(20)
- Key (BookID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (ssn) — char(13) — 외래 키 → Untitled.Key — NOT NULL