Schoolsystem
Tables (7)
class (Untitled2)
- c_id (class id) — varchar — Primary key — NOT NULL
- c_name (class name) — varchar
- score — int
- day (Field) — varchar
- Field2
enrollment (Untitled3)
- e_id (enrollment number) — int — Primary key — NOT NULL
- s_id (student id) — int — Foreign key → student.s_id — NOT NULL
- c_id (class id) — varchar — Foreign key → class.c_id — NOT NULL
- e_score (enrollment score number) — char
- Field
passport (Untitled5)
- p_id (Key) — Primary key — NOT NULL
- ssn (Key2) — Foreign key → peron.ssn — NOT NULL
peron (Untitled4)
- ssn (Key) — Primary key — NOT NULL
post (Untitled7)
- p_id (Key) — Primary key — NOT NULL
- u_id (users) — Foreign key → user.u_id — NOT NULL
student (Untitled)
- s_id (student id) — int — Primary key — NOT NULL
- Field — varchar
- email (student email) — varchar
- phone (student phone number) — varchar
- Field2
user (Untitled6)
- u_id (users) — Primary key — NOT NULL