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)