Exercise2
Tables (4)
ACTIVITY
- Key (actCode) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field2 (description) — text
SPORTS
- Key (code) — char(10) — Primary key — NOT NULL
- Field (direction) — text
- Field2
- Field3
Untitled (CLASS)
- Key (classID) — integer — Primary key — NOT NULL
- Field (classname) — char(30)
- Field2 (time) — char(30)
- Field3 (limite) — char(30)
- Field4 (registration) — char(30)
- Field5 (year) — integer(2)
- Field6 (month)
- Field
- Field2
- Field3
- Field4
- Key (actCode) — char(10) — Foreign key → ACTIVITY.Key — NOT NULL
Untitled (MEMBER)
- Key (memID) — char(10) — Primary key — NOT NULL
- Field (name) — char(15)
- Field (adress) — char(15)
- Field (age) — char(15)
- Field (leveltest) — char(15)
- Field