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