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