ERD_02
Tables (4)
Untitled (REPORTS)
- Key (codeNo) — int(6) — Primary key — NOT NULL
- Field (description) — text
- Field (classNo) — int(10)
Untitled (CLASS)
- Key (classNo) — int(6) — Primary key — NOT NULL
- Field (codeNo) — int
- Field (openHour) — time
- Field (description) — text
- Field (limitedNo) — int(10)
- Field (curruntNo) — int(10)
- Key (codeNo2) — int(6) — Foreign key → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (memberNo) — int(10) — Primary key — NOT NULL
- Field (name) — char
- Field (address) — char
- Field (age) — int(10)
- Field (classLevel) — int(5)
Untitled (CLASS_MEMBER)
- Key (classNo) — int(6) — Foreign key → Untitled.Key — NOT NULL
- Key (memberNo) — int(10) — Foreign key → Untitled.Key — NOT NULL