Shopware 6.7.8.0 product_property
Assigns filterable property values (e.g. material, color) to products for faceted search.
| 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 |
| property_group_option_id | binary(16) | NO | Primary Key
Foreign Key → property_group_option.id |
| Index Name | Columns | Unique |
| fk.product_property.configuration_option_id | property_group_option_id | No |
| PRIMARY | product_id,product_version_id,property_group_option_id | Yes |
Relations (from this table)
3 relations