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