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)