ex2
Tables (5)
Untitled (CLASS)
- Key (classID) — int — Primary key — NOT NULL
- Field (runningTime) — time
- Field (activitycode) — char(30)
- Field2 (DifficultyLevel) — int
- Key (execiseID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (EXECISE)
- Key (execiseID) — int — Primary key — NOT NULL
- Field (execiseinfo) — text
Untitled (Customer)
- Key (CustomerID) — int — Primary key — NOT NULL
- Field (customerName) — char(20)
- Field (customerAddress) — char(30)
- Field (customerAge) — int
Untitled (Classinformation)
- Key (classID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (Current registered information) — text
- Field (Registration limit) — int
Untitled (Customer-class Link)
- Key (classID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (CustomerID) — int — Foreign key → Untitled.Key — NOT NULL