This article outlines the database structure for the MMv4 product_category_assoc database table. This table contains an entry for each product-to-category relationship. Each product may be associated with one or more categories.

• pid
  A reference to the product.id field.
  int(10) | unsigned | indexed
• cat
  A reference to the category.id field.
  int(10) | unsigned | indexed