2
Tables (7)
ACTIVITY (Untitled)
- actCode (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
CLASS (Untitled2)
- 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 (Key2) — char(10) — Foreign key → ACTIVITY.actCode — NOT NULL
- lecyurtrerID (Key3) — char(10) — Foreign key → LECTURER.lecyurtrerID — NOT NULL
CLASS-TIME (Untitled5)
- classID (Key2) — integer — Foreign key → CLASS.classID — NOT NULL
- timeID (Key3) — integer — Foreign key → TIME.timeID — NOT NULL
ENROLL (Untitled4)
- memID (Key2) — integer — Foreign key → MEMBER.memID — NOT NULL
- classID (Key3) — integer — Foreign key → CLASS.classID — NOT NULL
LECTURER (Untitled7)
- lecyurtrerID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(50)
- phone (Field3) — integer(20)
- description (Field4) — text
MEMBER (Untitled3)
- memID (Key) — integer — Primary key — NOT NULL
- name (Field) — char(20)
- phone (Field2) — char(20)
- address (Field3) — char(50)
- email (Field4) — email
TIME (Untitled6)
- timeID (Key) — integer — Primary key — NOT NULL
- time (Field) — char(20)