张茹靳

Tables (4)

Activity (Untitled)

  • activity_code (Key) — Primary key — NOT NULL
  • name (Field)

Member (Untitled3)

  • menberID (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • age (Field3)

Registration (Untitled4)

  • registrationID (Key) — Primary key — NOT NULL
  • difficultyLEVER (Field3)
  • classID (Key2) — Foreign key → class.classID — NOT NULL
  • menberID (Key3) — Foreign key → Member.menberID — NOT NULL

class (Untitled2)

  • classID (Key) — Primary key — NOT NULL
  • schedule (Field2)
  • max_participants (Field3)
  • current_participants (Field4)
  • activity_code (Key2) — Foreign key → Activity.activity_code — NOT NULL