E2
Tables (10)
ACTIVITY
- Key (activityID) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
Untitled (CLASS)
- Key (classID) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (level) — char(1)
- Key (actID) — char(30) — Foreign key → ACTIVITY.Key — NOT NULL
Untitled (MEMBER)
- Key (memID) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
- Field (age) — char(2)
- Field (signUpDate) — date
Untitled (TIME)
- Key (timeID) — char(30) — Primary key — NOT NULL
- Field (startTime) — time
- Field (endTime) — time
Untitled (DAY)
- Key (dayID) — char(1) — Primary key — NOT NULL
- Field (dayname) — char(10)
Untitled (LOCATION)
- Key (locationID) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
Untitled (CLASS_LOCATION)
- Key (classID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (locationID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (CLASS_TIME)
- Key (classID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (timeID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (CLASS_DAY)
- Key (classID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (dayID) — char(1) — Foreign key → Untitled.Key — NOT NULL
Untitled (CLASS_MEMBER)
- Key (memID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (classID) — char(30) — Foreign key → Untitled.Key — NOT NULL