2023 사서교육원 예제
테이블 (6)
Untitled (부양가족)
- Key (부양가족번호) — int — 기본 키 — NOT NULL
- Field (empsSSN) — char(14)
- Field (사원과 관계) — int
- Field (depName) — char(20)
- Field (생년월일) — int
- Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL
Untitled (LOCATION)
- Key (depLocation) — char(20) — 기본 키 — NOT NULL
- Field (도시명) — int
- Field (주소) — int
- Field (행정관할구역) — int
- Key (depID) — int — 외래 키 → department.Key — NOT NULL
- Key (projectID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (project)
- Key (projectID) — int(10) — 기본 키 — NOT NULL
- Field (projectName) — chr(30)
- Field (startDate) — date
- Field (endDate) — date
- Field (descriptiom) — text
- Key (manageID) — int — 외래 키 → department.Key — NOT NULL
- Field (projectNumber) — int(10)
- Field (projectLocation) — int
- Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL
Untitled (WORKSON)
- Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL
- Field (projectID) — int
- Field (hoursperweek) — float
department (DEPERTMENT)
- Key (depID) — int — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field2 (depLocation) — char(20)
- Field (Manager) — int
- Field (managerStartDate) — date
- Key (empSSN) — char(14) — 외래 키 → employee.Key — NOT NULL
employee (EMPLOYEE)
- Key (empSSN) — char(14) — 기본 키 — NOT NULL
- Field (empName) — char(30)
- Field (department) — int
- Key (depID) — int — 외래 키 → department.Key — NOT NULL
- Key (superVssn) — char(14) — 외래 키 → employee.Key — NOT NULL