2023사서교육원예제

테이블 (5)

Untitled (DEPARTMENT)

  • Key — int — 기본 키 — NOT NULL
  • Field (depName) — char(20)
  • Field (depManager) — char(30)
  • Field (managerStartDate) — data
  • Field (location)

Untitled (WORKS-ON)

  • Key — int — 기본 키 — NOT NULL
  • Key (Key3) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (Key22) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (ssn)
  • Field (projNo)
  • Field (hours)
  • Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (EMPLOEE)

  • Key — int — 기본 키 — NOT NULL
  • Field (ssn)
  • Field (name)
  • Field (gender)
  • Field (address)
  • Field (salary)
  • Field (birthDate)
  • Field (department)
  • Field (supervisor)
  • Field (worksOn)
  • Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key — int — 기본 키 — NOT NULL
  • Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (dependmentName)
  • Field (gender)
  • Field (birthDate)
  • Field (relationship)
  • Field (parent)
  • Field (ssn)

Untitled (PROJECT)

  • Key — int — 기본 키 — NOT NULL
  • Key (Key3) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (Key22) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (Name)
  • Field (Location)
  • Field (cotrollingDpartment)
  • Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL