FirstGaon
Tables (9)
Untitled (Student)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field2 (contact) — char(11)
- Field (zip) — char(5)
- Field (city) — nvarchar(30)
- Field — nvarchar(30)
- Key (departmentid) — 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
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(8)
- Key (lectureprofid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (roomid) — 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 (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 (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
- Field
Untitled (ProjParticipation)
- 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 (department id) — char(8) — Foreign key → Untitled.Key — NOT NULL