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