ex2
Tables (4)
Activity+ (Untitled)
- activity_code (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- activity_code (Key2) — Foreign key → Activity+.activity_code — NOT NULL
Class (Untitled2)
- class_id (Key) — Primary key — NOT NULL
- activity_code (Key2) — Foreign key → Activity+.activity_code — NOT NULL
- name (Field)
- time_info (Field2)
- activity_code (Field3)
- max_participants (Field4)
- current_participants (Field5)
Member (Untitled3)
- member_id (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- age (Field3)
Registration (Untitled4)
- registration_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → Member.member_id — NOT NULL
- class_id (Key3) — Foreign key → Class.class_id — NOT NULL
- activity_code (Key22) — Foreign key → Class.activity_code — NOT NULL
- member_id (Field2)
- class_id (Field3)
- level (Field4)