madanguniv
Tables (7)
department (Untitled2)
- 학부번호 (dno) — INT — Primary key — NOT NULL
- 학부명 (dname) — VARCHAR(30) — NOT NULL
- 사무실 (office) — VARCHAR(20) — NOT NULL
- 학과장 (ssn) — VARCHAR(30) — Foreign key → professor.id — NOT NULL
graduate (Untitled3)
- id (ssn) — VARCHAR(30) — Primary key — NOT NULL
- 이름 (name) — VARCHAR(30) — NOT NULL
- 나이 (age) — INT — NOT NULL
- 학위과정 (deg_prog) — CHAR(6) — NOT NULL
- 학부번호 (dno) — INT — Foreign key → department.학부번호 — NOT NULL
- 선임대학원생 (ssn2) — VARCHAR(30) — Foreign key → graduate.id — NOT NULL
professor (Untitled)
- id (ssn) — VARCHAR(30) — Primary key — NOT NULL
- 이름 (name) — VARCHAR(30) — NOT NULL
- 나이 (age) — INT — NOT NULL
- 직책 (p_rank) — VARCHAR(30)
- 연구분야 (speciality) — VARCHAR(30)
project (Untitled4)
- id (pid) — VARCHAR(30) — Primary key — NOT NULL
- 스폰서 (sponsor) — VARCHAR(30)
- 시작날짜 (start_date) — DATE — NOT NULL
- 종료날짜 (end_datae) — DATE — NOT NULL
- 예산 (budget) — INT — NOT NULL
- 메니저 (pid2) — VARCHAR(30) — Foreign key → project.id — NOT NULL
workdept (Untitled5)
- id (ssn) — VARCHAR(30) — Foreign key → professor.id — NOT NULL
- 학부번호 (dno) — INT — Foreign key → department.학부번호 — NOT NULL
- 참여\백분율 (pct_time) — DECIMAL(5,2) — NOT NULL
workinproject (Untitled6)
- id (ssn) — VARCHAR(30) — Foreign key → professor.id — NOT NULL
- id (pid) — VARCHAR(30) — Foreign key → project.id — NOT NULL
workprog (Untitled7)
- id (ssn) — VARCHAR(30) — Foreign key → graduate.id — NOT NULL
- id (pid) — VARCHAR(30) — Foreign key → project.id — NOT NULL