1

Tables (5)

Product (Untitled)

  • Product (id) — Primary key — NOT NULL
  • Product (name)
  • Product (QOH)

component

  • component (id) — Primary key — NOT NULL
  • component (name)
  • component (description)

compsupp (Untitled4)

  • Product (id2) — Foreign key → Product.Product — NOT NULL
  • component (id3) — Foreign key → component.component — NOT NULL

supplier (Untitled2)

  • supplier (id) — Primary key — NOT NULL
  • supplier (name)

supply (Untitled5)

  • component (id2) — Foreign key → component.component — NOT NULL
  • supplier (id3) — Foreign key → supplier.supplier — NOT NULL