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