예제 3다시

테이블 (6)

Untitled (client)

  • Key (ssn) — 기본 키 — NOT NULL
  • Field (address)
  • Field (name)
  • Field (phonenumber)

Untitled (dependent)

  • Key (dependent_ssn) — 기본 키 — NOT NULL
  • Field (name)
  • Field (year)
  • Key (ssn) — 외래 키 → Untitled.Key — NOT NULL

Untitled (service)

  • Key (identifier) — 기본 키 — NOT NULL
  • Field (description)

Untitled (service provider)

  • Key (provider_identifier) — 기본 키 — NOT NULL
  • Field (name)
  • Field (address)
  • Field (provider phone number)

Untitled (service record)

  • Key (이용기록) — 기본 키 — NOT NULL
  • Key (ssn) — 외래 키 → Untitled.Key — NOT NULL
  • Field (happendate)
  • Key (provider_identifier) — 외래 키 → Untitled.Key — NOT NULL
  • Key (identifier2) — 외래 키 → Untitled.Key — NOT NULL

Untitled (제공가능서비스)

  • Key (provider_identifier) — 외래 키 → Untitled.Key — NOT NULL
  • Key (identifier2) — 외래 키 → Untitled.Key — NOT NULL