2023_사서교육원예제

테이블 (5)

DEPARTMENT

  • Key (departmentID) — int — 기본 키 — NOT NULL
  • Field — char(20)
  • Field2 (depLocation) — char(20)
  • Field2 (manager) — int
  • Field3 (managerStartDate) — date
  • Key (empSSN) — char(14) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Key (projectName) — int(10) — 외래 키 → PROJECT.Key

DEPENDENT (Untitled)

  • Field3 (dependentName) — char(30)
  • Field4 (gender) — int
  • Field (birthDate) — date
  • Field (relationship) — int
  • Key (empSSN) — char(14) — 외래 키 → EMPLOYEE.Key — NOT NULL

EMPLOYEE

  • Key (empSSN) — char(14) — 기본 키 — NOT NULL
  • Field (empName) — char(30)
  • Field (department) — int
  • Key (departmentID) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (superVssn) — char(14) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Key (projectID) — int(10) — 외래 키 → PROJECT.Key
  • Key (projectManager) — int(10) — 외래 키 → PROJECT.Key

PROJECT (Untitled2)

  • Key (projectID) — int(10) — 기본 키
  • (projectName) — int
  • Field3 (projectStartDate) — date
  • Key (empSSN) — char(14) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Field (location) — int
  • Field (endDate) — date
  • Field (description)

WORKSON (Untitled3)

  • Key (empSSN) — char(14) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Key (projectID) — int(10) — 외래 키 → PROJECT.Key
  • Field (hoursPerWeek) — float
  • Key (projectDepartment) — int(20) — 외래 키 → DEPARTMENT.Key — NOT NULL