erd최
테이블 (11)
ClassRoom
- id — char(8) — NOT NULL
- name — nvarchar(30)
Course
- id — char(8) — NOT NULL
- name — nvarchar(30)
Department
- id — char(8) — NOT NULL
- Name — nvarchar(30)
- phone — char(11)
- zip — char(5)
- City — nvarchar(10)
- bunzi — nvarchar(10)
Lab
- id — char(8) — NOT NULL
- name — nvarchar(30)
- profid — char(8) — NOT NULL
Paper
- id — char(8) — NOT NULL
- title — nvarchar(50)
- date — datetime2
Paper_Participate
- paperid — char(8) — NOT NULL
- profid — char(8) — NOT NULL
- studentid — char(8) — NOT NULL
Professor
- id — char(8) — NOT NULL
- name — nvarchar(30)
- phone — char(11)
- deptid — char(8) — NOT NULL
- zip — char(5)
- City — nvarchar(10)
- Bunzi — nvarchar(10)
Project
- id — char(8) — NOT NULL
- name — nvarchar(30)
- start — datetime2
- end — datetime2
- agency — nvarchar(50)
Project_Participate
- profid — char(8) — NOT NULL
- projed — char(8) — NOT NULL
- studentid — char(8) — NOT NULL
Student
- id — char(8) — NOT NULL
- name — nvarchar(30)
- phone — char(11)
- deptid — char(8) — NOT NULL
- jidoprof — char(8) — NOT NULL
- labid — char(8) — NOT NULL
- zip — char(5)
- City — nvarchar(10)
- Bunzi — nvarchar(10)
Sugang
- studentid — char(8) — NOT NULL
- courseid — char(8) — NOT NULL
- grade — char(2)
- year — datetime2
- roomid — char(8) — NOT NULL
- porfid — char(8) — NOT NULL