과제 3 wmx

테이블 (5)

client (Untitled)

  • clientSsn (Field) — int(9) — 기본 키
  • clientName (Field2) — char(60)
  • chientAdder (Field3) — char(60)
  • clientPhone (Field4) — int(11)
  • familySsn (Field5) — int(9) — 외래 키 → family.familySsn

family (Untitled2)

  • familySsn (Field) — int(9) — 기본 키
  • familyName (Field2) — char(60)
  • familyAge (Field3) — int(3)
  • clientSsn (Field4) — int(9)

provider (Untitled3)

  • provId (Field) — int(9) — 기본 키
  • provName (Field2) — char(60)
  • provAddr (Field3) — char(60)
  • provPhone (Field4) — int(11)

service (Untitled4)

  • serviceId (Field) — int(9) — 기본 키
  • serviceDesc (Field2) — text

servicerecord (Untitled5)

  • serviceRecordId (Field) — int(9) — 기본 키
  • clientSsn (Field2) — int(9)
  • provId (Field3) — int(9)
  • serviceId (Field4) — int(9)
  • serviceDate (Field5) — date
  • Field6
  • provId (Field7) — int(9) — 외래 키 → provider.provId
  • serviceId (Field8) — int(9) — 외래 키 → service.serviceId
  • clientSsn (Field9) — int(9) — 외래 키 → client.clientSsn