example_2
Tables (4)
Activity
- Key (aID) — int(5) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (description) — text
Untitled (Class)
- Key (cID) — char(6) — Primary key — NOT NULL
- Key (aID) — int(5) — Foreign key → Activity.Key — NOT NULL
- Field (name)
- Field (level)
- Field (openTime) — char(5)
- Field (closeTime) — char(5)
- Field (limitedNo) — int(10)
- Field2 (joiningNo) — int(10)
Untitled (Member)
- Key (mID) — int(5) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(30)
- Field (age) — int(3)
Untitled (Registration)
- Key (Number) — int(4) — Primary key — NOT NULL
- Key (cID) — char(6) — Foreign key → Untitled.Key — NOT NULL
- Key (aID) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Key (mID) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Field (date) — date