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
- STD_ID (Student ID) — int — Foreign key → STudent.STD_ID — NOT NULL
- c_ID (Class ID) — varchar — Foreign key → Class.c_ID — NOT NULL
- e_score (student enroll grade) — char
- Field
STudent (Untitled)
- STD_ID (Student ID) — int — Primary key — NOT NULL
- Name (Student Name) — varchar
- Email (Student Email) — varchar
- Phone (Student phone number) — int
- Field
USER (Untitled6)
- u_id (Key) — Primary key — NOT NULL
passport (Untitled5)
- Key — Primary key — NOT NULL
- ssn (Key2) — Foreign key → person.ssn — NOT NULL
person (Untitled4)
- ssn (Key) — Primary key — NOT NULL
posts (Untitled7)
- p-ID (Key) — Primary key — NOT NULL
- u_id (Key2) — Foreign key → USER.u_id — NOT NULL