Exercise2
Tables (5)
Untitled (Members)
- Key (memberName) — char(20) — Primary key — NOT NULL
- Field (memberADD) — text
- Field (memberAge) — int(2)
- Field (Level) — int(2)
- Key (categoryID) — INT(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Activity)
- Key (ActivityID) — int(10) — Primary key — NOT NULL
- Field (ActivityName) — char(20)
- Field (ActivityDes) — longtext
- Key (memberName) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (Class)
- Key (ClassID) — int(10) — Primary key — NOT NULL
- Field (ClassNumber) — int(10)
- Field (ClassTime) — int(10)
- Field (Level) — int(2)
- Key (ActivityID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (ClassINTO)
- Key (ClassID2) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (RegisterNumber) — int(10)
- Field (CurrentNumber) — int(10)
- Field (Level) — int(10)
Untitled (LevelCategory)
- Key (categoryID) — INT(10) — Primary key — NOT NULL
- Field (분류명) — char(20)