20251001-2
Tables (4)
Activity
- Key (activityCode) — char — Primary key — NOT NULL
- Field (description) — char
Untitled (CLASS)
- Key (classNumber) — char — Primary key — NOT NULL
- Key (activityCode) — char — Foreign key → Activity.Key — NOT NULL
- Field (schedule) — char
- Field (capacity) — int
- Field (currentEnrollment) — int
- Field (InstructorName) — char
- Field (level) — int
Untitled (MEMBER)
- Key (memberID) — char — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(30)
- Field (age) — int
Untitled (REGISTRATION)
- Key (memberID) — char — Foreign key → Untitled.Key — NOT NULL
- Key (classNumber) — char — Foreign key → Untitled.Key — NOT NULL
- Key (activityCode) — char — Foreign key → Untitled.Key — NOT NULL