사서교육원 예제
테이블 (6)
LOCATION (Untitled2)
- Field (locationID) — int
- Field (locationName) — char(30)
- Field (locationAddress) — char(100)
- Key (depID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (depID) — int — 기본 키 — NOT NULL
- Field (depName) — char(30)
- Field (magerStartDate) — date
- Key (empSSN) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (proID) — int — 기본 키 — NOT NULL
- Field (proName) — char(30)
- Key (manageDepID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (empSSN) — char(14) — 기본 키 — NOT NULL
- Field (empName) — char(30)
- Field2 (empGender) — char(10)
- Field (address) — char(100)
- Field (salary) — int
- Field (empBirthDate) — date
- Key (depID) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (superVssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (denpentSSN) — char(14) — 기본 키 — NOT NULL
- Field (dependentName) — char(30)
- Field (denpentGender) — char(10)
- Field (denpentBirthDate) — date
- Field (relationship) — char(20)
- Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
WORKON (Untitled)
- Key (proID) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (hourPerWeek) — float
- Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL