FirstGaon

Tables (9)

Untitled (Student)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (zip) — nvarchar(30)
  • Field (city) — nvarchar(30)
  • Field (do) — nvarchar(30)
  • Field (contact) — char(11)
  • Key (maindepartmentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (boksudepartmentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (labid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (jumin) — char(13)

Untitled (Course)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (grade) — smallint
  • Key (professorid) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Sugang)

  • Key (studentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (courseid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (Year) — date()
  • Field (semester) — smallint
  • Field (GPA) — char(2)
  • Key (lactureprofessorid) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (roomid) — char(8) — Foreign key → Untitled.Key — NOT NULL

Untitled (Professor)

  • Key (id) — nvarchar(30) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (contact) — char(11)
  • Field (zip) — nvarchar(30)
  • Field (city) — nvarchar(30)
  • Field (do) — nvarchar(30)
  • Key (departmentid) — char(8) — Foreign key → Untitled.Key — NOT NULL

Untitled (Department)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (contact) — char(11)
  • Field (zip) — nvarchar(30)
  • Field (city) — nvarchar(30)
  • Field (do) — nvarchar(30)

Untitled (Lab)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (room) — char(5)
  • Key (professorid) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Project)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (_From) — date
  • Field (_to) — date
  • Field (budget) — int

Untitled (ProjectPartition)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Key (studentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (projectid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (professorid) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (LactureRoom)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (room) — char(5)
  • Key (id2) — char(8) — Foreign key → Untitled.Key — NOT NULL