3
Tables (4)
ACTIVITY (Untitled)
- activityID (Key) — int(10) — Primary key — NOT NULL
- activityName) (Field) — char(10)
- description (Field2) — char(20)
CLASS (Untitled2)
- classNo (Key) — int(10) — Primary key — NOT NULL
- activityID (Key2) — int(10) — Foreign key → ACTIVITY.activityID — NOT NULL
- time (Field) — int(4)
- Max_Enrollment (Field2) — int(20)
- Current_Enrollment (Field3) — int(20)
ENROLLMENT (Untitled4)
- enrollmentID (Key) — int(10) — Primary key — NOT NULL
- memberNo (Key3) — int(10) — Foreign key → MEMBER.memberNo — NOT NULL
- classNo (Key2) — int(10) — Foreign key → CLASS.classNo — NOT NULL
- activityID (Key22) — int(10) — Foreign key → CLASS.activityID — NOT NULL
MEMBER (Untitled3)
- memberNo (Key) — int(10) — Primary key — NOT NULL
- memberName (Field) — char(10)
- adress (Field2) — char(20)
- age (Field3) — int(2)