2023_데이터베이스 수업
테이블 (7)
ISAT (Untitled2)
- DEPARTMENT (departmentID2) — char(5) — 외래 키 → QDEPARTMENT.DEPARTMENT — NOT NULL
- Field (departmentID) — char(5)
- Field (location) — int
QDEPARTMENT (DEPARTMENT)
- DEPARTMENT (departmentID) — char(5) — 기본 키 — NOT NULL
- name — char(30)
- manger (location) — char(30)
- Field (managerSSN) — char(10)
- Field (manageStartDate) — date
- Key (managerEm) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key — 기본 키 — NOT NULL
- Field (employeeID) — char(10)
- Field (ssn) — char(12)
- Field2 (name) — char(30)
- Field3 (gender) — char(1)
- Field (address) — char(50)
- Field (department) — char(50)
- Field2 (degree) — char(50)
- Field (salary) — int(10)
- Field3 (birthdate) — date
- DEPARTMENT (worksForDepartmentID) — char(5) — 외래 키 → QDEPARTMENT.DEPARTMENT — NOT NULL
- Key (supercisorEmpID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
- Field (projectID) — int
- Field (name) — char(70)
- Field (description) — text
Untitled (WORKSON)
- Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
- Field (worksonID) — int
- Field (employeeID) — char(10)
- Field (projectID) — int
- Field (hours) — float
- Key — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Field (ssn) — char(12)
- Field (name) — char(30)
- Field (gender) — char(1)
- Field (birsthdate) — date
- Field (relationship) — char(20)
- Field (employeeID) — char(10)
- Key — 외래 키 → Untitled.Key — NOT NULL
Untitled (LOCATION)
- Field (locationID) — int
- Field