es2

Tables (4)

activity (Untitled)

  • activity (Key) — Primary key — NOT NULL
  • activityName (Field)
  • description (Field2)
  • memberidy (Key2) — Foreign key → member.memberidy — NOT NULL

class (Untitled2)

  • classid (Key) — Primary key — NOT NULL
  • className (Field)
  • aerobicld (Field2)
  • yogald (Field3)
  • swimmingld (Field4)
  • time (Field5)
  • price (Field6)
  • level (Field7)
  • activity (Key2) — Foreign key → activity.activity — NOT NULL

enroll (Untitled4)

  • enrolID (Key) — Primary key — NOT NULL
  • paymentYn (Field) — Primary key
  • classid (Key2) — Foreign key → class.classid — NOT NULL
  • memberidy (Key3) — Foreign key → member.memberidy — NOT NULL

member (Untitled3)

  • memberidy (Key) — Primary key — NOT NULL
  • memberName (Field)
  • address (Field2)
  • phone (Field3)
  • email (Field4)
  • birthDate (Field5)