임원석
테이블 (4)
PERSON (EMPLOYEE)
- emplyeedID (ssn) — char(12) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
- Field (salary) — int(10)
- Field (gender) — char(1)
- Field (birthDate) — date
- Key (deptNO) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (projectNO) — int — 기본 키 — NOT NULL
- Field (name) — char(70)
- Field (location) — char(30)
- Field (controllingDepartment) — char(50)
- Key — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (deptNO) — int — 기본 키 — NOT NULL
- Field (name) — char(50)
- Field (manager) — char(30)
- Field (managerStartDate) — date
- emplyeedID (ssn) — char(12) — 외래 키 → PERSON.emplyeedID — NOT NULL
Untitled (WORKSON)
- Key — 기본 키 — NOT NULL
- Key (projectNO) — int — 외래 키 → Untitled.Key — NOT NULL