2023사서교육원_준사서C반_김종우_예제문제2
테이블 (4)
Untitled (Activity)
- Key (activityCode) — char(30) — 기본 키 — NOT NULL
- Field (activityName) — char(30)
- Field (activityExplanation) — char(30)
Untitled (Class)
- Key (classNumber) — char(30) — 기본 키 — NOT NULL
- Field (runningTime) — time
- Field (등록제한인원) — int
- Field (현재등록인원) — int
- Field (className) — char(30)
- Key (activityCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Member)
- Key (memberSsn) — int — 기본 키 — NOT NULL
- Field (memberName) — char(30)
- Field (memberAddress) — char(30)
- Field (memberAge) — int
- Field (memberPhoneNumber) — char(11)
- Field (memberGender) — char(11)
Untitled (Registration)
- Field (level) — char(10)
- Key (classNumber) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (fee) — int
- Field (period) — date
- Key (memberSsn) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (date) — date