Exercise_2_ACTIVITY
Tables (4)
CLASS
- classID — char(10) — Primary key — NOT NULL
- exerID (time) — char(50)
- time (level) — char(4)
- exerID (actID) — char(10) — Foreign key → EXERCISE.exerID — NOT NULL
- Field (information) — text
- Field2 (classSize) — int(3)
- Field (lecturer) — char(10)
- Field (price) — int(6)
- Field (location) — char(20)
- Field (year) — char(4)
- Field2 (month) — char(2)
EXERCISE (ACTIVITY)
- exerID (actID) — char(10) — Primary key — NOT NULL
- exerName (actName) — char(20)
- Field (description) — text
MEMBER
- memberID — char(10) — Primary key — NOT NULL
- name — char(20)
- address — char(50)
- Field3 (phone) — char(10)
- Field4 (birthDate) — date
- Field (gender) — char(2)
Untitled (ENROLL)
- memberID — char(10) — Foreign key → MEMBER.memberID — NOT NULL
- classID — char(10) — Foreign key → CLASS.classID — NOT NULL