연습3

테이블 (4)

CLIENTELE (Untitled4)

  • ssn (Field) — char(14)
  • name (Field2) — char(20)
  • adress (Field3) — text
  • phone (Field4) — char(15)

ORGANIZATION (Untitled)

  • clienteleSsn (Key) — char(14) — 기본 키 — NOT NULL
  • clientName (Field) — char(20)
  • clientAdress (Field2) — text
  • clientPhone (Field3) — char(15)
  • supportFamilySsn (Field4) — char(14)
  • supFamName (Field5) — char(20)
  • supFamAge (Field6) — integer(2)

SERVICE (Untitled2)

  • serCode (Field) — car(10)
  • descripton (Field2) — text
  • date (Field3) — char(6)
  • clienteleSsn (Key) — char(14) — 외래 키 → ORGANIZATION.clienteleSsn — NOT NULL

SERVICE_PROVIDER (Untitled3)

  • providerID (Field) — char(15)
  • name (Field2) — char(20)
  • adress (Field3) — text
  • phone (Field4) — char(15)
  • clienteleSsn (Key) — char(14) — 외래 키 → ORGANIZATION.clienteleSsn — NOT NULL