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