연습문제3
테이블 (5)
Untitled (CLIENT)
- Key (CLIID) — CHAR(10) — 기본 키 — NOT NULL
- Field (Name) — CHAR(10)
- Field (Address) — CHAR(20)
- Field (PhoneNumber) — CHAR(20)
- Field (Age) — CHAR(3)
Untitled (DEPENDENT)
- Key (DEPID) — CHAR(10) — 기본 키 — NOT NULL
- Field (Name) — CHAR(10)
- Field (Address) — CHAR(20)
- Field (Age) — CHAR(3)
- Field (Gender) — CHAR(2)
- Key (CUSID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (SERID) — CHAR(10) — 기본 키 — NOT NULL
- Field (Explain) — CHAR(40)
Untitled (CUS-SER)
- Key (SERID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (CLIID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (ServiceDate) — DATE
- Field (ServiceTime) — INT(20)
- Key (PROID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROVIDER)
- Key (PROID) — CHAR(10) — 기본 키 — NOT NULL
- Field (Name) — CHAR(10)
- Field (Address) — CHAR(20)
- Field (PhoneNumber) — CHAR(20)