예제4

테이블 (4)

DEPARTMENT (Untitled6)

  • employeeID (Key2) — char(10) — 외래 키 → EMPLOYEE.employeeID — NOT NULL
  • employeeID (Key22) — char(10) — 외래 키 → EMPLOYEE.employeeID — NOT NULL
  • actor (Field) — char(20)
  • director (Field2) — int(20)
  • biography (Field3) — int(20)

EMPLOYEE (Untitled)

  • employeeID (Key2) — char(10) — 기본 키 — NOT NULL
  • employeeID (Key22) — char(10) — 외래 키 → DEPARTMENT.employeeID — NOT NULL
  • projectID (Field) — char(10)
  • Field2

PROJECT (Untitled5)

  • projectID (Key) — int — 기본 키 — NOT NULL
  • name (Field) — char(70)
  • Field2

WORKSON (Untitled4)

  • code (Key3) — int(20) — 외래 키 → PROJECT.projectID — NOT NULL
  • employeeID (Key2) — char(10) — 외래 키 → EMPLOYEE.employeeID — NOT NULL
  • employeeID (Key22) — char(10) — 외래 키 → EMPLOYEE.employeeID — NOT NULL
  • buydate (Field) — int(20)
  • rental (Field2) — int(10)
  • time (Field3) — int(10)
  • code (Key4) — int(20) — 외래 키 → PROJECT.projectID — NOT NULL
  • code (Key32) — int(20) — 외래 키 → WORKSON.code — NOT NULL
  • employeeID (Key23) — char(10) — 외래 키 → WORKSON.employeeID — NOT NULL
  • employeeID (Key222) — char(10) — 외래 키 → WORKSON.employeeID — NOT NULL