SchoolSystem

Tables (7)

Untitled3 (enrollenment)

  • Key (e-id) — int — Primary key — NOT NULL
  • s-id (student-id) — int — Foreign key → student.s-id — NOT NULL
  • Field (e-score) — char
  • Field

Untitled3 (person)

  • Key — Primary key — NOT NULL

Untitled3 (my name)

  • Key (s-num) — num — Primary key — NOT NULL
  • Field

Untitled3 (many done)

  • Key (p-id) — varchar — Primary key — NOT NULL
  • Key (s-num) — num — Foreign key → Untitled3.Key — NOT NULL
  • Field

Untitled4 (passport)

  • Key — Foreign key → Untitled3.Key — NOT NULL

class (Untitled2)

  • c-id (Key) — varchcar — Primary key — NOT NULL
  • Key (c-id) — int — Foreign key → Untitled3.Key — NOT NULL
  • s-id (student-id) — int — Foreign key → Untitled3.s-id — NOT NULL
  • c-name (class name) — varchar
  • Field — int
  • Field2

student (Untitled)

  • s-id (student-id) — int — Primary key — NOT NULL
  • Field (computer software) — varchar
  • email ([email protected]) — varchar
  • phone (01064681259) — varchar
  • Field2