5

Tables (6)

Untitled (shoes)

  • Key (ID) — char(10) — Primary key — NOT NULL
  • Field (quantity) — int(10)
  • Field (price) — int(10)
  • Key (ID2) — char(10) — Foreign key → subject.Key — NOT NULL
  • Key (ID3) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (supplier)

  • Key (ID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (phone) — int(13)
  • Field (email) — char(30)
  • Field (address) — char(30)
  • Field (suptype) — char(2)

Untitled (customer)

  • Key (ID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — int(13)
  • Field (vipmemo) — text

Untitled (sale)

  • Key (ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (saledate) — date
  • Field (salequantity) — int(1000)
  • Field (saletype) — int(3)
  • Field (salefee) — int(3)
  • Field (description) — text
  • Key (ID3) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (salesperson)

  • Key (ID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — int(13)
  • Field (salary) — char(10)

subject

  • Key (ID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (sizeCODE) — char(5)
  • Field (colorCODE) — char(1)
  • Field (styleCODE) — char(7)