2025_2_database(식별)
테이블 (7)
DEPARTMENT
- deptNO — char(5) — 기본 키 — NOT NULL
- name — char(20)
- Field (description) — text
- Field (managerStartDate) — date
- empID — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL
- projNO — char(10) — 외래 키 → PROJECT.projNO — NOT NULL
DEPARTMENTLOCATION (DEPARTMENTLOCATIONS)
- deptNO — char(5) — 외래 키 → DEPARTMENT.deptNO — NOT NULL
- locationNO — char(3) — 외래 키 → LOCATION.locationNO — NOT NULL
DEPENDENT
- depdID — char(10) — 기본 키 — NOT NULL
- gender — char(10)
- birthDate — date
- relationship — char(10)
- name — char(10)
- parent — char(5)
- empID — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL
EMPLOYEE
- empNO — char(10) — 기본 키 — NOT NULL
- name — char(30)
- phone — char(11)
- birthDate — date
- Field (department) — char(10)
- gender — char(10)
- address — char(35)
- salary — char(10)
- deptNO — char(5) — 외래 키 → DEPARTMENT.deptNO — NOT NULL
- empNO (supEmpNO) — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL
LOCATION
- locationNO — char(3) — 기본 키 — NOT NULL
- name — char(10)
- address — char(35)
- Field (phone) — char(11)
- empNO (managerempNO) — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL
PROJECT
- projNO — int10) — 기본 키 — NOT NULL
- name — char(15)
- location — char(20)
- controllingDepartment — char(20)
- deptNO — char(5) — 외래 키 → DEPARTMENT.deptNO — NOT NULL
WORKSON
- empNO — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL
- projNO — int(10) — 외래 키 → PROJECT.projNO — NOT NULL
- hoursPerWeek (hour) — float