예제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