1
Tables (4)
activity (Untitled)
- activity_code (Key) — Primary key — NOT NULL
- description (Field)
class (Untitled2)
- class_id (Key) — Primary key — NOT NULL
- activity_code (Key3) — Foreign key → activity.activity_code — NOT NULL
- operating hours (Field)
- restricted number of registered persons (Field2)
- current enrollment personnel (Field3)
- member_id (Key4) — Foreign key → member.member_id — NOT NULL
form (Untitled4)
- form_id (Key) — Primary key — NOT NULL
- activity_code (Key4) — Foreign key → activity.activity_code — NOT NULL
- difficulty level (Field)
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
- class_id (Key3) — Foreign key → class.class_id — NOT NULL
- activity_code (Key32) — Foreign key → class.activity_code — NOT NULL
member (Untitled3)
- member_id (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- age (Field3)