웹DB_문제3

테이블 (6)

Untitled (ORGANIZATION)

  • Key (oID) — char(30) — 기본 키 — NOT NULL
  • Field (oName) — char(30)
  • Field (oLocation) — char(30)
  • Field (oStartdate) — date

Untitled (CLIENT)

  • Key (ssn) — char(14) — 기본 키 — NOT NULL
  • Field (cName) — char(20)
  • Field (cAddress) — char(30)
  • Field (cPhonenum) — char(11)
  • Field (cAge) — int(3)
  • Key (oID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (ssn) — char(14) — 기본 키 — NOT NULL
  • Field (dName) — char(20)
  • Field (dBday) — date
  • Field (dGender) — char(1)
  • Field (dRelationship) — char(10)
  • Key (cssn) — int(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (sCode) — char(30) — 기본 키 — NOT NULL
  • Field (sName) — char(30)
  • Field (description) — text
  • Field (sStartdate) — date
  • Key (oID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE_PROVIDER)

  • Key (ssn) — char(14) — 기본 키 — NOT NULL
  • Field (pName) — char(20)
  • Field (pAddress) — char(30)
  • Field (pPhonenum) — char(11)
  • Key (sCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE_CLIENT)

  • Key (sCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL
  • Field (date) — date