예제2_답
테이블 (8)
ACTIVITY (Activity)
- actCode (actcode) — char(10) — 기본 키 — NOT NULL
- Field (actdescription) — text
- Key (actname) — char(20) — NOT NULL
Untitled (Class)
- Key (classID) — char(10) — 기본 키 — NOT NULL
- Field (classname) — char(20)
- Field (level) — char(4)
- Field (price) — integer(10)
- Field (location) — integer(3)
- actCode (actcode) — char(10) — 외래 키 → ACTIVITY.actCode — NOT NULL
Untitled (member)
- Key (memberID) — char(10) — 기본 키 — NOT NULL
- Field (memberName) — char(20)
- Field (address) — char(50)
- Field (phone) — char(11)
- Field (birthdate) — date
- Field (gender) — char(1)
Untitled (enroll)
- Key (memberID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (classID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (ClassTime)
- Key (monClassID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (timeID2) — int(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MonthClass)
- Key (monClaID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (year) — char(4)
- Field (month) — char(2)
- Field (lectureID) — char(10)
- Key (classID) — integer — 외래 키 → Untitled.Key — NOT NULL
- Key (lectureID2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Time)
- Key (timeID) — int(6) — 기본 키 — NOT NULL
- Field (time) — char(20)
Untitled (Lecturer)
- Key (lectureID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (phone) — onteger(20)
- Field (descrition) — text