2023사서교육원 과제
테이블 (5)
Untitled (DEPARMENT)
- Key — 기본 키 — NOT NULL
- Field (depNo) — int
- Field (depName)
- Field (depManager)
- Field (depManagerStartDate)
Untitled2 (PROJECT)
- Key — 기본 키 — NOT NULL
- Field (proNo) — int
- Field (proName)
- Field (proLocation)
- Field
- Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
- Key (Key3) — 외래 키 → Untitled5.Key — NOT NULL
Untitled3 (DEFENDENT)
- Key — 기본 키 — NOT NULL
- Field (depName) — int
- Field (depGender)
- Field (depBirthDate)
- Field2 (depParent)
- Field (depSsn)
- Key (Key2) — 외래 키 → Untitled4.Key — NOT NULL
Untitled4 (EMPLOEE)
- Key — 기본 키 — NOT NULL
- Field — int
- Field2 (name)
- Field2 (gender)
- Field2 (address)
- Field2 (salary)
- Field2 (birthDate)
- Field2 (department)
- Field2 (supervisor)
- Field2 (worksOn)
- Field2 (project)
- Field2 (hours)
- Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
Untitled5 (WORKS-ON)
- Key — 기본 키 — NOT NULL
- Field (ssn) — int
- Field (projNo)
- Field (hours)
- Key (Key2) — 외래 키 → Untitled4.Key — NOT NULL