예제 3다시
테이블 (6)
Untitled (client)
- Key (ssn) — 기본 키 — NOT NULL
- Field (address)
- Field (name)
- Field (phonenumber)
Untitled (dependent)
- Key (dependent_ssn) — 기본 키 — NOT NULL
- Field (name)
- Field (year)
- Key (ssn) — 외래 키 → Untitled.Key — NOT NULL
Untitled (service)
- Key (identifier) — 기본 키 — NOT NULL
- Field (description)
Untitled (service provider)
- Key (provider_identifier) — 기본 키 — NOT NULL
- Field (name)
- Field (address)
- Field (provider phone number)
Untitled (service record)
- Key (이용기록) — 기본 키 — NOT NULL
- Key (ssn) — 외래 키 → Untitled.Key — NOT NULL
- Field (happendate)
- Key (provider_identifier) — 외래 키 → Untitled.Key — NOT NULL
- Key (identifier2) — 외래 키 → Untitled.Key — NOT NULL
Untitled (제공가능서비스)
- Key (provider_identifier) — 외래 키 → Untitled.Key — NOT NULL
- Key (identifier2) — 외래 키 → Untitled.Key — NOT NULL