wrewt

Tables (4)

DEPENDENT

  • Key (depenID) — char(13) — Primary key — NOT NULL
  • Field (depenName) — char(30)
  • Field2 (birthDate) — date
  • Key (clientID) — char(13) — Foreign key → Untitled3.Key — NOT NULL
  • Key (serviceCode) — char(10) — Foreign key → Untitled3.Key — NOT NULL

Untitled (SERVICE)

  • Key (serviceCode) — char(10) — Primary key — NOT NULL
  • Field (description) — text
  • Field (date) — date
  • Key (proID) — char(13) — Foreign key → Untitled4.Key — NOT NULL
  • Key2 (proName) — char(20) — Foreign key → Untitled4.Key2 — NOT NULL

Untitled3 (FEMALE-CLIENT)

  • Key (clientID) — char(13) — Primary key — NOT NULL
  • Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (clientNane) — char(20)
  • Field (clientAddress) — char(30)
  • Field (clientPhone) — char(11)

Untitled4 (SERVICE-PROVIDER)

  • Key (proID) — char(13) — Primary key — NOT NULL
  • Key2 (proName) — char(20) — Primary key — NOT NULL
  • Field (proAddress) — char(30)
  • Field (proPhone) — char(11)