example 3

Tables (6)

Untitled (Client)

  • Key (clientID) — int(10) — Primary key — NOT NULL
  • Field (ID) — int(13)
  • Field2 (name) — char(5)
  • Field3 (address) — char(30)
  • Field (tel) — int(11)

Untitled (Family)

  • Key (familyID) — int(10) — Primary key — NOT NULL
  • Field3 (ID) — int(13)
  • Field (name) — char(5)
  • Field (age) — int(3)
  • Key (clientID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Service)

  • Key (ServiceCode) — int(10) — Primary key — NOT NULL
  • Field (title) — char(20)
  • Field2 (description) — text

Untitled (Maching)

  • Key (ServiceCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (clientID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (startDate) — date

Untitled (Agent)

  • Key (agentID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field2 (address) — char(30)
  • Field3 (tel) — int(11)
  • Field (organization) — char(20)

Untitled (ServiceProvider)

  • Key (ServiceCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (agentID) — int(10) — Foreign key → Untitled.Key — NOT NULL