Exercise3

Tables (4)

ServiceProvider (Untitled)

  • Key (ServiceCode) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (CusID) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (DepenID) — int(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (Customer)

  • Key (CusID) — int(13) — Primary key — NOT NULL
  • Field (CusName) — char(20)
  • Field (CusADD) — text
  • Field (CusPhone) — int(15)

Untitled (Dependents)

  • Key (DepenID) — int(13) — Primary key — NOT NULL
  • Field (DepenName) — char(20)
  • Field (DepenADD) — text
  • Field (DepenAge) — int(2)
  • Key (CusID) — int(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (Service)

  • Key (ServiceCode) — int(20) — Primary key — NOT NULL
  • Key (CusID) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (DepenID) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Field (ServiceDes) — longtext
  • Field (ServiceRec) — date