202291300ERD2
Tables (8)
ACTIVITY (Untitled5)
- Key — char(10) — Primary key — NOT NULL
- Field — char(20)
- Field2 — text
CLASS (Untitled3)
- Key — char(10) — Primary key — NOT NULL
- Field — char(20)
- Field2 — char(5)
- Field3 — char(10)
- Field4 — int(50)
- Field5 — int(50)
- Key (Key2) — char(20) — Foreign key → LEISURESPORTS.Key — NOT NULL
- Key (Key3) — char(10) — Foreign key → REGISTER.Key — NOT NULL
- Field6 — int(10)
- Key (Key4) — char(10) — Foreign key → LECTURER.Key — NOT NULL
CLASS_TIME (Untitled6)
- Key — char(10) — Foreign key → CLASS.Key — NOT NULL
- Key (Key2) — int(10) — Foreign key → TIME.Key — NOT NULL
LECTURER (Untitled8)
- Key — char(10) — Primary key — NOT NULL
- Field — char(20)
- Field2 — char(30)
- Field3 — int(20)
- Field4 — text
LEISURESPORTS (Untitled)
- Key — char(20) — Primary key — NOT NULL
- Field — char(20)
- Field2 — text
- Key (Key2) — char(10) — Foreign key → ACTIVITY.Key — NOT NULL
REGISTER (Untitled4)
- Key — char(10) — Primary key — NOT NULL
- Key (Key2) — char(10) — Foreign key → STUDENT.Key — NOT NULL
STUDENT (Untitled2)
- Key — char(10) — Primary key — NOT NULL
- Field — char(20)
- Field2 — char(30)
- Field3 — int(2)
TIME (Untitled7)
- Key — int(10) — Primary key — NOT NULL
- Field — char(10)
- Field2