SchoolSystem
Tables (5)
class (untitled2)
- class id (class) — varchar — Primary key — NOT NULL
- class name — varchar
- score — int
- field (Field) — varchar
- field2 (Field2)
enrollment (Untitled3)
- e_id (enroll number) — int — Primary key — NOT NULL
- Key (studentid) — int — Foreign key → student.Key — NOT NULL
- class id (class) — varchar — Foreign key → class.class id — NOT NULL
- s_id (studient id) — int
- c_id (key) — varchar
- e_score (enroll score number) — char
- field (Field)
passport (Untitled2)
- 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)
- Key (studentid) — int — Primary key — NOT NULL
- email (student email) — varchar
- phone (student phone number) — varchar
- Field