FirstGaon

Tables (9)

Untitled (Student)

  • Key (id) — char8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (Contact) — char(5)
  • Field (zip) — char(5)
  • Field (city) — nvarchar(30)
  • Field (Do) — nvarchar(30)
  • Key (sosokdepartmentid) — char8) — Foreign key → Untitled2.Key — NOT NULL
  • Key (labid) — char8) — Foreign key → Untitled2.Key — NOT NULL

Untitled (Course)

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

Untitled (Sugang)

  • Key (studentid) — char8) — 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 (lextureprofid) — char8) — Foreign key → Untitled.Key — NOT NULL
  • Key (roomid) — char8) — Foreign key → Untitled2.Key — NOT NULL

Untitled (Professor)

  • Key (id) — char8) — 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 (department_id) — char8) — Foreign key → Untitled2.Key — NOT NULL

Untitled2 (Department)

  • Key (id) — char8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (Contact) — char(11)
  • Field (zip) — char(5)
  • Field (city) — nvarchar(30)
  • Field (Do) — nvarchar(30)

Untitled2 (Lab)

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

Untitled2 (Project)

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

Untitled2 (ProjParticipation)

  • Key (studentid) — char8) — Foreign key → Untitled.Key — NOT NULL
  • Key (projectid) — char8) — Foreign key → Untitled2.Key — NOT NULL
  • Key (professorid) — char8) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (LectureRoom)

  • Key (id) — char8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Key (departmentid) — char8) — Foreign key → Untitled2.Key — NOT NULL