2022_2(NGS)_박현철

테이블 (4)

EMPLOYEE

  • Key (employeeNO) — char(8) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — char(11)
  • Field (departmentID) — char(4)
  • Field (sex) — char(6)
  • Field (socialID) — char(13)
  • Field (birthdate) — char(6)
  • Key (deptID) — char(3) — 외래 키 → department.Key — NOT NULL

Untitled (project)

  • Key (projectID) — char(100) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Key (deptID) — char(3) — 외래 키 → department.Key — NOT NULL

department

  • Key (deptID) — char(3) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (phone) — char(11)
  • Field (location) — char(20)

wokrson (workson)

  • Key (woID) — char(10) — 기본 키 — NOT NULL
  • Key (projectID) — char(100) — 외래 키 → Untitled.Key — NOT NULL
  • Key (employeeNO) — char(8) — 외래 키 → EMPLOYEE.Key — NOT NULL