20241107
Tables (11)
Course
- id — int — Primary key — NOT NULL
- _name — nchar(30)
- credit — int
- dept_id — int — NOT NULL
- prof_id — int — NOT NULL
Department
- id — int — Primary key — NOT NULL
- _name — nchar(30)
- phone — char(14)
- Field — VARCHAR(255)
Lab
- id (Key) — char(30) — Primary key — NOT NULL
- _name — nchar(30)
Professor
- id — int — Primary key — NOT NULL
- _name — nchar(4)
- dept_id — int — NOT NULL
- phone — char(14)
- deptid (id2) — int — Foreign key → Department.id — NOT NULL
- id (Key) — char(30) — Foreign key → Lab.id — NOT NULL
- gcode (Key2) — char(5) — Foreign key → address.gcode — NOT NULL
- 상세주소 (Field) — char(59)
- email (Field2) — char(25)
Student
- id — int — Primary key — NOT NULL
- _name — nchar(30)
- birth — datetime2
- dept_id — int — NOT NULL
- lab_id — int — NOT NULL
- phone — char(14)
- deptid (id2) — int — Foreign key → Department.id — NOT NULL
- id (Key) — char(30) — Foreign key → Lab.id — NOT NULL
- 상세주소 (Field) — char(40)
Sugang
- cid (id) — int — Foreign key → Course.id — NOT NULL
- sid (id2) — int — Foreign key → Student.id — NOT NULL
- pid (id3) — int — Foreign key → Professor.id — NOT NULL
- gpa — char(2)
- open_year — datetime2
- open_semester — tinyint
address (Untitled5)
- gcode (Key) — char(5) — Primary key — NOT NULL
- 광역명 (Field)
- 시 (Field2)
- 구 (Field3)
- 길 (Field7)
- id — int — Foreign key → Student.id — NOT NULL
employer (Untitled4)
- id (Key) — Primary key — NOT NULL
- salary (Field) — int
- _name (Field2) — char(4)
- pid (Key2) — Foreign key → employer.id — NOT NULL
project (Untitled)
- id (Key) — char — Primary key — NOT NULL
- _name (Field) — char(99)
- start (Field2) — datetime2
- end (Field3) — datetime2
- no (Field4) — int
project_processor (Untitled3)
- pid (id) — int — Foreign key → Professor.id — NOT NULL
- prid (Key) — char — Foreign key → project.id — NOT NULL
- from (Field)
- ro (Field2)
- 참여율 (Field3)
project_student (Untitled2)
- id — int — Foreign key → Student.id — NOT NULL
- pid (Key) — char — Foreign key → project.id — NOT NULL
- from (Field)
- to (Field2)
- 참여율 (Field3)