SchoolSystem
Tables (7)
Untitled (student)
- s_id (student id) — int — Primary key — NOT NULL
- Field — varchar — Primary key — NOT NULL
- email (student email) — varchar
- phone (student phone number) — varchar
- Field2
Untitled (passport)
- Key (p_id) — Primary key — NOT NULL
- Field (ssn)
Untitled (person)
- Key — Primary key — NOT NULL
Untitled
- Key (u_id) — Primary key — NOT NULL
Untitled2 (post)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
class
- c_id (Key) — varchar — Primary key — NOT NULL
- c_name (class name) — varchar
- score — int
- Field — varchar
- Field2
enrollment
- Key (e_id) — int — Primary key — NOT NULL
- c_id (Key) — varchar — Foreign key → class.c_id — NOT NULL
- s_id (student id) — int — Foreign key → Untitled.s_id — NOT NULL
- Field (Field2) — varchar — Foreign key → Untitled.Field — NOT NULL
- Field (s_id) — int
- Field (c_id) — varchar
- Field (e_score) — char
- Field