haksadb
Tables (12)
Department
- id — char(8) — Primary key — NOT NULL
- name — nvarchar(30)
- phone — char(11)
- Field (Bunzi) — nvarchar(10)
- Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL
Student
- id — char(8) — Primary key — NOT NULL
- name — nvarchar(30)
- phone — char(11)
- depid — char(8) — Foreign key → Department.id — NOT NULL
- Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (Lapid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Field (Bunzi) — nvarchar(10)
- Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Field (juminnum) — char(13)
Untitled (Professor)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field (phone) — char(11)
- id (depid) — char(8) — Foreign key → Department.id — NOT NULL
- Field (Bunzi) — nvarchar(10)
- Key (zip) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (Paper)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (tite) — nvarchar(50)
- Field (date) — datetime2
Untitled (Paper_participate)
- Key (id) — char(8) — Primary key — NOT NULL
- Key (paperid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- id (studentid) — char(8) — Foreign key → Student.id — NOT NULL
Untitled (Lap)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL
Untitled (Project)
- Key (id) — char(8) — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field (start) — datetime2
- Field (end) — datetime2
- Field (agency) — nvarchar(50)
Untitled (Project_participate)
- Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (projectid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- id (studentid) — char(8) — Foreign key → Student.id — NOT NULL
Untitled (adress)
- Key (zip) — char(5) — Primary key — NOT NULL
- Field (city) — nvarchar(30)
- Field (Do) — nvarchar(30)
course (Course)
- id — char(8) — Primary key — NOT NULL
- name — nvarchar(30)
room (ClassRoom)
- id — char(8) — Primary key — NOT NULL
- name — nvarchar(30)
sugang (Sugang)
- studentid — char(8) — Foreign key → Student.id — NOT NULL
- id (courseid) — char(8) — Foreign key → course.id — NOT NULL
- grade — char(2)
- year — datetime2
- roomid — char(8) — Foreign key → room.id — NOT NULL
- Key (proid) — char(8) — Foreign key → Untitled.Key — NOT NULL