2023사서교육원예제

테이블 (5)

DAPARMENT (DEPARTMENT)

  • Key (detNo) — int — 기본 키 — NOT NULL
  • Field (detName) — char(20)
  • Field (depManager) — char(20)
  • Field (managerStartDate) — char(20)

Untitled (PROJECT)

  • Key (ptojNo) — int — 기본 키 — NOT NULL
  • Field (ptjoName) — char(10)
  • Field (controllingDepartment) — char(10)
  • Field (location)
  • Key (detNo) — int — 외래 키 → DAPARMENT.Key — NOT NULL
  • Key (ssn) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORKS-ON)

  • Key (ssn) — int — 기본 키 — NOT NULL
  • Field (projNo) — char(10)
  • Field (hours)
  • Key (ssn2) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (ptojNo) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (EMPLOEE)

  • Key (ssn) — int — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (gender) — char(30)
  • Field (address) — char(30)
  • Field (birthDate) — char(30)
  • Field (department) — char(30)
  • Field (supervise) — char10)
  • Field (workson) — char(10)
  • Field (projHours)
  • Key (detNo) — int — 외래 키 → DAPARMENT.Key — NOT NULL
  • Key (dependentName) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (dependentName) — int — 기본 키 — NOT NULL
  • Field (gender) — char(30)
  • Field (birthDate) — char(30)
  • Field (relationship) — char(10)
  • Field (parent) — char(10)
  • Field (ssn)
  • Key (ssn2) — int — 외래 키 → Untitled.Key — NOT NULL