진남

테이블 (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