ERD EXE1

Tables (6)

Copy Of Untitled (product_category)

  • Key (proCategoryID) — char(10) — Primary key — NOT NULL
  • Field (proCategoryName) — char(30)
  • Field (description) — text

Product (product)

  • Key (productID) — char(10) — Primary key — NOT NULL
  • Field (description) — text
  • Field (price) — int(10)
  • Field (productName) — char(30)
  • Field (releaseDate) — date
  • Key (proCategoryID) — char(10) — Foreign key → Copy Of Untitled.Key — NOT NULL

Untitled (part)

  • Key (partsID) — char(10) — Primary key — NOT NULL
  • Field (description) — text
  • Field (partName) — char(30)
  • Field (price) — int(10)
  • Key (manuID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (ptCategoryID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (product_part)

  • Key (productID) — char(10) — Foreign key → Product.Key — NOT NULL
  • Key (partsID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — int(4)

Untitled (manufacturer)

  • Key (manuID) — char(10) — Primary key — NOT NULL
  • Field (manuName) — char(30)
  • Field (phone) — char(11)
  • Field (adress) — char(50)
  • Field (description) — text

Untitled (part_category)

  • Key (ptCategoryID) — char(10) — Primary key — NOT NULL
  • Field (ptCategoryName) — char(30)
  • Field (description) — text