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