d

Tables (4)

curriculum (Untitled2)

  • idCurriculum (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • point (Field2) — int

opensub (Untitled5)

  • idOpensub (Key) — int — Primary key — NOT NULL
  • year (Field) — date
  • session (Field2) — int
  • idStudent (Key2) — int — Foreign key → student.idStudent — NOT NULL
  • idProfessor (Key3) — int — Foreign key → professor.idProfessor — NOT NULL

professor (Untitled4)

  • idProfessor (Key) — int — Primary key — NOT NULL
  • Field — varchar(10)
  • Field2 — varchar(30)

student (Untitled3)

  • idStudent (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • number (Field2) — int