2023사서교육원
테이블 (8)
Untitled (PROJECT)
- Key (projectID) — char(20) — 기본 키 — NOT NULL
- Field (proName) — char(20)
- Field (proLocation) — char(20)
- Field (controllingDep) — char(20)
- Field (duration) — char(30)
- Key (depID) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (depID) — char(14) — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field (depLacation) — char(20)
- Field (managerStart Date) — date
- Key (managerSsn) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (empssn) — char(14) — 기본 키 — NOT NULL
- Field (empName) — char(20
- Field (address) — text
- Key (supervisorID) — char(14) — 외래 키 → Untitled.Key — NOT NULL
- Key (depID) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE FAMILY)
- Key (family ID) — int — 기본 키 — NOT NULL
- Field (familyName) — char(20)
- Field (Manager)
Untitled (DEPENDANT)
- Key (depenID) — char(14) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (birthdate) — date
- Key (empssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORKON)
- Key (workonID) — char(20) — 기본 키 — NOT NULL
- Field (hour) — float
- Field (duration) — char(30)
- Key (projectID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (empssn) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPART_LOC)
- Key (deplocID) — char(20) — 기본 키 — NOT NULL
- Field
- Key (locID2) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (depNo) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (LOCATION)
- Key (locID) — int — 기본 키 — NOT NULL
- Field (locName) — char(20)
- Field (loc_phone) — char(10)
- Field