과제3(임미숙)

테이블 (5)

CLIENT (Untitled2)

  • clientSsn (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char920)
  • address (Field2) — char(30)
  • phone (Field3) — char(15)
  • policyNo (Key2) — char(10) — 외래 키 → ORGANIZATION.policyNo — NOT NULL

DEPENDENT (Untitled5)

  • dependentSsn (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • age (Field2) — char(5)
  • serviceId (Key2) — char(10) — 외래 키 → SERVICE.serviceId — NOT NULL

ORGANIZATION (Untitled)

  • policyNo (Key) — char(10) — 기본 키 — NOT NULL
  • clientSsn (Field) — char(10)
  • serviceCode (Field2) — char(10)
  • dependent (Field3) — char(10)

PROVIDER (Untitled4)

  • providerId (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(30)
  • phone (Field3) — char(15)
  • serviceId (Key2) — char(10) — 외래 키 → SERVICE.serviceId — NOT NULL

SERVICE (Untitled3)

  • serviceId (Key) — char(10) — 기본 키 — NOT NULL
  • description (Field) — text
  • servicedate (Field2) — char(15)
  • provider (Field3) — char(10)
  • clientSsn (Key2) — char(10) — 외래 키 → CLIENT.clientSsn — NOT NULL