product
Tables (4)
Activity (Untitled)
- activity_code (Key) — char — Primary key — NOT NULL
- activity name (Field) — char
- description (Field2) — text
Class (Untitled2)
- class_id (Key) — char — Primary key — NOT NULL
- activity_code (Key2) — char — Foreign key → Activity.activity_code — NOT NULL
- schedule (Field2) — char
- current_enrollment (Field3) — char
- max_capacity (Field4)
Enrollment (Untitled4)
- enrollment_id (Key) — char — Primary key — NOT NULL
- class_id (Key2) — char — Foreign key → Class.class_id — NOT NULL
- activity_code (Key22) — char — Foreign key → Class.activity_code — NOT NULL
- member_id (Key3) — char — Foreign key → Member.member_id — NOT NULL
- level (Field) — int
Member (Untitled3)
- member_id (Key) — char — Primary key — NOT NULL
- member name (Field) — char
- age (Field2) — char
- address (Field3) — char