기말
테이블 (5)
Untitled (Member)
- Key (memberID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(8)
- Field (address) — text
- Field (phoneNumber) — char(11)
Untitled (Subject)
- Field (subjectNumber) — int(1) — 기본 키
- Key (subjectName) — char(2) — NOT NULL
Untitled (Lecture)
- Key (lectureNumber) — int(2) — 기본 키 — NOT NULL
- Field (lectureName) — char(10)
- Field (lecturer) — char(5)
- Field (place) — char(10)
- Field (day) — char(3)
- Field (price) — int(6)
Untitled (Record)
- Key (memberID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (lectureNumber) — int(2) — 외래 키 → Untitled.Key — NOT NULL
- Field (subjectNumber) — int(1) — 외래 키 → Untitled.Field
Untitled (Classification)
- Key (lectureNumber) — int(2) — 외래 키 → Untitled.Key — NOT NULL
- Field (subjectNumber) — int(1) — 외래 키 → Untitled.Field