1007
Tables (4)
Untitled (MEMBER)
- Key (memberID) — char(15) — Primary key — NOT NULL
- Field (name) — char(15)
- Field (address) — char(40)
- Field (age) — char(2)
Untitled (CLASS)
- Key (classNo) — char(3) — Primary key — NOT NULL
- Field (classname) — char(20)
- Field (enrolledNo) — char(2)
- Field (limiterNo) — char(12)
- Field (operatingtime) — time
- Key (activityCode) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Field (classLevel) — char(1)
Untitled (ACTIVITY)
- Key (activityCode) — char(15) — Primary key — NOT NULL
- Field (activityname) — char(15)
- Field (activityDescription) — text(200)
Untitled (RLEVEL)
- Field (memberLevel) — char(1)
- Key (memberID) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Key (classNo) — char(3) — Foreign key → Untitled.Key — NOT NULL