2023_SLI_EX2
Tables (8)
ACTIVITY (Untitled)
- actCODE (Key) — Char(10) — Primary key — NOT NULL
- aerobics (Field2) — char(20)
- description (Field3) — tect
CLASS (Untitled2)
- ClassID (Key) — Char(10) — Primary key — NOT NULL
- className (Field2) — char(20)
- time (Field3) — char(50)
- classSize (Field4) — int(3)
- level (Field5) — char(4)
- lecture (Field6) — char(10)
- price (Field7) — int(6)
- location (Field8) — char(20)
- year (Field10) — char(4)
- month (Field9) — char(2)
- actCODE (Key2) — Char(10) — Foreign key → ACTIVITY.actCODE — NOT NULL
ENROLL (Untitled4)
- memberID (Key2) — char(10) — Foreign key → member.memberID — NOT NULL
- monclassID (Key) — char(10) — Foreign key → mon_class.monclassID — NOT NULL
- Field
lecture (Untitled6)
- letureID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — char(11)
- description (Field4) — tect
member (Untitled3)
- memberID (Key) — char(10) — Primary key — NOT NULL
- mamberName (Field2) — char(20)
- address (Field3) — char(30)
- phone (Field4) — char(11)
- birthdate (Field5) — date
- gender (Field6) — char(1)
mon_class (Untitled5)
- monclassID (Key) — char(10) — Primary key — NOT NULL
- name (Field2) — char(20)
- year (Field3) — char(4)
- month (Field4) — char(2)
- letureID (Key2) — char(10) — Foreign key → lecture.letureID — NOT NULL
- ClassID (Key3) — Char(10) — Foreign key → CLASS.ClassID — NOT NULL
time (Untitled7)
- TimeID (Key) — char(50) — Primary key — NOT NULL
- Time (Field) — char(50)
time (Untitled8)
- TIME (Key) — Primary key — NOT NULL
- TimeID (Key2) — char(50) — Foreign key → time.TimeID — NOT NULL
- monclassID (Key3) — char(10) — Foreign key → mon_class.monclassID — NOT NULL