3周 课堂

Tables (7)

ACTIVITY (Untitled)

  • actCode (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text

CLASS (Untitled3)

  • classID (Key) — integer — Primary key — NOT NULL
  • className (Field) — char(30)
  • year (Field2) — integer(4)
  • month (Field3) — integer(2)
  • level (Field4) — char(2)
  • description (Field5) — text
  • price (Field6) — integer(10)
  • capacity (Field7) — integer(3)
  • lecturerID (Field8) — char(10)
  • actCode (Field9) — char(10)
  • actCode (Key2) — char(10) — Foreign key → ACTIVITY.actCode — NOT NULL
  • lecturerID (Key3) — char(10) — Foreign key → LECTURER.lecturerID — NOT NULL

CLASS TIME (Untitled2)

  • classID (Key2) — integer — Foreign key → CLASS.classID — NOT NULL
  • timeID (Key3) — integer — Foreign key → TIME.timeID — NOT NULL

ENROLL (Untitled7)

  • memID (Key) — integer — Foreign key → MEMBER.memID — NOT NULL
  • classID (Key2) — integer — Foreign key → CLASS.classID — NOT NULL

LECTURER (Untitled5)

  • lecturerID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(20)
  • place (Field3) — integer(20)
  • description (Field4) — text

MEMBER (Untitled6)

  • memID (Key) — integer — Primary key — NOT NULL
  • name (Field) — char(20)
  • phone (Field2) — char(20)
  • address (Field3) — char(50)
  • email (Field4) — email

TIME (Untitled4)

  • timeID (Key) — integer — Primary key — NOT NULL
  • time (Field) — char(20)