2022913002/ERD ex1

Tables (5)

CATEGORY (Untitled2)

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

PART (COMPONENT)

  • Key (ComponentID) — char(10) — Primary key — NOT NULL
  • Key (ProducerID) — char(10) — Foreign key → SUPPLIER.Key — NOT NULL
  • Field (explain) — char(10)
  • Field — char(20)
  • Field (Field2) — text
  • Field3 — int(10)
  • Key — char(20) — Foreign key → CATEGORY.Key — NOT NULL

PRODUCT

  • Key (ProductID) — char(20) — Primary key — NOT NULL
  • Field (explain) — char(*)
  • Field (pay) — text
  • Field — char(20)

PRODUCT_PART (Untitled)

  • Key (ComponentID) — char(10) — Foreign key → PART.Key — NOT NULL
  • Key (ProducerID) — char(10) — Foreign key → PART.Key — NOT NULL
  • Key (ProductID) — char(20) — Foreign key → PRODUCT.Key — NOT NULL
  • Field — int(10)
  • Field3 — char(20)

SUPPLIER (PRODUCER)

  • Key (ProducerID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field2 (address) — char(20)
  • Field3 (phone) — char(11)