exercise3
Tables (5)
DEPENDENT (SERVICE)
- dependentssn (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- age (Field2) — int(2)
- clientssn (Key2) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL
FEMALE_CLIENT (PROVIDER)
- clientssn (Key) — char(10) — Primary key — NOT NULL
- name (Field3) — char(10)
- address (Field) — char(30)
- phone (Field2) — char(10)
- serviceDate (Field4) — char(10)
ORANIZATION (SERVICEGROUP)
- clientssn (Key2) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL
- dependentssn (Key) — char(10) — Foreign key → DEPENDENT.dependentssn — NOT NULL
PROVIDER (CLIENT)
- providerSsn (Key) — char(10) — Primary key — NOT NULL
- clientssn (Key3) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — char(10)
SERVICE (DEPENDENT)
- serviceCode (Key) — char(10) — Primary key — NOT NULL
- providerSsn (Key3) — char(10) — Foreign key → PROVIDER.providerSsn — NOT NULL
- clientssn (Key32) — char(10) — Foreign key → PROVIDER.clientssn — NOT NULL
- description (Field) — text
- clientssn (Key2) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL