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