예제3
테이블 (4)
Untitled (COMMUNITY SERVICE)
- Key (RRN) — 기본 키 — NOT NULL
- Field (name)
- Field (address)
- Field2 (tel.)
- Field (age)
- Field (gender)
Untitled (SERVICE)
- Key (serviceCode) — 기본 키 — NOT NULL
- Field (description)
- Field (serviceName)
- Field (startDate)
- Key (RRN) — 외래 키 → Untitled.Key — NOT NULL
- Key (providerID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE PROVIDER)
- Key (providerID) — 기본 키 — NOT NULL
- Field (name)
- Field (address)
- Field (tel.)
- Field
Untitled (DEPENDENT)
- Key (RRN) — 기본 키 — NOT NULL
- Field (name)
- Field (relation)
- Field (age)
- Field (gender)
- Field (tel.)
- Key (RRN2) — 외래 키 → Untitled.Key — NOT NULL