erd 2번과제 작성하기

테이블 (3)

Untitled (client)

  • Key (serviceCode) — clar(20) — 기본 키 — NOT NULL
  • Field (clientname) — clar(10)
  • Field (clientadress) — clar(20)
  • Field (clientlevel) — clar(10)

Untitled (dependent)

  • Key (dependentName) — clar(12) — 기본 키 — NOT NULL
  • Field (dependentAge) — clar(10)
  • Key (serviceCode) — clar(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (service)

  • Key (serviceCode) — clar(20) — 기본 키 — NOT NULL
  • Key (serviceCode2) — clar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (program) — text
  • Field (date) — date