진남
테이블 (7)
Dept (Untitled2)
- dno — int(11) — 기본 키 — NOT NULL
- ssn(FK) — VARCHAR(255)
- dname — VARCHAR(255)
- office — VARCHAR(255)
- ssn (ssn2) — VARCHAR(255) — 외래 키 → professor.ssn — NOT NULL
Graduate (Untitled3)
- ssn — VARCHAR(255) — 기본 키 — NOT NULL
- dno(FK) — VARCHAR(255)
- name — VARCHAR(255)
- age — CHAR(255)
- deg_prog — VARCHAR(255)
- graduate(FK) — VARCHAR(255)
- dno (dno2) — int(11) — 외래 키 → Dept.dno — NOT NULL
- ssn (ssn2) — VARCHAR(255) — 외래 키 → Graduate.ssn — NOT NULL
professor
- ssn — VARCHAR(255) — 기본 키 — NOT NULL
- name — VARCHAR(255)
- age — CHAR(255)
- rank — VARCHAR(255)
- specially — VARCHAR(255)
project (Untitled)
- pid — VARCHAR(255) — 기본 키 — NOT NULL
- ssn(FN) — VARCHAR(255)
- sponsor — VARCHAR(255)
- start_date — VARCHAR(255)
- end_date — VARCHAR(255)
- budget — VARCHAR(255)
- ssn (ssn3) — VARCHAR(255) — 외래 키 → professor.ssn — NOT NULL
work dept (Untitled4)
- ssn(FK) — VARCHAR(255) — 기본 키 — NOT NULL
- ssn (ssn2) — VARCHAR(255) — 외래 키 → professor.ssn — NOT NULL
- dno (dno2) — int(11) — 외래 키 → Dept.dno — NOT NULL
- dno(FK) — VARCHAR(255)
work in (Untitled5)
- ssn(FK) — VARCHAR(255) — 기본 키 — NOT NULL
- ssn (ssn2) — VARCHAR(255) — 외래 키 → professor.ssn — NOT NULL
- pid (pid2) — VARCHAR(255) — 외래 키 → project.pid — NOT NULL
- pid(FK) — VARCHAR(255)
work prog (Untitled6)
- pid(FK) — VARCHAR(255) — 기본 키 — NOT NULL
- pid (pid2) — VARCHAR(255) — 외래 키 → project.pid — NOT NULL
- ssn (ssn2) — VARCHAR(255) — 외래 키 → Graduate.ssn — NOT NULL
- ssn(FK) — VARCHAR(255)
- Field