3주차과제Ex3

테이블 (5)

CUSDEPENDENT (Untitled4)

  • depSsn (Key) — char(13) — 기본 키 — NOT NULL
  • depName (Field) — char(20)
  • depphone (Field2) — char(13)
  • depRlationship (Field3) — char(4)
  • description (Field4) — text
  • cusSsn (Key2) — char(20) — 외래 키 → CUSTOMER.cusSsn — NOT NULL

CUSTOMER

  • cusSsn (Key) — char(20) — 기본 키 — NOT NULL
  • cusAddress (Field) — char(50)
  • cusPhone (Field2) — char(12)
  • cusName (Field3) — char(20)

SERVICE EDUCATION (Untitled3)

  • sereduCode (Key) — char(20) — 기본 키 — NOT NULL
  • cusSsn (Key2) — char(20) — 외래 키 → CUSTOMER.cusSsn — NOT NULL
  • SPROID (Key3) — char(20) — 외래 키 → SERVICEPROVIDER.SPROID — NOT NULL
  • cusSsn (Key4) — char(20) — 외래 키 → SERVICEGROUP.cusSsn — NOT NULL
  • SPROID (Key22) — char(20) — 외래 키 → SERVICEGROUP.SPROID — NOT NULL
  • seredustartDate (Field) — date

SERVICEGROUP (Untitled)

  • cusSsn (Key) — char(20) — 외래 키 → CUSTOMER.cusSsn — NOT NULL
  • SPROID (Key2) — char(20) — 외래 키 → SERVICEPROVIDER.SPROID — NOT NULL

SERVICEPROVIDER (Untitled2)

  • SPROID (Key) — char(20) — 기본 키 — NOT NULL
  • sproName (Field) — char(20)
  • sproAddress (Field2) — char(50)
  • sproContactN (Field3) — char(12)