ERD第二个
Tables (6)
ACTIVITY
- Key (actID) — char(10) — Primary key — NOT NULL
- Field (actName) — char(10)
- Field (description) — text
Untitled (CLASS)
- Key (claID) — char(10) — Primary key — NOT NULL
- Field (name) — char(10)
- Key (actID) — char(10) — Foreign key → ACTIVITY.Key — NOT NULL
Untitled (VIP)
- Key (vipID) — char(30) — Primary key — NOT NULL
- Key (memID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (age) — int(2)
- Field (classname) — char(30)
- Field (registerdata) — char(30)
- Key (claID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MEMBERSINFORMATION)
- Key (memID) — char(30) — Primary key — NOT NULL
- Field (classname) — char(30)
- Field (datatime) — char(30)
- Field (maximummembers) — int(2)
Untitled (CLASSINFORMATION)
- Key (claID) — int(5) — Primary key — NOT NULL
- Key (claID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (activity) — char(10)
- Field (production) — char(10)
Untitled (CLASSLEVEL)
- Key — Primary key — NOT NULL
- Key (claID) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Key (claID2) — char(10) — Foreign key → Untitled.Key — NOT NULL