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