연습문제3
테이블 (6)
Untitled (DEPENDENT)
- Key (dependents ssn) — char(30) — 기본 키 — NOT NULL
- Key (social security number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(30)
- Field (age) — int
- Field (client ssn) — char(30)
Untitled (SERVICE)
- Key (service ID) — char(30) — 기본 키 — NOT NULL
- Field (description) — char(255)
Untitled (CLIENT)
- Key (social security number) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(40)
- Field (phone number) — char(11)
Untitled (HELP)
- Key (help ID) — char(30) — 기본 키 — NOT NULL
- Key (social security number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (provided ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROVIDED SERVICE)
- Key (provided ID) — char(30) — 기본 키 — NOT NULL
- Key (service ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (proviser ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE PROVIDER)
- Key (proviser ID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone number) — char(11)