4주차 연습문제
테이블 (5)
Untitled (CLIENT)
- Key (cID) — char(13) — 기본 키 — NOT NULL
- Field (cName) — char(10)
- Field (cAddress) — text
- Field (cPhone) — char(11)
- Field (cAge) — int(2)
- Field (cDescription) — text
Untitled (DEPENDENT)
- Key (dID) — char(13) — 기본 키 — NOT NULL
- Key (cID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (dName) — char(10)
- Field (dAge) — int(2)
Untitled (SERVICE_PROVIDER)
- Key (sID) — char(13) — 기본 키 — NOT NULL
- Key (sCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (sName) — char(10)
- Field (sAddress) — text
- Field (sPhone) — char(11)
Untitled (SERVICE)
- Key (sCode) — char(10) — 기본 키 — NOT NULL
- Field (sDescription) — text
- Field (sDate) — date
Untitled (REGISTERED_SERVICE)
- Key (cID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (sID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (sCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL