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