2024-ex(3)

Tables (5)

Untitled (CLIENT)

  • Key (clientSsn) — char(15) — Primary key — NOT NULL
  • Field (clientName) — char(20)
  • Field (clientAddress) — char(30)
  • Field (clientPhoneNumber) — char(11)

Untitled (DEPENDENT)

  • Key (dependentSsn) — char(15) — Primary key — NOT NULL
  • Field (dependentName) — char(20)
  • Field (dependentAge) — char(3)
  • Key (clientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (serviceCode) — char(10) — Primary key — NOT NULL
  • Field (description) — text

Untitled (SERVICE_PROVIDER)

  • Key (proID) — char(10) — Primary key — NOT NULL
  • Field (proName) — char(20)
  • Field (proAddress) — char(30)
  • Field (proPhoneNumber) — char(11)

Untitled (SERVICE-MATCHING)

  • Key (clientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL
  • Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (proID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (serviceDate) — date