기말고사(곽슬비)
테이블 (4)
LIBRARY (MEMBER)
- Key (memberID) — int(8) — 기본 키 — NOT NULL
- Field (name) — char(5)
- Field (birthdate) — date
- Field (gender) — char(1)
Untitled (PROGRAM)
- Key (programCode) — int(3) — 기본 키 — NOT NULL
- Field2 (title) — char(20)
- Field3 (date) — date
- Field (time) — char(3)
- Field (target) — char(20)
- Field (location) — char(20)
- Field (description) — text
- Key (lecturerID) — int(2) — 외래 키 → Untitled.Key — NOT NULL
Untitled (ENROLL)
- Key (memberID) — int(8) — 외래 키 → LIBRARY.Key — NOT NULL
- Key (programCode) — int(3) — 외래 키 → Untitled.Key — NOT NULL
Untitled (LECTURER)
- Key (lecturerID) — int(2) — 기본 키 — NOT NULL
- Field (name) — char(5)
- Field (job) — char(20)