SchoolSystem
Tables (7)
Class (Untitled2)
- c_id (class id) — Varchar — Primary key — NOT NULL
- c_name (class name) — Varchar
- score — int
- day (class day) — varchar
- Field
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 (enroll score number) — char
- Field
Passport (Untitled5)
- p_id (Key) — Primary key — NOT NULL
- ssn (Key2) — Foreign key → person.ssn — 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
- Name (Student name) — varchar
- Email (Student Email) — Varchar
- Phone (Student Phone Number) — Varchar
- Field
User (Untitled6)
- u_id (Key) — Primary key — NOT NULL
person (Untitled4)
- ssn (Key) — Primary key — NOT NULL