Shopware 6.7.8.1 product_category_tree
Denormalized product-to-category mapping including inherited parent categories (for fast filtering).
| Column | Type | Nullable | Additional |
| product_id | binary(16) | NO | Primary Key
Foreign Key → product.id |
| product_version_id | binary(16) | NO | Primary Key
Foreign Key → product.version_id |
| category_id | binary(16) | NO | Primary Key
Foreign Key → category.id |
| category_version_id | binary(16) | NO | Primary Key
Foreign Key → category.version_id |
| Index Name | Columns | Unique |
| fk.product_category_tree.category_id | category_id,category_version_id | No |
| PRIMARY | product_id,product_version_id,category_id,category_version_id | Yes |
Relations (from this table)
4 relations
| Local Field | Foreign Table | Foreign Field |
| category_id | category | id |
| category_version_id | category | version_id |
| product_id | product | id |
| product_version_id | product | version_id |
