Shopware 6.7.8.0 product_category
Junction table directly assigning products to categories.
| 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.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 |
