2023사서교육원예제
테이블 (5)
DAPARMENT (DEPARTMENT)
- Key (detNo) — int — 기본 키 — NOT NULL
- Field (detName) — char(20)
- Field (depManager) — char(20)
- Field (managerStartDate) — char(20)
Untitled (PROJECT)
- Key (ptojNo) — int — 기본 키 — NOT NULL
- Field (ptjoName) — char(10)
- Field (controllingDepartment) — char(10)
- Field (location)
- Key (detNo) — int — 외래 키 → DAPARMENT.Key — NOT NULL
- Key (ssn) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORKS-ON)
- Key (ssn) — int — 기본 키 — NOT NULL
- Field (projNo) — char(10)
- Field (hours)
- Key (ssn2) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (ptojNo) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOEE)
- Key (ssn) — int — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (gender) — char(30)
- Field (address) — char(30)
- Field (birthDate) — char(30)
- Field (department) — char(30)
- Field (supervise) — char10)
- Field (workson) — char(10)
- Field (projHours)
- Key (detNo) — int — 외래 키 → DAPARMENT.Key — NOT NULL
- Key (dependentName) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (dependentName) — int — 기본 키 — NOT NULL
- Field (gender) — char(30)
- Field (birthDate) — char(30)
- Field (relationship) — char(10)
- Field (parent) — char(10)
- Field (ssn)
- Key (ssn2) — int — 외래 키 → Untitled.Key — NOT NULL