EX3

Tables (5)

client (Untitled)

  • clientid (Key2) — char(13) — Primary key — NOT NULL
  • ssn (Key) — char(13) — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — text
  • phone (Field3) — char(11)

client-service (Untitled5)

  • client-serviceid (Key) — char(13) — Primary key — NOT NULL
  • clientid (Key2) — char(13) — Foreign key → client.clientid — NOT NULL
  • serviceid (Key3) — char(13) — Foreign key → service.serviceid — NOT NULL
  • date (Field) — date

depndent (Untitled2)

  • depndentid (Key) — char(13) — Primary key — NOT NULL
  • ssn (Field) — char(13)
  • name (Field2) — char(10)
  • age (Field3) — char(3)
  • clientid (Key2) — char(13) — Foreign key → client.clientid — NOT NULL

provider (Untitled3)

  • providerid (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — text
  • phone (Field3) — char(11)
  • agency (Field4) — char(10)
  • serviceid (Key2) — char(13) — Foreign key → service.serviceid — NOT NULL

service (Untitled4)

  • serviceid (Key) — char(13) — Primary key — NOT NULL
  • description (Field) — text