연습문제 3
테이블 (5)
Untitled (organization)
- Key (clientNum) — char(20) — 기본 키 — NOT NULL
- Key (serCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(30)
- Field (addree) — char(50)
- Field (phone) — char(20)
Untitled (service)
- Key (serCode) — char(20) — 기본 키 — NOT NULL
- Field (description) — char(100)
- Field (supID) — char(10)
Untitled (family)
- Field (name) — char(30)
- Field (age) — integer
- Field (familyNum) — char(30)
- Key (serCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (client)
- Key (clientNum) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (education) — integer — 외래 키 → Untitled.Key — NOT NULL
- Key (serCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (service provider)
- Key (education) — integer — 기본 키 — NOT NULL
- Field (number) — char(30)
- Field (name) — char(30)
- Field (address) — char(50)
- Field (phone) — char(20)