1
Tables (12)
Course
- id — int — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- _name — nchar(30)
- credit — int
- dept_id — int — NOT NULL
- prof_id — int — NOT NULL
- Field
Department
- id — int — Primary key — NOT NULL
- _name — nchar(30)
- phone — char(14)
- Field — VARCHAR(255)
- id (id2) — int — Foreign key → Department.id — NOT NULL
Lab
- id — int — Foreign key → Professor.id — NOT NULL
- _name — nchar(30)
Professor
- id — int — Primary key — NOT NULL
- _name — nchar(4)
- dept_id — int — NOT NULL
- phone — char(14)
- id (id2) — int — Foreign key → Professor.id — NOT NULL
- zipcode (Field) — char(5)
- 우편번호 (Field3)
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)
- id (id2) — int — Foreign key → Department.id — NOT NULL
Sugang
- cid — int — Foreign key → Course.id — NOT NULL
- sid — int — Foreign key → Student.id — NOT NULL
- Key — Foreign key → Course.Key — NOT NULL
- id (id2) — int — Foreign key → Professor.id — NOT NULL
- gpa — char(2)
- open_year — datetime2
- open_semester — tinyint
address (Untitled5)
- zipcode (Key) — Primary key — NOT NULL
- 광역시 (Field)
- 시명 (Field2)
- 구명 (Field3)
- 길 (Field4)
- id — int — Foreign key → Professor.id — NOT NULL
emp (Untitled4)
- id (Field)
- name (Field2)
- Field3
p (proj. work)
- p.id (Key) — Primary key — NOT NULL
- sid (Field)
- pid (Field2)
- 학생참여율 (Field3)
- 교수참여율 (Field4)
- Field5
- Field6
p.s (Untitled2)
- sid (Field)
- projid (Field2)
- from (Field3)
- to (Field4)
- 참여율 (Field5)
pp (Untitled3)
- pid (Field)
- pro.id2 (Field2)
- form (Field3)
- to (Field4)
- 참여율 (Field5)
project (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field)
- Field2
- from (Field3)
- to (Field4)
- 참여율 (Field5)