FirstGaon

Tables (9)

Untitled (Student)

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

Untitled (Course)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (grade) — smallint
  • Key (professorid) — char(8) — 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(8)
  • Key (lectureprofid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (roomid) — char(8) — Foreign key → Untitled.Key — NOT NULL

Untitled (Professor)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (contact) — char(11)
  • Field (zip) — char(5)
  • 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) — char(5)
  • Field (city) — nvarchar(30)
  • Field (Do) — nvarchar(30)

Untitled (Lab)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (roomno) — char(5)
  • Key (professorid) — char(8) — 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
  • Field

Untitled (ProjParticipation)

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

Untitled (LectureRoom)

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