Fields (68)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | binary(16) | NO | PRI | NULL | |
| version_id | binary(16) | NO | PRI | NULL | |
| auto_increment | int(11) | NO | UNI | NULL | auto_increment |
| product_number | varchar(64) | YES | MUL | NULL | |
| active | tinyint(1) unsigned | NO | 1 | ||
| 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 | ||
| unit_id | binary(16) | YES | MUL | NULL | |
| product_feature_set_id | binary(16) | YES | MUL | NULL | |
| category_tree | longtext | YES | NULL | ||
| option_ids | longtext | YES | NULL | ||
| property_ids | longtext | 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 | NULL | ||
| translations | binary(16) | YES | NULL | ||
| price | longtext | YES | NULL | ||
| listing_prices | longtext | YES | NULL | ||
| manufacturer_number | varchar(255) | YES | NULL | ||
| ean | varchar(255) | YES | NULL | ||
| stock | int(11) | NO | NULL | ||
| available_stock | int(11) | YES | NULL | ||
| available | tinyint(1) | NO | 1 | ||
| restock_time | int(11) | YES | NULL | ||
| is_closeout | tinyint(1) | YES | NULL | ||
| purchase_steps | int(11) unsigned | YES | NULL | ||
| max_purchase | int(11) unsigned | YES | NULL | ||
| min_purchase | int(11) 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_price | double | YES | NULL | ||
| purchase_prices | longtext | YES | NULL | ||
| mark_as_topseller | tinyint(1) unsigned | YES | NULL | ||
| weight | decimal(10,3) 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 | ||
| whitelist_ids | longtext | YES | NULL | ||
| blacklist_ids | longtext | YES | NULL | ||
| tag_ids | longtext | YES | NULL | ||
| tags | binary(16) | YES | NULL | ||
| variant_restrictions | longtext | YES | NULL | ||
| configurator_group_config | longtext | YES | NULL | ||
| main_variant_id | binary(16) | YES | MUL | 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(11) | 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 |
Indexes (10)
| Name | Columns | Unique |
|---|---|---|
| auto_increment | auto_increment | Yes |
| fk.product.feature_set_id | product_feature_set_id | No |
| fk.product.main_variant_id | main_variant_id | No |
| fk.product.parent_id | parent_id,parent_version_id | No |
| fk.product.product_manufacturer_id | 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 |
| PRIMARY | id,version_id | Yes |
| uniq.product.product_number__version_id | product_number,version_id | Yes |