2023사서교육원예제
테이블 (5)
Untitled (DEPARTMENT)
- Key — int — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field (depManager) — char(30)
- Field (managerStartDate) — data
- Field (location)
Untitled (WORKS-ON)
- Key — int — 기본 키 — NOT NULL
- Key (Key3) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (Key22) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (ssn)
- Field (projNo)
- Field (hours)
- Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOEE)
- Key — int — 기본 키 — NOT NULL
- Field (ssn)
- Field (name)
- Field (gender)
- Field (address)
- Field (salary)
- Field (birthDate)
- Field (department)
- Field (supervisor)
- Field (worksOn)
- Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key — int — 기본 키 — NOT NULL
- Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (dependmentName)
- Field (gender)
- Field (birthDate)
- Field (relationship)
- Field (parent)
- Field (ssn)
Untitled (PROJECT)
- Key — int — 기본 키 — NOT NULL
- Key (Key3) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (Key22) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (Name)
- Field (Location)
- Field (cotrollingDpartment)
- Key (Key2) — int — 외래 키 → Untitled.Key — NOT NULL