gjh

Tables (5)

client

  • clientSsn — INT(9)
  • clientName — CHAR(60)
  • clientAddr — CHAR(60)
  • clientPhone — INT(11)

family

  • familySsn — INT(9)
  • familyName — CHAR(60)
  • familyAge — INT(3)
  • clientSsn — CHAR(9)

provider

  • provId — INT
  • provName — CHAR(60)
  • provAddr — CHAR(60)
  • provPhone — INT(11)

service

  • serviceId — INT
  • serviceDesc — TEXT

servicerecord

  • serviceRecordId — INT
  • clientSsn — INT(9)
  • provId — INT
  • serviceId — INT
  • serviceDate — DATE