2023 데이터베이스론
테이블 (5)
DEPARTMENT
- Key (deptNo) — int — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field (depManger) — char(30)
- Field (mangerStartDate) — date
- Field (depLocations) — char(20)
- Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJET)
- Key (proNo) — int — 기본 키 — NOT NULL
- Field (proName) — char(30)
- Field (controllingDepartment) — char(20)
- Field (condepLocation) — char(20)
- Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
- Key (ManagerdepID) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (empSSN) — char(14) — 기본 키 — NOT NULL
- Field (empName) — char(20)
- Field (empgender) — char(20)
- Field (empAddress) — char(30)
- Field (empSalary) — char(20)
- Field (empBirthDate) — date
- Field (empDepartment) — char(20)
- Field (empSupervisor) — char(20)
- Field (worksOn) — int
- Field (project) — char(30)
- Field (hours) — int
- Key (deptNo) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (supervisesSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (dependentNo) — int — 기본 키 — NOT NULL
- Field (dependentName) — char(30)
- Field (dependentGender) — char(10)
- Field (dependentDirthDate) — date
- Field (dependentRelationship) — char(20)
- Field (Parent) — char(20)
- Field (employeessn) — int
- Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORKSON)
- Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
- Key (proNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (hoursperWeek) — float