2024.04 ex2
Tables (5)
Untitled (Activity)
- Field (ActCode) — char(5) — Primary key
- Field (Descrition) — text
- Key (Act name) — char(20) — NOT NULL
Untitled (Class)
- Key (ClassID) — char(10) — Primary key — NOT NULL
- Field (ActCode) — char(5) — Foreign key → Untitled.Field
- Field (Time) — char(20)
- Field (limit member) — int(5)
- Field (Class name) — char(20)
- Field (Level) — Int(4)
- Key (Led ID) — Char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Member)
- Key (memberID) — Char(10) — Primary key — NOT NULL
- Field (name) — Char(20)
- Field (Birth date) — date
- Field (adress) — char(50)
- Field (Phone) — char(12)
- Field (email) — email
Untitled (Enroll)
- Key (memberID) — Char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ClassID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (ActCode) — char(5) — Foreign key → Untitled.Field
Untitled (Lecturer)
- Key (Led ID) — Char(10) — Primary key — NOT NULL
- Field (name) — Char(20)
- Field (adress) — Char(50)
- Field (Phon e) — char(12)
- Field (Descrition) — text