3week_sjh
Tables (7)
Untitled (DEPARTMENT)
- Key (부서번호) — Char — Primary key — NOT NULL
- Field (부서명) — Char
- Field (관리시작날짜) — Char
- Key (사번(관리자)) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (Project)
- Key (프로젝트번호) — Char — Primary key — NOT NULL
- Field (프로젝트명) — Char
- Field (담당부서) — Char
- Field (기간) — Char
- Field (금액) — Char
- Key (부서번호(관리부서)) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (PERSON)
- Key (사번) — Char — Primary key — NOT NULL
- Field (이름) — Char
- Field (주소) — Char
- Field (급여) — Char
- Field (성별) — integer(1)
- Field (생년월일) — Char
- Field (주민번호) — Char
- Key (부서번호(소속부서)) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (dependents)
- Key (부양가족번호) — Char — Primary key — NOT NULL
- Field (이름) — Char
- Field (성별) — Char
- Field (생년월일) — Char
- Field (사원과 관계) — Char
- Key (사번(관계된 사원)) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (Project_Person)
- Key (사번) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (프로젝트번호) — Char — Foreign key → Untitled.Key — NOT NULL
- Field (직책) — Char
- Field (참여율) — Char
- Field (급여) — Char
Untitled (Department_Place)
- Key (부서번호) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (장소번호) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (Place)
- Key (장소번호) — Char — Primary key — NOT NULL
- Field (장소명) — Char
- Field (주소) — Char