EX0
테이블 (7)
DEPARTMENT (Untitled)
- departmentNo (Key) — char(4) — 기본 키 — NOT NULL
- departmentName (Field) — char(20)
- departmentManager (Field2) — char(30)
- departmentmanageStartDate (Field3) — date
- employeeId (Key2) — char(13) — 외래 키 → EMPLOYEE.employeeId — NOT NULL
DEPARTMENT_LOCATION (Untitled5)
- departmentNo (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentNo — NOT NULL
- locationNo (Field2) — char(4)
- locationName (Field) — char(10)
- locationNo (Key) — char(4) — 외래 키 → LOCATION.locationNo — NOT NULL
EMPLOYEE (Untitled2)
- employeeId (Key) — char(13) — 기본 키 — NOT NULL
- employeeName (Field) — char(30)
- employeeBirthdate (Field2) — date
- employeeAdress (Field3) — char(100)
- employeeSalary (Field4) — char(10)
- employeeGender (Field5) — char(6)
- dapartmentId (Field6) — char(4)
- departmentNo (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentNo — NOT NULL
LOCATION (Untitled6)
- locationNo (Key) — char(4) — 기본 키 — NOT NULL
- locationName (Field) — char(10)
- adress (Field2) — char(100)
PROJECT (Untitled3)
- projectNo (Key) — char(4) — 기본 키 — NOT NULL
- projectName (Field) — char(30)
- projectLocation (Field2) — char(4)
- departmentNo (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentNo — NOT NULL
works-on (Untitled7)
- worksonId (Key) — char(4) — 기본 키 — NOT NULL
- float (Field2) — char(5)
- employeeId (Key2) — char(13) — 외래 키 → EMPLOYEE.employeeId — NOT NULL
- projectNo (Key3) — char(4) — 외래 키 → PROJECT.projectNo — NOT NULL
부양가족 (Untitled4)
- 부양가족주민번호 (Key) — char(12) — 기본 키 — NOT NULL
- 부양가족이름 (Field) — char(20)
- 부양가족성별 (Field2) — char(6)
- 부양가족생년월일 (Field3) — date
- 사원과의관계 (Field4) — char(20)
- employeeId (Key2) — char(13) — 외래 키 → EMPLOYEE.employeeId — NOT NULL