ERD-01

Tables (5)

Copy Of Untitled (COMPONENT)

  • Key (componentNo) — int(6) — Primary key — NOT NULL
  • Field (componentAcc) — char(50)

Untitled (PRODUCT)

  • Key (productNo) — int(6) — Primary key — NOT NULL
  • Field (productAcc) — char(50)
  • Field (product or) — int(20)

Untitled (MANUFACTURER)

  • Key (manufacturerNo) — ini(6) — Primary key — NOT NULL
  • Field (manufacturerName) — char(20)
  • Field (manufacturerAdd) — char(50)
  • Field (manufacturerPhone) — char(15)

Untitled (PRODUCT_COMPONENT)

  • Key (productNo) — int(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (componentNo) — int(6) — Foreign key → Copy Of Untitled.Key — NOT NULL

Untitled (MANUFACTURER_COMPONENT)

  • Key (manufacturerNo) — ini(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (componentNo) — int(6) — Foreign key → Copy Of Untitled.Key — NOT NULL