LEPORTS
Tables (4)
Untitled (Activity)
- Key (Activity_Code) — char(10) — Primary key — NOT NULL
- Field (Activity_Name) — char(10)
- Field (Activity_Description) — text
Untitled (Class)
- Key (Class_ID) — char(10) — Primary key — NOT NULL
- Field (Activity_Code) — char(10)
- Field (Schedule) — char(15)
- Field (Max_Enrollment) — int(10)
- Field (FieldCurrent_Enrollment) — int(10)
- Key (Activity_Code2) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Member)
- Key (Member_ID) — char(10) — Primary key — NOT NULL
- Field (Name) — char(15)
- Field (Address) — char(30)
- Field (Age) — int(2)
Untitled (Registration)
- Key (Registration_ID) — char(10) — Primary key — NOT NULL
- Field (Member_ID) — char(10)
- Field (Class_ID) — char(10)
- Field (Difficulty_Level) — char(3)
- Key (Class_ID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (Member_ID2) — char(10) — Foreign key → Untitled.Key — NOT NULL