exercise3
Tables (5)
Untitled (FEMALE_CLEENTS)
- Key (social_security_number) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone) — char(30)
Untitled (SERVICES_PROVIDERS)
- Key (provider_identifier) — char(30) — Foreign key → Untitled3.Key — NOT NULL
- Key (service_identifier) — char(30) — Foreign key → Untitled4.Key — NOT NULL
Untitled2 (DEPENDENTS)
- Key (ssn) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (age) — int(30)
- Key (social_secuurity_number) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled3 (PROVIDERS)
- Key (provider_identifier) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone) — char(30)
Untitled4 (SERVICES)
- Key (service_identifier) — char(30) — Primary key — NOT NULL
- Field (description) — text
- Key (social_security_number) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Field (happen_date) — date