NGS_erd_exe1

Tables (4)

Untitled (Product)

  • Key (pdtID) — char(10) — Primary key — NOT NULL
  • Field (description) — text
  • Field (price) — int(10)

Untitled (Producer)

  • Key (pdrID) — char(20) — Primary key — NOT NULL
  • Field

Untitled (Components)

  • Key (CompID) — char(10) — Primary key — NOT NULL
  • Field (description) — text

Untitled (Product-Components)

  • Key (PCID) — char(10) — Primary key — NOT NULL
  • Key (pdtID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (CompID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (compCount) — int(6)