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