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