2023 사서교육원 예제

테이블 (6)

Untitled (부양가족)

  • Key (부양가족번호) — int — 기본 키 — NOT NULL
  • Field (empsSSN) — char(14)
  • Field (사원과 관계) — int
  • Field (depName) — char(20)
  • Field (생년월일) — int
  • Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL

Untitled (LOCATION)

  • Key (depLocation) — char(20) — 기본 키 — NOT NULL
  • Field (도시명) — int
  • Field (주소) — int
  • Field (행정관할구역) — int
  • Key (depID) — int — 외래 키 → department.Key — NOT NULL
  • Key (projectID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (project)

  • Key (projectID) — int(10) — 기본 키 — NOT NULL
  • Field (projectName) — chr(30)
  • Field (startDate) — date
  • Field (endDate) — date
  • Field (descriptiom) — text
  • Key (manageID) — int — 외래 키 → department.Key — NOT NULL
  • Field (projectNumber) — int(10)
  • Field (projectLocation) — int
  • Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL

Untitled (WORKSON)

  • Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL
  • Field (projectID) — int
  • Field (hoursperweek) — float

department (DEPERTMENT)

  • Key (depID) — int — 기본 키 — NOT NULL
  • Field (depName) — char(20)
  • Field2 (depLocation) — char(20)
  • Field (Manager) — int
  • Field (managerStartDate) — date
  • Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL

employee (EMPLOYEE)

  • Key (empSSN) — char(14) — 기본 키 — NOT NULL
  • Field (empName) — char(30)
  • Field (department) — int
  • Key (depID) — int — 외래 키 → department.Key — NOT NULL
  • Key (superVssn) — char(14) — 외래 키 → employee.Key — NOT NULL