Fields (76)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | binary(16) | NO | PRI | NULL | |
| version_id | binary(16) | NO | PRI | NULL | |
| auto_increment | int | NO | UNI | NULL | auto_increment |
| product_number | varchar(64) | YES | MUL | NULL | |
| active | tinyint unsigned | YES | NULL | ||
| parent_id | binary(16) | YES | MUL | NULL | |
| parent_version_id | binary(16) | YES | NULL | ||
| tax_id | binary(16) | YES | MUL | NULL | |
| product_manufacturer_id | binary(16) | YES | MUL | NULL | |
| product_manufacturer_version_id | binary(16) | YES | NULL | ||
| delivery_time_id | binary(16) | YES | NULL | ||
| deliveryTime | binary(16) | YES | NULL | ||
| product_media_id | binary(16) | YES | MUL | NULL | |
| product_media_version_id | binary(16) | YES | NULL | ||
| cms_page_id | binary(16) | YES | MUL | NULL | |
| cms_page_version_id | binary(16) | NO | 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 | ||
| unit_id | binary(16) | YES | MUL | NULL | |
| product_feature_set_id | binary(16) | YES | MUL | NULL | |
| category_tree | json | YES | NULL | ||
| category_ids | json | YES | NULL | ||
| stream_ids | json | YES | NULL | ||
| option_ids | json | YES | NULL | ||
| property_ids | json | YES | NULL | ||
| tax | binary(16) | YES | NULL | ||
| manufacturer | binary(16) | YES | NULL | ||
| cover | binary(16) | YES | NULL | ||
| unit | binary(16) | YES | NULL | ||
| media | binary(16) | YES | NULL | ||
| prices | binary(16) | YES | NULL | ||
| visibilities | binary(16) | YES | NULL | ||
| properties | binary(16) | YES | NULL | ||
| categories | binary(16) | YES | MUL | NULL | |
| translations | binary(16) | YES | NULL | ||
| price | json | YES | NULL | ||
| manufacturer_number | varchar(255) | YES | NULL | ||
| ean | varchar(255) | YES | NULL | ||
| sales | int | NO | 0 | ||
| stock | int | NO | NULL | ||
| available_stock | int | YES | NULL | ||
| available | tinyint(1) | NO | 0 | ||
| restock_time | int | YES | NULL | ||
| is_closeout | tinyint(1) | YES | NULL | ||
| purchase_steps | int unsigned | YES | NULL | ||
| max_purchase | int unsigned | YES | NULL | ||
| min_purchase | int unsigned | YES | NULL | ||
| purchase_unit | decimal(11,4) unsigned | YES | NULL | ||
| reference_unit | decimal(10,3) unsigned | YES | NULL | ||
| shipping_free | tinyint(1) | YES | NULL | ||
| purchase_prices | json | YES | NULL | ||
| mark_as_topseller | tinyint unsigned | YES | NULL | ||
| weight | decimal(15,6) unsigned | YES | NULL | ||
| width | decimal(10,3) unsigned | YES | NULL | ||
| height | decimal(10,3) unsigned | YES | NULL | ||
| length | decimal(10,3) unsigned | YES | NULL | ||
| release_date | datetime(3) | YES | NULL | ||
| tag_ids | json | YES | NULL | ||
| tags | binary(16) | YES | NULL | ||
| variant_restrictions | json | YES | NULL | ||
| created_at | datetime(3) | YES | NULL | ||
| updated_at | datetime(3) | YES | NULL | ||
| rating_average | float | YES | NULL | ||
| display_group | varchar(50) | YES | NULL | ||
| child_count | int | YES | NULL | ||
| crossSellings | binary(16) | YES | NULL | ||
| featureSet | binary(16) | YES | NULL | ||
| customFieldSets | binary(16) | YES | NULL | ||
| custom_field_set_selection_active | tinyint(1) | YES | NULL | ||
| canonical_product_id | binary(16) | YES | MUL | NULL | |
| canonical_product_version_id | binary(16) | YES | NULL | ||
| canonicalProduct | binary(16) | YES | NULL | ||
| cmsPage | binary(16) | YES | NULL | ||
| cheapest_price | longtext | YES | NULL | ||
| cheapest_price_accessor | longtext | YES | NULL | ||
| states | json | YES | NULL | ||
| variant_listing_config | json | YES | NULL | ||
| type | varchar(32) | NO | MUL | physical |
Indexes (13)
| 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 |