사서교육원 예제

테이블 (6)

LOCATION (Untitled2)

  • Field (locationID) — int
  • Field (locationName) — char(30)
  • Field (locationAddress) — char(100)
  • Key (depID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (depID) — int — 기본 키 — NOT NULL
  • Field (depName) — char(30)
  • Field (magerStartDate) — date
  • Key (empSSN) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (proID) — int — 기본 키 — NOT NULL
  • Field (proName) — char(30)
  • Key (manageDepID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (EMPLOYEE)

  • Key (empSSN) — char(14) — 기본 키 — NOT NULL
  • Field (empName) — char(30)
  • Field2 (empGender) — char(10)
  • Field (address) — char(100)
  • Field (salary) — int
  • Field (empBirthDate) — date
  • Key (depID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (superVssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (denpentSSN) — char(14) — 기본 키 — NOT NULL
  • Field (dependentName) — char(30)
  • Field (denpentGender) — char(10)
  • Field (denpentBirthDate) — date
  • Field (relationship) — char(20)
  • Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL

WORKON (Untitled)

  • Key (proID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (hourPerWeek) — float
  • Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL