FirstGaon
Tables (9)
Untitled (Student)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field (zip) — nvarchar(30)
- Field (city) — nvarchar(30)
- Field (do) — nvarchar(30)
- Field (contact) — char(11)
- Key (maindepartmentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (boksudepartmentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (labid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Field (jumin) — char(13)
Untitled (Course)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field (grade) — smallint
- Key (professorid) — nvarchar(30) — 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 (lactureprofessorid) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL
- Key (roomid) — char(8) — Foreign key → Untitled.Key — NOT NULL
Untitled (Professor)
- Key (id) — nvarchar(30) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field (contact) — char(11)
- Field (zip) — nvarchar(30)
- 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) — nvarchar(30)
- Field (city) — nvarchar(30)
- Field (do) — nvarchar(30)
Untitled (Lab)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field (room) — char(5)
- Key (professorid) — nvarchar(30) — 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 (ProjectPartition)
- Key (id) — char(8) — Primary key — NOT NULL
- Key (studentid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (projectid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (professorid) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (LactureRoom)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (room) — char(5)
- Key (id2) — char(8) — Foreign key → Untitled.Key — NOT NULL