Sample(2022_2_준사서A반)

테이블 (6)

DEPARTMENT

  • (depID) — char(5) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (mgrSsn) — char(14)
  • key (ssn) — char(14) — 외래 키 → EMPLOYEE.key — NOT NULL

DEPENDANT

  • Key (dependID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field2 (birthDate) — date
  • Field (employeeSsn) — char(14)
  • key (ssn) — char(14) — 외래 키 → EMPLOYEE.key — NOT NULL

EMPLOYEE

  • key (ssn) — char(14) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field2 (address) — char(50)
  • Key2 (phone) — char(11) — NOT NULL
  • Field (depID) — char(3)
  • (depID2) — char(5) — 외래 키 → DEPARTMENT.depID — NOT NULL

PROJECT

  • Key (projectID) — char(10) — 기본 키 — NOT NULL
  • Field (projectName) — char(30)
  • Field (description)
  • Field (duration) — char(30)
  • Field (deIP) — char(5)
  • (depID) — char(5) — 외래 키 → DEPARTMENT.depID — NOT NULL

Untitled

    Untitled5 (WORKSON)

    • Key (woID) — char(20) — 기본 키 — NOT NULL
    • Field (ssn) — char(14)
    • Field2 (projectID) — char(10)
    • Field3 (hours) — float
    • key (ssn2) — char(14) — 외래 키 → EMPLOYEE.key — NOT NULL
    • Key (projectID2) — char(10) — 외래 키 → PROJECT.Key — NOT NULL