ERD

Tables (5)

Untitled (교수)

  • Key (교수아이디) — VARCHAR(50) — Primary key — NOT NULL
  • Field (이름) — VARCHAR(50) — NOT NULL
  • Field (나이) — INTEGER
  • Field (직위) — VARCHAR(50)
  • Field (연구분야) — VARCHAR(50)

Untitled (학과)

  • Key (학과번호) — INTEGER — Primary key — NOT NULL
  • Field (학과이름) — VARCHAR(50) — NOT NULL
  • Field (학과사무실) — VARCHAR(50) — NOT NULL
  • Key (교수아이디) — VARCHAR(50) — Foreign key → Untitled.Key — NOT NULL

Untitled (대학원생)

  • Key (아이디) — VARCHAR(50) — Primary key — NOT NULL
  • Field (이름) — VARCHAR(50) — NOT NULL
  • Field (나이) — INTEGER
  • Field (학위과정) — VARCHAR(50) — NOT NULL
  • Key (학과번호) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (과제)

  • Key (과제번호) — VARCHAR(50) — Primary key — NOT NULL
  • Field (지원기관) — VARCHAR(50)
  • Field (개시일) — DATE
  • Field (종료일) — DATE
  • Field (예산액) — INTEGER

Untitled (근무)

  • Key (참여백분율) — INTEGER — Primary key
  • Key (아이디) — VARCHAR(50) — Foreign key → Untitled.Key — NOT NULL