SchoolSystem

Tables (7)

Untitled (student)

  • s_id (student id) — int — Primary key — NOT NULL
  • Field — varchar — Primary key — NOT NULL
  • email (student email) — varchar
  • phone (student phone number) — varchar
  • Field2

Untitled (passport)

  • Key (p_id) — Primary key — NOT NULL
  • Field (ssn)

Untitled (person)

  • Key — Primary key — NOT NULL

Untitled

  • Key (u_id) — Primary key — NOT NULL

Untitled2 (post)

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL

class

  • c_id (Key) — varchar — Primary key — NOT NULL
  • c_name (class name) — varchar
  • score — int
  • Field — varchar
  • Field2

enrollment

  • Key (e_id) — int — Primary key — NOT NULL
  • c_id (Key) — varchar — Foreign key → class.c_id — NOT NULL
  • s_id (student id) — int — Foreign key → Untitled.s_id — NOT NULL
  • Field (Field2) — varchar — Foreign key → Untitled.Field — NOT NULL
  • Field (s_id) — int
  • Field (c_id) — varchar
  • Field (e_score) — char
  • Field