리포트1
테이블 (4)
DEPARTMENT1 (DEPARTMENT)
- depenID (depenNo) — integer — 기본 키 — NOT NULL
- name — char(20)
- birthDate (btrthDate) — date
- ssn — char(10)
- ssn (mgrssn) — 외래 키 → EMPLOEE.ssn — NOT NULL
DEPENDENT
- depenName — char(20) — 기본 키 — NOT NULL
- gender — char(10)
- birthDate — date
- relationship — char(10)
- parent — char(10)
- ssn — char(10)
EMPLOEE (EMPLOYEE)
- ssn (employeeNo) — 기본 키 — NOT NULL
- name — char(20)
- address — char(50)
- phone — char(11)
- department — char(2)
- Field (email) — char(10)
- Field (ssn) — char(10)
- Field (salary) — char(14)
- depenID (depenNo) — integer — 외래 키 → DEPARTMENT1.depenID — NOT NULL
PROJECT
- projNO — char(20) — 기본 키 — NOT NULL
- name — char(20)
- location — char(20)
- controlingDep (controllingDep) — char(2)