Exercise3

Tables (6)

Untitled (Service system)

  • Key (Re-number) — char(15) — Primary key — NOT NULL
  • Field (name) — char(15)
  • Field (address) — char(20)
  • Field (phone number) — char(15)
  • Field
  • Key (vo-education) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Dependent family)

  • Key (Re-number) — char(15) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (age) — char(5)

Untitled (Service)

  • Key (vo-education) — char(20) — Primary key — NOT NULL
  • Field (matching) — char(15)

Untitled (service code)

  • Key (code) — char(10) — Primary key — NOT NULL
  • Field (explain) — text
  • Field (date) — char(10)

Untitled (service provider)

  • Key (code) — char(15) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(15)
  • Field (phone) — char(15)

Untitled (service user)

  • Key (date) — char(10) — Primary key — NOT NULL
  • Key (vo-education) — char(20) — Foreign key → Untitled.Key — NOT NULL