2025_2 예제 3
테이블 (5)
Untitled (CLIENT_SERVICE)
- Key (cliSSN) — 외래 키 → Untitled.Key — NOT NULL
- Key (serCode) — 외래 키 → Untitled.Key — NOT NULL
- Key (proID) — 외래 키 → Untitled.Key — NOT NULL
- Field (date)
Untitled (CLIENT)
- Key (cliSSN) — 기본 키 — NOT NULL
- Field (name)
- Field (address)
- Field (phone)
Untitled (DEPENDENT)
- Key (depSSN) — 기본 키 — NOT NULL
- Field (name)
- Field (age)
- Key (cliSSN) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serCode) — 기본 키 — NOT NULL
- Field (description)
- Key (proID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROVIDER)
- Key (proID) — 기본 키 — NOT NULL
- Field (name)
- Field (address)
- Field (phone)