Shopware 6.7.7.1 product
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | binary(16) | NO | Primary Key |
| version_id | binary(16) | NO | Primary Key |
| auto_increment | int | NO | Unique, auto_increment |
| product_number | varchar(64) | YES | Index |
| active | tinyint unsigned | YES | |
| parent_id | binary(16) | YES | Index Foreign Key → product.id |
| parent_version_id | binary(16) | YES | Foreign Key → product.version_id |
| tax_id | binary(16) | YES | Index Foreign Key → tax.id |
| product_manufacturer_id | binary(16) | YES | Index Foreign Key → product_manufacturer.id |
| product_manufacturer_version_id | binary(16) | YES | Foreign Key → product_manufacturer.version_id |
| delivery_time_id | binary(16) | YES | |
| deliveryTime | binary(16) | YES | |
| product_media_id | binary(16) | YES | Index |
| product_media_version_id | binary(16) | YES | |
| cms_page_id | binary(16) | YES | Index Foreign Key → cms_page.id |
| cms_page_version_id | binary(16) | NO | Default: 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 Foreign Key → cms_page.version_id |
| unit_id | binary(16) | YES | Index Foreign Key → unit.id |
| product_feature_set_id | binary(16) | YES | Index Foreign Key → product_feature_set.id |
| category_tree | json | YES | |
| category_ids | json | YES | |
| stream_ids | json | YES | |
| option_ids | json | YES | |
| property_ids | json | YES | |
| tax | binary(16) | YES | |
| manufacturer | binary(16) | YES | |
| cover | binary(16) | YES | |
| unit | binary(16) | YES | |
| media | binary(16) | YES | |
| prices | binary(16) | YES | |
| visibilities | binary(16) | YES | |
| properties | binary(16) | YES | |
| categories | binary(16) | YES | Index |
| translations | binary(16) | YES | |
| price | json | YES | |
| manufacturer_number | varchar(255) | YES | |
| ean | varchar(255) | YES | |
| sales | int | NO | Default: 0 |
| stock | int | NO | |
| available_stock | int | YES | |
| available | tinyint(1) | NO | Default: 0 |
| restock_time | int | YES | |
| is_closeout | tinyint(1) | YES | |
| purchase_steps | int unsigned | YES | |
| max_purchase | int unsigned | YES | |
| min_purchase | int unsigned | YES | |
| purchase_unit | decimal(11,4) unsigned | YES | |
| reference_unit | decimal(10,3) unsigned | YES | |
| shipping_free | tinyint(1) | YES | |
| purchase_prices | json | YES | |
| mark_as_topseller | tinyint unsigned | YES | |
| weight | decimal(15,6) unsigned | YES | |
| width | decimal(10,3) unsigned | YES | |
| height | decimal(10,3) unsigned | YES | |
| length | decimal(10,3) unsigned | YES | |
| release_date | datetime(3) | YES | |
| tag_ids | json | YES | |
| tags | binary(16) | YES | |
| variant_restrictions | json | YES | |
| created_at | datetime(3) | YES | |
| updated_at | datetime(3) | YES | |
| rating_average | float | YES | |
| display_group | varchar(50) | YES | |
| child_count | int | YES | |
| crossSellings | binary(16) | YES | |
| featureSet | binary(16) | YES | |
| customFieldSets | binary(16) | YES | |
| custom_field_set_selection_active | tinyint(1) | YES | |
| canonical_product_id | binary(16) | YES | Index Foreign Key → product.id |
| canonical_product_version_id | binary(16) | YES | Foreign Key → product.version_id |
| canonicalProduct | binary(16) | YES | |
| cmsPage | binary(16) | YES | |
| cheapest_price | longtext | YES | |
| cheapest_price_accessor | longtext | YES | |
| states | json | YES | |
| variant_listing_config | json | YES | |
| type | varchar(32) | NO | Index, Default: physical |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| auto_increment | auto_increment | Yes |
| fk.product.canonical_product_id | canonical_product_id,canonical_product_version_id | No |
| fk.product.cms_page_id | cms_page_id,cms_page_version_id | No |
| fk.product.feature_set_id | product_feature_set_id | No |
| fk.product.parent_id | parent_id,parent_version_id | No |
| fk.product.product_manufacturer | product_manufacturer_id,product_manufacturer_version_id | No |
| fk.product.product_media_id | product_media_id,product_media_version_id | No |
| fk.product.tax_id | tax_id | No |
| fk.product.unit_id | unit_id | No |
| idx.product.categories | categories | No |
| idx.product.type | type | No |
| PRIMARY | id,version_id | Yes |
| uniq.product.product_number__version_id | product_number,version_id | Yes |
Relations (from this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| canonical_product_id | product | id |
| canonical_product_version_id | product | version_id |
| cms_page_id | cms_page | id |
| cms_page_version_id | cms_page | version_id |
| product_feature_set_id | product_feature_set | id |
| parent_id | product | id |
| parent_version_id | product | version_id |
| product_manufacturer_id | product_manufacturer | id |
| product_manufacturer_version_id | product_manufacturer | version_id |
| tax_id | tax | id |
| unit_id | unit | id |
Relations (to this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| id | customer_wishlist_product | product_id |
| version_id | customer_wishlist_product | product_version_id |
| id | main_category | product_id |
| version_id | main_category | product_version_id |
| id | order_line_item | product_id |
| version_id | order_line_item | product_version_id |
| id | product | canonical_product_id |
| version_id | product | canonical_product_version_id |
| id | product | parent_id |
| version_id | product | parent_version_id |
| id | product_category | product_id |
| version_id | product_category | product_version_id |
| id | product_category_tree | product_id |
| version_id | product_category_tree | product_version_id |
| id | product_configurator_setting | product_id |
| version_id | product_configurator_setting | product_version_id |
| id | product_cross_selling | product_id |
| version_id | product_cross_selling | product_version_id |
| id | product_cross_selling_assigned_products | product_id |
| version_id | product_cross_selling_assigned_products | product_version_id |
| id | product_custom_field_set | product_id |
| version_id | product_custom_field_set | product_version_id |
| id | product_download | product_id |
| version_id | product_download | product_version_id |
| id | product_media | product_id |
| version_id | product_media | product_version_id |
| id | product_option | product_id |
| version_id | product_option | product_version_id |
| id | product_price | product_id |
| version_id | product_price | product_version_id |
| id | product_property | product_id |
| version_id | product_property | product_version_id |
| id | product_review | product_id |
| version_id | product_review | product_version_id |
| id | product_search_keyword | product_id |
| version_id | product_search_keyword | product_version_id |
| id | product_stream_mapping | product_id |
| version_id | product_stream_mapping | product_version_id |
| id | product_tag | product_id |
| version_id | product_tag | product_version_id |
| id | product_translation | product_id |
| version_id | product_translation | product_version_id |
| id | product_visibility | product_id |
| version_id | product_visibility | product_version_id |