Exercise_2_ACTIVITY

Tables (4)

CLASS

  • classID — char(10) — Primary key — NOT NULL
  • exerID (time) — char(50)
  • time (level) — char(4)
  • exerID (actID) — char(10) — Foreign key → EXERCISE.exerID — NOT NULL
  • Field (information) — text
  • Field2 (classSize) — int(3)
  • Field (lecturer) — char(10)
  • Field (price) — int(6)
  • Field (location) — char(20)
  • Field (year) — char(4)
  • Field2 (month) — char(2)

EXERCISE (ACTIVITY)

  • exerID (actID) — char(10) — Primary key — NOT NULL
  • exerName (actName) — char(20)
  • Field (description) — text

MEMBER

  • memberID — char(10) — Primary key — NOT NULL
  • name — char(20)
  • address — char(50)
  • Field3 (phone) — char(10)
  • Field4 (birthDate) — date
  • Field (gender) — char(2)

Untitled (ENROLL)

  • memberID — char(10) — Foreign key → MEMBER.memberID — NOT NULL
  • classID — char(10) — Foreign key → CLASS.classID — NOT NULL