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