예제 3

테이블 (6)

Untitled (Dependent)

  • Key (dependentID) — char(10) — 기본 키 — NOT NULL
  • Field (dependent_name) — char(30)
  • Field (age) — char(3)
  • Key (clientID) — char(10) — 외래 키 → 고갹.Key — NOT NULL

Untitled (Service Provider)

  • Key (providerID) — char(10) — 기본 키 — NOT NULL
  • Field (provider_code) — char(10)
  • Field (provider_name) — char(30)
  • Field (address) — text
  • Field (contact_phone) — char(11)

Untitled (Service)

  • Key (serviceID) — char(10) — 기본 키 — NOT NULL
  • Field (service_code) — char(10)
  • Field (description) — text

Untitled (Provided Service)

  • Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (providerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Service Record)

  • Field (service_date) — char(8)
  • Key (clientID) — char(10) — 외래 키 → 고갹.Key — NOT NULL
  • Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

고갹 (Client)

  • Key (clientID) — char(10) — 기본 키 — NOT NULL
  • Field (ssn) — char(14)
  • Field (name) — char(30)
  • Field (address) — text
  • Field (phone_number) — char(11)