my_erd_01
Tables (10)
ACTIVITY
- ActCode (activityID) — int(20) — Primary key — NOT NULL
- Field (activityName) — char(50)
- Field (description) — text
Untitled (MEMBER)
- Key (memberID) — int(20) — Primary key — NOT NULL
- Field (memName) — char(50)
- Field (memberAdress) — char(100)
- Field (memberPhone) — char(11)
- Field (memberBirthdate) — char(10)
- Field (memberGender) — char(10)
Untitled (SEMCLA_MEMBER)
- Key (memberID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (semClassID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (TIME)
- Key (timeID) — int(20) — Primary key — NOT NULL
- Field (time) — char(50)
Untitled (SEMCLASS_TIME)
- Key (timeID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (semClassID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (SEMESTERCLASS)
- Key (semClassID) — int(20) — Primary key — NOT NULL
- Field (semClassName) — char(50)
- Field (semClassYear) — char(4)
- Field (semClassMonth) — char(2)
- Key (classID2) — int(20) — Foreign key → Untitled2.Key — NOT NULL
- Key (lecturerID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (LECTURER)
- Key (lecturerID) — int(20) — Primary key — NOT NULL
- Field (lecturerName) — char(50)
- Field (lecturerAdress) — char(100)
- Field (lecturerPhone) — char(11)
- Field (lecturerBirthdate) — char(10)
- Field (lecturerGender) — char(10)
Untitled (LICENCE)
- Key (licenceID) — int(20) — Primary key — NOT NULL
- Field (licenceName) — char(50)
- Field (licenceLevel) — char(10)
- Field (licenceYear) — char(10)
- Field (description) — text
Untitled (MEM_LICENCE)
- Key (licenceID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (memberID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (CLASS)
- Key (classID) — int(20) — Primary key — NOT NULL
- Field (classTitle) — char(50)
- Field (classSize) — char(10)
- Field2 (classLevel) — char(10)
- Field (classPrice) — int(10)
- Field (classLocation) — char(50)
- ActCode (activityID) — int(20) — Foreign key → ACTIVITY.ActCode — NOT NULL