example5

Tables (5)

Object

  • Key (shoesCode) — int(10) — Primary key — NOT NULL
  • Field (model) — char(10)
  • Field (size) — int(3)
  • Field (color) — char(10)
  • Field (quentity) — int(10)
  • Key (supplyCode) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Supplier)

  • Key (supplyCode) — int(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (tel) — int(11)

Untitled (Client)

  • Key (clientCode) — int(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(30)
  • Field (tel) — int(11)
  • Field

Untitled (Purchase)

  • Key (shoesCode) — int(10) — Foreign key → Object.Key — NOT NULL
  • Key (clientCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (salesCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (purchaseDate) — date
  • Field2 (purchasequentity) — int(3)

Untitled (Salesperson)

  • Key (salesCode) — int(10) — Primary key — NOT NULL
  • Field (name) — char(10)