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