erd 2번과제 작성하기
테이블 (3)
Untitled (client)
- Key (serviceCode) — clar(20) — 기본 키 — NOT NULL
- Field (clientname) — clar(10)
- Field (clientadress) — clar(20)
- Field (clientlevel) — clar(10)
Untitled (dependent)
- Key (dependentName) — clar(12) — 기본 키 — NOT NULL
- Field (dependentAge) — clar(10)
- Key (serviceCode) — clar(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (service)
- Key (serviceCode) — clar(20) — 기본 키 — NOT NULL
- Key (serviceCode2) — clar(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (program) — text
- Field (date) — date