exercise2 모범
테이블 (5)
ACTIVITY (Untitled)
- activityID (Key) — char(10) — 기본 키 — NOT NULL
- activityName (Field) — char(30)
- description (Field2) — longtxt
CLASS (Untitled2)
- classID (Key) — char(30) — 기본 키 — NOT NULL
- className (Field) — char(30)
- time (Field3) — char(30)
- price (Field4) — int
- level (Field5) — char(10)
- memberLimited (Field6) — int
- year (Field2) — int(4)
- month (Field7) — int(2)
- activityID (Key2) — char(10) — 외래 키 → ACTIVITY.activityID — NOT NULL
- lecturerID (Key3) — char(10) — 외래 키 → LECTURER.lecturer — NOT NULL
ENROLL (Untitled3)
- memberID (Key2) — char(10) — 외래 키 → MEMBER.memberID — NOT NULL
- classID (Key3) — char(30) — 외래 키 → CLASS.classID — NOT NULL
- paymentYN (Field) — char
LECTURER (Untitled5)
- lecturer (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(15)
- address (Field3) — char(50)
- grade (Field4)
- description (Field5) — longtxt
MEMBER (Untitled4)
- memberID (Key) — char(10) — 기본 키 — NOT NULL
- mamberName (Field) — char(30)
- address (Field2) — char(50)
- phone (Field3) — char(15)
- email (Field4) — char(20)
- birthDate (Field5) — date