드로잉1.1

테이블 (7)

DEPARTMENT

  • Key (depID) — 기본 키 — NOT NULL
  • Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (email)

DEPENDANT

  • Key (dependantID) — 기본 키 — NOT NULL
  • Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Field (name)
  • Field (birthDate)
  • Field (degree)

EMPLOYEE

  • Key (ssn) — 기본 키 — NOT NULL
  • Key (depID) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Field (name)
  • Field (adress)
  • Field (birthDate)
  • Field (salary)
  • Field (gender)
  • Field (email)
  • Field (phone)

LOCATION

  • Key (locationID) — 기본 키 — NOT NULL
  • Field (name)
  • Field (adress)
  • Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL

PROJECT

  • Key (projectID) — 기본 키 — NOT NULL
  • Key (depID) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Field (name)
  • Field (date)
  • Field (outline)

departmentLocation

  • Key (depID) — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (locationID) — 외래 키 → LOCATION.Key — NOT NULL

projectEmployee

  • Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Key (projectID) — 외래 키 → PROJECT.Key — NOT NULL
  • Field (workingHour)