2024.10.13-2

Tables (4)

Untitled (ACTIVITIES)

  • Key (activityID) — char(10) — Primary key — NOT NULL
  • Field (activityName) — char(15)
  • Field (codeNumber) — char(20)
  • Field (explain) — text

Untitled (MEMBER)

  • Key (memberID) — char(10) — Primary key — NOT NULL
  • Field (memberName) — char(10)
  • Field (birthDate) — date
  • Field (address) — char(30)
  • Field (phone) — char(11)

Untitled (CLASS)

  • Key (classID) — char(10) — Primary key — NOT NULL
  • Field (lesson) — time
  • Field (instructorName) — char(10)
  • Field (memberEnroll) — int(2)
  • Field (memberControl) — int(2)
  • Key (memberID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (CLASS_PART)

  • Key (activityID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (classID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (classLevel) — int(1)