madang2
Tables (7)
Dept (학과)
- dno (학과번호) — Primary key — NOT NULL
- dname (학과이름)
- office (Field)
- ssn (아이디) — varchar(40) — Foreign key → professor.ssn — NOT NULL
Graduate (대학원생)
- ssn (아이디) — Primary key — NOT NULL
- age (나이)
- deg_prog (학위과정)
- name (이름)
- dno (학과번호) — Foreign key → Dept.dno — NOT NULL
professor (교수)
- ssn (아이디) — varchar(40) — Primary key — NOT NULL
- name (이름) — varchar(40)
- age (Field)
- rank (직위)
- speciality (연구 분야)
project (Untitled2)
- pid (과제번호) — Primary key — NOT NULL
- sponsor (지원기관)
- start_date (개시일)
- end_date (종료일)
- budget (예산액)
- ssn (아이디) — varchar(40) — Foreign key → professor.ssn — NOT NULL
work dept (Untitled3)
- dno (학과번호) — Foreign key → Dept.dno — NOT NULL
- ssn (아이디) — varchar(40) — Foreign key → professor.ssn — NOT NULL
- pct time (Field)
work in (Untitled)
- ssn (아이디) — varchar(40) — Foreign key → professor.ssn — NOT NULL
- pid (과제번호) — Foreign key → project.pid — NOT NULL
work prog (Untitled4)
- ssn (아이디) — Foreign key → Graduate.ssn — NOT NULL
- pid (과제번호) — Foreign key → project.pid — NOT NULL