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)