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)