예제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