2024_1_과제황석산
테이블 (7)
DEPARTMENT
- departmentID (deptNo) — char(20) — 기본 키 — NOT NULL
- Field (deptName) — char(10)
- Field (managerID) — char(20)
- Field (managerStartDate) — date
- Key (projNo) — char(4) — 외래 키 → Untitled.Key — NOT NULL
- Key (locID) — char(4) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (projNo) — char(4) — 기본 키 — NOT NULL
- Field (poojName) — char(10)
- Field (controllinDeparment) — char(10)
- departmentID (deptNo) — char(20) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
- Key (projNo2) — char(4) — 외래 키 → Untitled.Key — NOT NULL
Untitled (LOCATION)
- Key (locID) — char(4) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Key (locID2) — char(4) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEP_LOC)
- Key (locID) — char(4) — 기본 키 — NOT NULL
- Field (depNo) — char(20)
- Key (projNo) — char(4) — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (employeeNo) — char(10) — 기본 키 — NOT NULL
- Key (familyNO) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (employName) — char(10)
- Field (employeeBirth) — date
- Field (employAdrres) — char(30)
- departmentID (deptNo) — char(20) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
Untitled (EMP_FAMILY)
- Key (familyNO) — char(10) — 기본 키 — NOT NULL
- Field (familyName) — char(10)
- Field (familySex) — char(3)
- Field (familyBirth) — date
Untitled (PROJECT_EMP)
- Key (employeeNo) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (familyNO) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (projNo) — char(4) — 외래 키 → Untitled.Key — NOT NULL