Exercise3(배미연)

테이블 (4)

Client (Untitled)

  • ClientCode (Key) — char(13) — 기본 키 — NOT NULL
  • ClientName (Field) — char(10)
  • ClientAddress (Field2) — char(30)
  • ClientPhone (Field3) — char(11)

Family (Untitled2)

  • FamilyCode (Key) — char(13) — 기본 키 — NOT NULL
  • FamilyName (Field) — char(10)
  • FamilyAge (Field2) — char(3)
  • FamilyRelation (Field3) — char(10)
  • MemberCode (Key2) — char(13) — 외래 키 → Client.ClientCode — NOT NULL

Provider (Untitled4)

  • ProviderNo (Key) — char(4) — 기본 키 — NOT NULL
  • ProviderName (Field) — char(10)
  • ProviderType (Field2) — char(3)
  • ProviderAddress (Field3) — char(30)
  • ProviderPhone (Field4) — char(11)

Service (Untitled3)

  • ServiceCode (Key) — char(4) — 기본 키 — NOT NULL
  • ServiceName (Field) — char(10)
  • ServiceStartdate (Field2) — date
  • providerNo (Key2) — char(4) — 외래 키 → Provider.ProviderNo — NOT NULL
  • MemberCode (Key3) — char(13) — 외래 키 → Client.ClientCode — NOT NULL