2023사서교육원예제
테이블 (5)
DEPARTMENT
- Key (DeptId) — int — 기본 키 — NOT NULL
- Field (DeptName) — char(30)
- Field2 (DeptLocation) — char(30)
- Field (DeptManagerStartDate) — date
- Key (ManagerEmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL
PROJECT
- Key (ProjNo) — int — 기본 키 — NOT NULL
- Field (ProjName) — char(30)
- Key (ManageDeptId) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (EmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL
Untitled (DEPENDENT)
- Key (DependentSSN) — char(14) — 기본 키 — NOT NULL
- Field (DependentName) — char(30)
- Field2 (DependentGender) — char(30)
- Field3 (DependentBirthDate) — date
- Field4 (DependentRelationship) — char(30)
- Key (EmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL
Untitled (WORKS-ON)
- Key (EmpSSN2) — char(14) — 외래 키 → Untitled2.Key — NOT NULL
- Key (ProjNo2) — int — 외래 키 → PROJECT.Key — NOT NULL
- Field2 (HoursPerWeek) — float
Untitled2 (EMPLOYEE)
- Key (EmpSSN) — char(14) — 기본 키 — NOT NULL
- Field (EmpName) — char(30)
- Field (EmpGender) — char(30)
- Field (EmpAddress) — char(99)
- Field2 (EmpSalary) — int
- Field (EmpBirthDate) — date
- Field (EmpSupervisor) — char(30)
- Field (EmpWorksOn) — char(30)
- Key (WorksForDeptId) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (ProjNo) — int — 외래 키 → PROJECT.Key — NOT NULL
- Key (superVEmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL