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)