E3

Tables (5)

CUSTOMER

  • Key (cID) — char(13) — Primary key — NOT NULL
  • Field (cName) — char(30)
  • Field (address) — char(50)
  • Field (phone) — char(11)
  • Field (typeNeed) — char(30)

Untitled (DEPENDENT)

  • Key (dID) — char(13) — Primary key — NOT NULL
  • Field (dName) — char(30)
  • Key (cID) — char(13) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (relation) — char(10)

Untitled (SERVICE)

  • Key (sID) — char(5) — Primary key — NOT NULL
  • Field (sName) — char(30)
  • Field (type) — char(30)
  • Field (descrription) — text

Untitled (SERVICE_PROVIDER)

  • Key (pID) — char(5) — Primary key — NOT NULL
  • Key (sID) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (pName) — char(30)
  • Field (address) — char(50)
  • Field (phone) — char(11)
  • Field (affiliation) — char(30)

Untitled (SERVICE_DATE)

  • Key (sID) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (sDate) — date
  • Key (cID) — char(13) — Foreign key → CUSTOMER.Key — NOT NULL