드로잉1.1
테이블 (7)
DEPARTMENT
- Key (depID) — 기본 키 — NOT NULL
- Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Field (name)
- Field (phone)
- Field (email)
DEPENDANT
- Key (dependantID) — 기본 키 — NOT NULL
- Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Field (name)
- Field (birthDate)
- Field (degree)
EMPLOYEE
- Key (ssn) — 기본 키 — NOT NULL
- Key (depID) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Field (name)
- Field (adress)
- Field (birthDate)
- Field (salary)
- Field (gender)
- Field (email)
- Field (phone)
LOCATION
- Key (locationID) — 기본 키 — NOT NULL
- Field (name)
- Field (adress)
- Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL
PROJECT
- Key (projectID) — 기본 키 — NOT NULL
- Key (depID) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Field (name)
- Field (date)
- Field (outline)
departmentLocation
- Key (depID) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (locationID) — 외래 키 → LOCATION.Key — NOT NULL
projectEmployee
- Key (ssn) — 외래 키 → EMPLOYEE.Key — NOT NULL
- Key (projectID) — 외래 키 → PROJECT.Key — NOT NULL
- Field (workingHour)