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