4주차 연습문제

테이블 (5)

Untitled (CLIENT)

  • Key (cID) — char(13) — 기본 키 — NOT NULL
  • Field (cName) — char(10)
  • Field (cAddress) — text
  • Field (cPhone) — char(11)
  • Field (cAge) — int(2)
  • Field (cDescription) — text

Untitled (DEPENDENT)

  • Key (dID) — char(13) — 기본 키 — NOT NULL
  • Key (cID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (dName) — char(10)
  • Field (dAge) — int(2)

Untitled (SERVICE_PROVIDER)

  • Key (sID) — char(13) — 기본 키 — NOT NULL
  • Key (sCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (sName) — char(10)
  • Field (sAddress) — text
  • Field (sPhone) — char(11)

Untitled (SERVICE)

  • Key (sCode) — char(10) — 기본 키 — NOT NULL
  • Field (sDescription) — text
  • Field (sDate) — date

Untitled (REGISTERED_SERVICE)

  • Key (cID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (sID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (sCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL