Project1_Excercise2_0923
Tables (4)
CLASS
- FK (Class ID) — INT(20) — Primary key — NOT NULL
- FK (Part ID) — INT(20) — Primary key — NOT NULL
- FK (Class ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- FK (Member ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- FK (Sports Code) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- Field (Activity Code) — INT(100)
- Field (Start Time) — INT(100)
- Field2 (End Time) — INT(100)
- Field (Max Member No) — INT(100)
- Field2 (Current Member No) — INT(100)
LEVEL
- FK (Class ID) — INT(20) — Primary key — NOT NULL
- FK (Member ID) — INT(20) — Primary key — NOT NULL
- FK (Sports Code) — INT(20) — Primary key — NOT NULL
- Field2 (Location) — CHAR(100)
MEMBER
- PK (Member ID) — INT(20) — Primary key — NOT NULL
- FK (Class ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- FK (Member ID2) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- FK (Sports Code) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- Field (Member Name) — CHAR(100)
- Field (Address) — CHAR(200)
- Field (Age) — INT(20)
SPORTS
- PK (Sports Code) — INT(20) — Primary key — NOT NULL
- FK (Class ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- FK (Member ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
- Field (Sports Description) — CHAR(100)