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