rhkwp1

Tables (5)

Untitled (Client)

  • Key (clientId) — char(13) — Primary key — NOT NULL
  • Field (name) — char
  • Field (address) — char
  • Field (phone) — char(11)
  • Key (dependentId2) — char(7) — Foreign key → Untitled.Key — NOT NULL

Untitled (Dependent)

  • Key (dependentId) — char(7) — Primary key — NOT NULL
  • Field (name) — char
  • Field (age) — int

Untitled (Service)

  • Key (serviceCode) — char(7) — Primary key — NOT NULL
  • Field (description) — char(50)

Untitled (ServiceProvider)

  • Key (provideId) — char(7) — Primary key — NOT NULL
  • Field (name) — char
  • Field (Address) — char
  • Field (contact)

Untitled2 (Servicerecord)

  • Key (clientId) — char(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (provideId) — char(7) — Foreign key → Untitled.Key — NOT NULL
  • Field (serviceDate) — int
  • Key (serviceCode) — char(7) — Foreign key → Untitled.Key — NOT NULL