Margento2-catalog
Margento2 catalog erd
Tables (100)
catalog_category_entity
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_set_id — smallint(5) — NOT NULL — Attriute Set ID
- parent_id — int(10) — NOT NULL — Parent Category ID
- created_at — timestamp — NOT NULL — Creation Time
- updated_at — timestamp — NOT NULL — Update Time
- path — varchar(255) — NOT NULL — Tree Path
- position — int(11) — NOT NULL — Position
- level — int(11) — NOT NULL — Tree Level
- children_count — int(11) — NOT NULL — Child Count
catalog_category_entity_datetime
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — datetime — Value
catalog_category_entity_decimal
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — decimal(12,4) — Value
catalog_category_entity_int
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — int(11) — Value
catalog_category_entity_text
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — text — Value
catalog_category_entity_varchar
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — varchar(255) — Value
catalog_category_product
- entity_id — int(11) — Primary key — NOT NULL — Entity ID
- category_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Category ID
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
- position — int(11) — NOT NULL — Position
catalog_category_product_index
- category_id — int(10) — Primary key — NOT NULL — Category ID
- product_id — int(10) — Primary key — NOT NULL — Product ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- position — int(11) — Position
- is_parent — smallint(5) — NOT NULL — Is Parent
- visibility — smallint(5) — NOT NULL — Visibility
catalog_category_product_index_replica
- category_id — int(10) — Primary key — NOT NULL — Category Id
- product_id — int(10) — Primary key — NOT NULL — Product Id
- store_id — smallint(5) — Primary key — NOT NULL — Store Id
- position — int(11) — Position
- is_parent — smallint(5) — NOT NULL — Is Parent
- visibility — smallint(5) — NOT NULL — Visibility
catalog_category_product_index_tmp
- category_id — int(10) — Primary key — NOT NULL — Category ID
- product_id — int(10) — Primary key — NOT NULL — Product ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- position — int(11) — NOT NULL — Position
- is_parent — smallint(5) — NOT NULL — Is Parent
- visibility — smallint(5) — NOT NULL — Visibility
catalog_compare_item
- catalog_compare_item_id — int(10) — Primary key — NOT NULL — Compare Item ID
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
- visitor_id — int(10) — NOT NULL — Visitor ID
- customer_id — int(10) — Foreign key — Customer ID
- store_id — smallint(5) — Foreign key — Store ID
catalog_eav_attribute
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- frontend_input_renderer — varchar(255) — Frontend Input Renderer
- is_global — smallint(5) — NOT NULL — Is Global
- is_visible — smallint(5) — NOT NULL — Is Visible
- is_searchable — smallint(5) — NOT NULL — Is Searchable
- is_filterable — smallint(5) — NOT NULL — Is Filterable
- is_comparable — smallint(5) — NOT NULL — Is Comparable
- is_visible_on_front — smallint(5) — NOT NULL — Is Visible On Front
- is_html_allowed_on_front — smallint(5) — NOT NULL — Is HTML Allowed On Front
- is_used_for_price_rules — smallint(5) — NOT NULL — Is Used For Price Rules
- is_filterable_in_search — smallint(5) — NOT NULL — Is Filterable In Search
- used_in_product_listing — smallint(5) — NOT NULL — Is Used In Product Listing
- used_for_sort_by — smallint(5) — NOT NULL — Is Used For Sorting
- apply_to — varchar(255) — Apply To
- is_visible_in_advanced_search — smallint(5) — NOT NULL — Is Visible In Advanced Search
- position — int(11) — NOT NULL — Position
- is_wysiwyg_enabled — smallint(5) — NOT NULL — Is WYSIWYG Enabled
- is_used_for_promo_rules — smallint(5) — NOT NULL — Is Used For Promo Rules
- is_required_in_admin_store — smallint(5) — NOT NULL — Is Required In Admin Store
- is_used_in_grid — smallint(5) — NOT NULL — Is Used in Grid
- is_visible_in_grid — smallint(5) — NOT NULL — Is Visible in Grid
- is_filterable_in_grid — smallint(5) — NOT NULL — Is Filterable in Grid
- search_weight — float — NOT NULL — Search Weight
- additional_data — text — Additional swatch attributes data
catalog_product_bundle_option
- option_id — int(10) — Primary key — NOT NULL — Option Id
- parent_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Parent Id
- required — smallint(5) — NOT NULL — Required
- position — int(10) — NOT NULL — Position
- type — varchar(255) — Type
catalog_product_bundle_option_value
- value_id — int(10) — Primary key — NOT NULL — Value Id
- option_id — int(10) — Foreign key → catalog_product_bundle_option.option_id — NOT NULL — Option Id
- store_id — smallint(5) — NOT NULL — Store Id
- title — varchar(255) — Title
catalog_product_bundle_price_index
- customer_group_id — int(10) — Foreign key — NOT NULL — Customer Group Id
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity Id
- website_id — smallint(5) — Foreign key — NOT NULL — Website Id
- min_price — decimal(12,4) — NOT NULL — Min Price
- max_price — decimal(12,4) — NOT NULL — Max Price
catalog_product_bundle_selection
- selection_id — int(10) — Primary key — NOT NULL — Selection Id
- option_id — int(10) — Foreign key → catalog_product_bundle_option.option_id — NOT NULL — Option Id
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product Id
- parent_product_id — int(10) — NOT NULL — Parent Product Id
- position — int(10) — NOT NULL — Position
- is_default — smallint(5) — NOT NULL — Is Default
- selection_price_type — smallint(5) — NOT NULL — Selection Price Type
- selection_price_value — decimal(12,4) — NOT NULL — Selection Price Value
- selection_qty — decimal(12,4) — Selection Qty
- selection_can_change_qty — smallint(6) — NOT NULL — Selection Can Change Qty
catalog_product_bundle_selection_price
- website_id — smallint(5) — Foreign key — NOT NULL — Website Id
- selection_id — int(10) — Foreign key → catalog_product_bundle_selection.selection_id — NOT NULL — Selection Id
- selection_price_type — smallint(5) — NOT NULL — Selection Price Type
- selection_price_value — decimal(12,4) — NOT NULL — Selection Price Value
catalog_product_bundle_stock_index
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- stock_id — smallint(5) — Primary key — NOT NULL — Stock Id
- option_id — int(10) — Primary key — NOT NULL — Option Id
- stock_status — smallint(6) — Stock Status
catalog_product_entity
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_set_id — smallint(5) — Foreign key — NOT NULL — Attribute Set ID
- type_id — varchar(32) — NOT NULL — Type ID
- sku — varchar(64) — SKU
- has_options — smallint(6) — NOT NULL — Has Options
- required_options — smallint(5) — NOT NULL — Required Options
- created_at — timestamp — NOT NULL — Creation Time
- updated_at — timestamp — NOT NULL — Update Time
catalog_product_entity_datetime
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- value — datetime — Value
catalog_product_entity_decimal
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- value — decimal(12,4) — Value
catalog_product_entity_gallery
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- position — int(11) — NOT NULL — Position
- value — varchar(255) — Value
catalog_product_entity_int
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- value — int(11) — Value
catalog_product_entity_media_gallery
- value_id — int(10) — Primary key — NOT NULL — Value ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- value — varchar(255) — Value
- media_type — varchar(32) — NOT NULL — Media entry type
- disabled — smallint(5) — NOT NULL — Visibility status
catalog_product_entity_media_gallery_value
- record_id — int(10) — Primary key — NOT NULL — Record Id
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- value_id — int(10) — Foreign key → catalog_product_entity_media_gallery.value_id — NOT NULL — Value ID
- label — varchar(255) — Label
- position — int(10) — Position
- disabled — smallint(5) — NOT NULL — Is Disabled
catalog_product_entity_media_gallery_value_to_entity
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product entity ID
- value_id — int(10) — Foreign key → catalog_product_entity_media_gallery.value_id — NOT NULL — Value media Entry ID
catalog_product_entity_media_gallery_value_video
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- value_id — int(10) — Foreign key → catalog_product_entity_media_gallery.value_id — NOT NULL — Media Entity ID
- provider — varchar(32) — Video provider ID
- url — text — Video URL
- title — varchar(255) — Title
- description — text — Page Meta Description
- metadata — text — Video meta data
catalog_product_entity_text
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- value — text — Value
catalog_product_entity_tier_price
- value_id — int(11) — Primary key — NOT NULL — Value ID
- customer_group_id — int(10) — Foreign key — NOT NULL — Customer Group ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- website_id — smallint(5) — Foreign key — NOT NULL — Website ID
- all_groups — smallint(5) — NOT NULL — Is Applicable To All Customer Groups
- qty — decimal(12,4) — NOT NULL — QTY
- value — decimal(12,4) — NOT NULL — Value
- percentage_value — decimal(5,2) — Percentage value
catalog_product_entity_varchar
- value_id — int(11) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- value — varchar(255) — Value
catalog_product_index_eav
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- value — int(10) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Original entity Id for attribute value
catalog_product_index_eav_decimal
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- value — decimal(12,4) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Original entity Id for attribute value
catalog_product_index_eav_decimal_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- value — decimal(12,4) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Original entity Id for attribute value
catalog_product_index_eav_decimal_replica
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute Id
- store_id — smallint(5) — Primary key — NOT NULL — Store Id
- value — decimal(12,4) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Source Id
catalog_product_index_eav_decimal_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- value — decimal(12,4) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Original entity Id for attribute value
catalog_product_index_eav_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- value — int(10) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Original entity Id for attribute value
catalog_product_index_eav_replica
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute Id
- store_id — smallint(5) — Primary key — NOT NULL — Store Id
- value — int(10) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Source Id
catalog_product_index_eav_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- value — int(10) — Primary key — NOT NULL — Value
- source_id — int(10) — Primary key — NOT NULL — Original entity Id for attribute value
catalog_product_index_price
- website_id — smallint(5) — Foreign key — NOT NULL — Website ID
- customer_group_id — int(10) — Foreign key — NOT NULL — Customer Group ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- tax_class_id — smallint(5) — Tax Class ID
- price — decimal(12,4) — Price
- final_price — decimal(12,4) — Final Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_bundle_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- tax_class_id — smallint(5) — Tax Class Id
- price_type — smallint(5) — NOT NULL — Price Type
- special_price — decimal(12,4) — Special Price
- tier_percent — decimal(12,4) — Tier Percent
- orig_price — decimal(12,4) — Orig Price
- price — decimal(12,4) — Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
- base_tier — decimal(12,4) — Base Tier
catalog_product_index_price_bundle_opt_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- option_id — int(10) — Primary key — NOT NULL — Option Id
- min_price — decimal(12,4) — Min Price
- alt_price — decimal(12,4) — Alt Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
- alt_tier_price — decimal(12,4) — Alt Tier Price
catalog_product_index_price_bundle_opt_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- option_id — int(10) — Primary key — NOT NULL — Option Id
- min_price — decimal(12,4) — Min Price
- alt_price — decimal(12,4) — Alt Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
- alt_tier_price — decimal(12,4) — Alt Tier Price
catalog_product_index_price_bundle_sel_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- option_id — int(10) — Primary key — NOT NULL — Option Id
- selection_id — int(10) — Primary key — NOT NULL — Selection Id
- group_type — smallint(5) — Group Type
- is_required — smallint(5) — Is Required
- price — decimal(12,4) — Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_bundle_sel_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- option_id — int(10) — Primary key — NOT NULL — Option Id
- selection_id — int(10) — Primary key — NOT NULL — Selection Id
- group_type — smallint(5) — Group Type
- is_required — smallint(5) — Is Required
- price — decimal(12,4) — Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_bundle_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- tax_class_id — smallint(5) — Tax Class Id
- price_type — smallint(5) — NOT NULL — Price Type
- special_price — decimal(12,4) — Special Price
- tier_percent — decimal(12,4) — Tier Percent
- orig_price — decimal(12,4) — Orig Price
- price — decimal(12,4) — Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
- base_tier — decimal(12,4) — Base Tier
catalog_product_index_price_cfg_opt_agr_idx
- parent_id — int(10) — Primary key — NOT NULL — Parent ID
- child_id — int(10) — Primary key — NOT NULL — Child ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- price — decimal(12,4) — Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_cfg_opt_agr_tmp
- parent_id — int(10) — Primary key — NOT NULL — Parent ID
- child_id — int(10) — Primary key — NOT NULL — Child ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- price — decimal(12,4) — Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_cfg_opt_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_cfg_opt_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_downlod_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- min_price — decimal(12,4) — NOT NULL — Minimum price
- max_price — decimal(12,4) — NOT NULL — Maximum price
catalog_product_index_price_downlod_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- min_price — decimal(12,4) — NOT NULL — Minimum price
- max_price — decimal(12,4) — NOT NULL — Maximum price
catalog_product_index_price_final_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- tax_class_id — smallint(5) — Tax Class ID
- orig_price — decimal(12,4) — Original Price
- price — decimal(12,4) — Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
- base_tier — decimal(12,4) — Base Tier
catalog_product_index_price_final_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- tax_class_id — smallint(5) — Tax Class ID
- orig_price — decimal(12,4) — Original Price
- price — decimal(12,4) — Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
- base_tier — decimal(12,4) — Base Tier
catalog_product_index_price_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- tax_class_id — smallint(5) — Tax Class ID
- price — decimal(12,4) — Price
- final_price — decimal(12,4) — Final Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_opt_agr_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- option_id — int(10) — Primary key — NOT NULL — Option ID
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_opt_agr_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- option_id — int(10) — Primary key — NOT NULL — Option ID
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_opt_idx
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_opt_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_replica
- customer_group_id — int(10) — Foreign key — NOT NULL — Customer Group Id
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity Id
- website_id — smallint(5) — Foreign key — NOT NULL — Website Id
- tax_class_id — smallint(5) — Tax Class Id
- price — decimal(12,4) — Price
- final_price — decimal(12,4) — Final Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_price_tmp
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- customer_group_id — int(11) — Primary key — NOT NULL
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- tax_class_id — smallint(5) — Tax Class ID
- price — decimal(12,4) — Price
- final_price — decimal(12,4) — Final Price
- min_price — decimal(12,4) — Min Price
- max_price — decimal(12,4) — Max Price
- tier_price — decimal(12,4) — Tier Price
catalog_product_index_tier_price
- customer_group_id — int(10) — Foreign key — NOT NULL — Customer Group ID
- entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
- website_id — smallint(5) — Foreign key — NOT NULL — Website ID
- min_price — decimal(12,4) — Min Price
catalog_product_index_website
- website_id — smallint(5) — Foreign key — NOT NULL — Website ID
- website_date — date — Website Date
- rate — float — Rate
catalog_product_link
- link_id — int(10) — Primary key — NOT NULL — Link ID
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
- linked_product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Linked Product ID
- link_type_id — smallint(5) — Foreign key → catalog_product_link_type.link_type_id — NOT NULL — Link Type ID
catalog_product_link_attribute
- product_link_attribute_id — smallint(5) — Primary key — NOT NULL — Product Link Attribute ID
- link_type_id — smallint(5) — Foreign key → catalog_product_link_type.link_type_id — NOT NULL — Link Type ID
- product_link_attribute_code — varchar(32) — Product Link Attribute Code
- data_type — varchar(32) — Data Type
catalog_product_link_attribute_decimal
- value_id — int(10) — Primary key — NOT NULL — Value ID
- link_id — int(10) — Foreign key → catalog_product_link.link_id — NOT NULL — Link ID
- product_link_attribute_id — smallint(5) — Foreign key → catalog_product_link_attribute.product_link_attribute_id — Product Link Attribute ID
- value — decimal(12,4) — NOT NULL — Value
catalog_product_link_attribute_int
- value_id — int(10) — Primary key — NOT NULL — Value ID
- link_id — int(10) — Foreign key → catalog_product_link.link_id — NOT NULL — Link ID
- product_link_attribute_id — smallint(5) — Foreign key → catalog_product_link_attribute.product_link_attribute_id — Product Link Attribute ID
- value — int(11) — NOT NULL — Value
catalog_product_link_attribute_varchar
- value_id — int(10) — Primary key — NOT NULL — Value ID
- link_id — int(10) — Foreign key → catalog_product_link.link_id — NOT NULL — Link ID
- product_link_attribute_id — smallint(5) — Foreign key → catalog_product_link_attribute.product_link_attribute_id — NOT NULL — Product Link Attribute ID
- value — varchar(255) — Value
catalog_product_link_type
- link_type_id — smallint(5) — Primary key — NOT NULL — Link Type ID
- code — varchar(32) — Code
catalog_product_option
- option_id — int(10) — Primary key — NOT NULL — Option ID
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
- type — varchar(50) — Type
- is_require — smallint(6) — NOT NULL — Is Required
- sku — varchar(64) — SKU
- max_characters — int(10) — Max Characters
- file_extension — varchar(50) — File Extension
- image_size_x — smallint(5) — Image Size X
- image_size_y — smallint(5) — Image Size Y
- sort_order — int(10) — NOT NULL — Sort Order
catalog_product_option_price
- option_price_id — int(10) — Primary key — NOT NULL — Option Price ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- option_id — int(10) — Foreign key → catalog_product_option.option_id — NOT NULL — Option ID
- price — decimal(12,4) — NOT NULL — Price
- price_type — varchar(7) — NOT NULL — Price Type
catalog_product_option_title
- option_title_id — int(10) — Primary key — NOT NULL — Option Title ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- option_id — int(10) — Foreign key → catalog_product_option.option_id — NOT NULL — Option ID
- title — varchar(255) — Title
catalog_product_option_type_price
- option_type_price_id — int(10) — Primary key — NOT NULL — Option Type Price ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- option_type_id — int(10) — Foreign key → catalog_product_option_type_value.option_type_id — NOT NULL — Option Type ID
- price — decimal(12,4) — NOT NULL — Price
- price_type — varchar(7) — NOT NULL — Price Type
catalog_product_option_type_title
- option_type_title_id — int(10) — Primary key — NOT NULL — Option Type Title ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- option_type_id — int(10) — Foreign key → catalog_product_option_type_value.option_type_id — NOT NULL — Option Type ID
- title — varchar(255) — Title
catalog_product_option_type_value
- option_type_id — int(10) — Primary key — NOT NULL — Option Type ID
- option_id — int(10) — Foreign key → catalog_product_option.option_id — NOT NULL — Option ID
- sku — varchar(64) — SKU
- sort_order — int(10) — NOT NULL — Sort Order
catalog_product_relation
- child_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Child ID
- parent_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Parent ID
catalog_product_super_attribute
- product_super_attribute_id — int(10) — Primary key — NOT NULL — Product Super Attribute ID
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- position — smallint(5) — NOT NULL — Position
catalog_product_super_attribute_label
- value_id — int(10) — Primary key — NOT NULL — Value ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- product_super_attribute_id — int(10) — Foreign key → catalog_product_super_attribute.product_super_attribute_id — NOT NULL — Product Super Attribute ID
- use_default — smallint(5) — Use Default Value
- value — varchar(255) — Value
catalog_product_super_link
- link_id — int(10) — Primary key — NOT NULL — Link ID
- parent_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Parent ID
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
catalog_product_website
- website_id — smallint(5) — Foreign key — NOT NULL — Website ID
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
catalog_url_rewrite_product_category
- category_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — category_id
- product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — product_id
- url_rewrite_id — int(10) — Foreign key — NOT NULL — url_rewrite_id
and 20 more tables