FirstGaon

Tables (9)

Untitled (Student)

  • 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 (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 (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
  • Key (RommId) — 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(2)
  • Key (ProfessorId) — 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 (DoN) — 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 (RoomNumber) — 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 (ProjectParticipation)

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