SchoolSystem
Tables (5)
class (Untitled2)
- class id (class) — varchar — Primary key — NOT NULL
- score — int
- 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
- class id (class) — varchar — Foreign key → class.class id — NOT NULL
- c_id (key) — varchar
- e_score (enrollment 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
student (Untitled)
- s_id (student id) — int — Primary key — NOT NULL
- field — varchar
- email (student email) — varchar
- phone (student phone number) — varchar
- field2 (Field2)