FirstGaon

Tables (9)

Student

  • 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 (sosokdepartmentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (boksuid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (labid) — char(8) — Foreign key → Untitled.Key — NOT NULL

Untitled (Sugang)

  • id (studentid) — char(8) — Foreign key → Student.id — NOT NULL
  • Key (courseid) — char(8) — Foreign key → Untitled2.Key — NOT NULL
  • Field (year) — date
  • Field (semmester) — smallint
  • Field (GPA) — char(2)
  • Key (lectuereprofid) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — 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 (department_id) — 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

Untitled (ProParticipation)

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

Untitled (LectureRoom)

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

Untitled2 (Course)

  • Key (id) — char(8) — Primary key — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (grade) — smallint