SchoolSystem
Tables (7)
Post (Untitled6)
- p_id (Key) — Primary key — NOT NULL
- su_id (Key2) — Foreign key → User.su_id — NOT NULL
User (Untitled5)
- su_id (Key) — Primary key — NOT NULL
class (Untitled2)
- c_id (class id) — varchar — Primary key — NOT NULL
- c_name (class name) — varchar
- score — int
- Field — varchar
- Field2
enrollment
- e_id (enrollnumber) — int — Primary key — NOT NULL
- c_id (class id) — varchar — Foreign key → class.c_id — NOT NULL
- s_id (student id2) — int — Foreign key → student.s_id — NOT NULL
- s_id (student id) — int
- c_id (key) — varchar
- e_score (enrollscorenumber) — char
- Field
passport (Untitled4)
- p_id (Key) — Primary key — NOT NULL
- ssn (Key2) — Foreign key → person.ssn — NOT NULL
- ssn (key2)
person (Untitled3)
- ssn (Key) — Primary key — NOT NULL
student (Untitled)
- s_id (student id) — int — Primary key — NOT NULL
- name (student's name) — varchar
- email (gmail of students) — varchar
- phone (phonenumber) — char
- Field