Shopware 6.7.7.1 product_category_tree
Columns
| 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 |
Indexes
| 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 |