Magento

Tables (361)

admin_assert

  • assert_id — int(10) — Primary key — NOT NULL — Assert ID
  • assert_type — varchar(20) — Assert Type
  • assert_data — text — Assert Data

admin_role

  • role_id — int(10) — Primary key — NOT NULL — Role ID
  • parent_id — int(10) — NOT NULL — Parent Role ID
  • tree_level — smallint(5) — NOT NULL — Role Tree Level
  • sort_order — smallint(5) — NOT NULL — Role Sort Order
  • role_type — varchar(1) — NOT NULL — Role Type
  • user_id — int(10) — NOT NULL — User ID
  • role_name — varchar(50) — Role Name

admin_rule

  • rule_id — int(10) — Primary key — NOT NULL — Rule ID
  • role_id — int(10) — Foreign key → admin_role.role_id — NOT NULL — Role ID
  • resource_id — varchar(255) — Resource ID
  • privileges — varchar(20) — Privileges
  • assert_id — int(10) — NOT NULL — Assert ID
  • role_type — varchar(1) — Role Type
  • permission — varchar(10) — Permission

admin_user

  • user_id — int(10) — Primary key — NOT NULL — User ID
  • firstname — varchar(32) — User First Name
  • lastname — varchar(32) — User Last Name
  • email — varchar(128) — User Email
  • username — varchar(40) — User Login
  • password — varchar(100) — User Password
  • created — timestamp — NOT NULL — User Created Time
  • modified — timestamp — User Modified Time
  • logdate — timestamp — User Last Login Time
  • lognum — smallint(5) — NOT NULL — User Login Number
  • reload_acl_flag — smallint(6) — NOT NULL — Reload ACL
  • is_active — smallint(6) — NOT NULL — User Is Active
  • extra — text — User Extra Data
  • rp_token — text — Reset Password Link Token
  • rp_token_created_at — timestamp — Reset Password Link Token Creation Date

adminnotification_inbox

  • notification_id — int(10) — Primary key — NOT NULL — Notification id
  • severity — smallint(5) — NOT NULL — Problem type
  • date_added — timestamp — NOT NULL — Create date
  • title — varchar(255) — NOT NULL — Title
  • description — text — Description
  • url — varchar(255) — Url
  • is_read — smallint(5) — NOT NULL — Flag if notification read
  • is_remove — smallint(5) — NOT NULL — Flag if notification might be removed

api2_acl_attribute

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • user_type — varchar(20) — NOT NULL — Type of user
  • resource_id — varchar(255) — NOT NULL — Resource ID
  • operation — varchar(20) — NOT NULL — Operation
  • allowed_attributes — text — Allowed attributes

api2_acl_role

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — Updated At
  • role_name — varchar(255) — NOT NULL — Name of role

api2_acl_rule

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • role_id — int(10) — Foreign key → api2_acl_role.entity_id — NOT NULL — Role ID
  • resource_id — varchar(255) — NOT NULL — Resource ID
  • privilege — varchar(20) — ACL Privilege

api2_acl_user

  • admin_id — int(10) — Foreign key → admin_user.user_id — NOT NULL — Admin ID
  • role_id — int(10) — Foreign key → api2_acl_role.entity_id — NOT NULL — Role ID

api_assert

  • assert_id — int(10) — Primary key — NOT NULL — Assert id
  • assert_type — varchar(20) — Assert type
  • assert_data — text — Assert additional data

api_role

  • role_id — int(10) — Primary key — NOT NULL — Role id
  • parent_id — int(10) — NOT NULL — Parent role id
  • tree_level — smallint(5) — NOT NULL — Role level in tree
  • sort_order — smallint(5) — NOT NULL — Sort order to display on admin area
  • role_type — varchar(1) — NOT NULL — Role type
  • user_id — int(10) — NOT NULL — User id
  • role_name — varchar(50) — Role name

api_rule

  • rule_id — int(10) — Primary key — NOT NULL — Api rule Id
  • role_id — int(10) — Foreign key → api_role.role_id — NOT NULL — Api role Id
  • resource_id — varchar(255) — Module code
  • api_privileges — varchar(20) — Privileges
  • assert_id — int(10) — NOT NULL — Assert id
  • role_type — varchar(1) — Role type
  • api_permission — varchar(10) — Permission

api_session

  • user_id — int(10) — Foreign key → api_user.user_id — NOT NULL — User id
  • logdate — timestamp — NOT NULL — Login date
  • sessid — varchar(40) — Sessioin id

api_user

  • user_id — int(10) — Primary key — NOT NULL — User id
  • firstname — varchar(32) — First name
  • lastname — varchar(32) — Last name
  • email — varchar(128) — Email
  • username — varchar(40) — Nickname
  • api_key — varchar(100) — Api key
  • created — timestamp — NOT NULL — User record create date
  • modified — timestamp — User record modify date
  • lognum — smallint(5) — NOT NULL — Quantity of log ins
  • reload_acl_flag — smallint(6) — NOT NULL — Refresh ACL flag
  • is_active — smallint(6) — NOT NULL — Account status

auguria_sliders

  • slider_id — int(11) — Primary key — NOT NULL
  • name — varchar(255)
  • image — varchar(255)
  • link — varchar(255)
  • cms_content — varchar(255)
  • sort_order — int(11)
  • is_active — tinyint(1)

auguria_sliders_categories

  • slider_id — int(11) — Primary key — NOT NULL
  • category_id — int(10) — Primary key — NOT NULL

auguria_sliders_pages

  • slider_id — int(11) — Primary key — NOT NULL
  • page_id — smallint(6) — Primary key — NOT NULL

auguria_sliders_stores

  • slider_id — int(11) — Primary key — NOT NULL
  • store_id — smallint(5) — Primary key — NOT NULL

captcha_log

  • type — varchar(32) — Primary key — NOT NULL — Type
  • value — varchar(32) — Primary key — NOT NULL — Value
  • count — int(10) — NOT NULL — Count
  • updated_at — timestamp — Update Time

catalog_category_anc_categs_index_idx

  • category_id — int(10) — NOT NULL — Category ID
  • path — varchar(255) — Path

catalog_category_anc_categs_index_tmp

  • category_id — int(10) — NOT NULL — Category ID
  • path — varchar(255) — Path

catalog_category_anc_products_index_idx

  • category_id — int(10) — NOT NULL — Category ID
  • product_id — int(10) — NOT NULL — Product ID
  • position — int(10) — Position

catalog_category_anc_products_index_tmp

  • category_id — int(10) — NOT NULL — Category ID
  • product_id — int(10) — NOT NULL — Product ID
  • position — int(10) — Position

catalog_category_entity

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_set_id — smallint(5) — NOT NULL — Attriute Set ID
  • parent_id — int(10) — NOT NULL — Parent Category ID
  • created_at — timestamp — Creation Time
  • updated_at — timestamp — 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
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store ID
  • entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
  • value — varchar(255) — Value

catalog_category_flat_store_1

  • entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — entity_id
  • parent_id — int(10) — NOT NULL — parent_id
  • created_at — timestamp — created_at
  • updated_at — timestamp — updated_at
  • path — varchar(255) — NOT NULL — path
  • position — int(11) — NOT NULL — position
  • level — int(11) — NOT NULL — level
  • children_count — int(11) — NOT NULL — children_count
  • store_id — smallint(5) — Foreign key — NOT NULL — Store Id
  • all_children — text — All Children
  • available_sort_by — text — Available Product Listing Sort By
  • children — text — Children
  • custom_apply_to_products — int(11) — Apply To Products
  • custom_design — varchar(255) — Custom Design
  • custom_design_from — datetime — Active From
  • custom_design_to — datetime — Active To
  • custom_layout_update — text — Custom Layout Update
  • custom_use_parent_settings — int(11) — Use Parent Category Settings
  • default_sort_by — varchar(255) — Default Product Listing Sort By
  • description — text — Description
  • display_mode — varchar(255) — Display Mode
  • filter_price_range — decimal(12, 4) — Layered Navigation Price Step
  • image — varchar(255) — Image
  • include_in_menu — int(11) — Include in Navigation Menu
  • is_active — int(11) — Is Active
  • is_anchor — int(11) — Is Anchor
  • landing_page — int(11) — CMS Block
  • meta_description — text — Meta Description
  • meta_keywords — text — Meta Keywords
  • meta_title — varchar(255) — Page Title
  • name — varchar(255) — Name
  • page_layout — varchar(255) — Page Layout
  • path_in_store — text — Path In Store
  • thumbnail — varchar(255) — Thumbnail Image
  • url_key — varchar(255) — URL Key
  • url_path — varchar(255) — Url Path

catalog_category_product

  • 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

  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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) — Position
  • is_parent — smallint(5) — NOT NULL — Is Parent
  • visibility — smallint(5) — NOT NULL — Visibility

catalog_category_product_index_enbl_idx

  • product_id — int(10) — NOT NULL — Product ID
  • visibility — int(10) — NOT NULL — Visibility

catalog_category_product_index_enbl_tmp

  • product_id — int(10) — NOT NULL — Product ID
  • visibility — int(10) — NOT NULL — Visibility

catalog_category_product_index_idx

  • category_id — int(10) — NOT NULL — Category ID
  • product_id — int(10) — NOT NULL — Product ID
  • position — int(11) — NOT NULL — Position
  • is_parent — smallint(5) — NOT NULL — Is Parent
  • store_id — smallint(5) — NOT NULL — Store ID
  • visibility — smallint(5) — NOT NULL — Visibility

catalog_category_product_index_tmp

  • category_id — int(10) — NOT NULL — Category ID
  • product_id — int(10) — NOT NULL — Product ID
  • position — int(11) — NOT NULL — Position
  • is_parent — smallint(5) — NOT NULL — Is Parent
  • store_id — smallint(5) — NOT NULL — Store ID
  • visibility — smallint(5) — NOT NULL — Visibility

catalog_compare_item

  • catalog_compare_item_id — int(10) — Primary key — NOT NULL — Compare Item ID
  • visitor_id — int(10) — NOT NULL — Visitor ID
  • customer_id — int(10) — Foreign key — Customer ID
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product 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
  • is_configurable — smallint(5) — NOT NULL — Is Configurable
  • 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

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 — smallint(5) — 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
  • parent_product_id — int(10) — NOT NULL — Parent Product Id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — 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_enabled_index

  • store_id — smallint(5) — Foreign key — NOT NULL — Store ID
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
  • visibility — smallint(5) — NOT NULL — Visibility

catalog_product_entity

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • entity_type_id — smallint(5) — Foreign key — NOT NULL — Entity Type 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 — Creation Time
  • updated_at — timestamp — Update Time

catalog_product_entity_datetime

  • value_id — int(11) — Primary key — NOT NULL — Value ID
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_type_id — smallint(5) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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_group_price

  • value_id — int(11) — Primary key — NOT NULL — Value ID
  • entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
  • all_groups — smallint(5) — NOT NULL — Is Applicable To All Customer Groups
  • customer_group_id — smallint(5) — Foreign key — NOT NULL — Customer Group ID
  • value — decimal(12, 4) — NOT NULL — Value
  • website_id — smallint(5) — Foreign key — NOT NULL — Website ID

catalog_product_entity_int

  • value_id — int(11) — Primary key — NOT NULL — Value ID
  • entity_type_id — int(10) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
  • value — varchar(255) — Value

catalog_product_entity_media_gallery_value

  • 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_text

  • value_id — int(11) — Primary key — NOT NULL — Value ID
  • entity_type_id — int(10) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store 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
  • entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
  • all_groups — smallint(5) — NOT NULL — Is Applicable To All Customer Groups
  • customer_group_id — smallint(5) — Foreign key — NOT NULL — Customer Group ID
  • qty — decimal(12, 4) — NOT NULL — QTY
  • value — decimal(12, 4) — NOT NULL — Value
  • website_id — smallint(5) — Foreign key — NOT NULL — Website ID

catalog_product_entity_varchar

  • value_id — int(11) — Primary key — NOT NULL — Value ID
  • entity_type_id — int(10) — NOT NULL — Entity Type ID
  • attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
  • store_id — smallint(5) — Foreign key — NOT NULL — Store ID
  • entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity ID
  • value — varchar(255) — Value

catalog_product_flat_1

  • entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — entity_id
  • attribute_set_id — smallint(5) — NOT NULL — attribute_set_id
  • type_id — varchar(32) — NOT NULL — type_id
  • cost — decimal(12, 4) — cost
  • created_at — timestamp — created_at
  • gift_message_available — smallint(6) — gift_message_available
  • has_options — smallint(6) — NOT NULL — has_options
  • image_label — varchar(255) — image_label
  • is_recurring — smallint(6) — is_recurring
  • links_exist — int(11) — links_exist
  • links_purchased_separately — int(11) — links_purchased_separately
  • links_title — varchar(255) — links_title
  • msrp — decimal(12, 4) — msrp
  • msrp_display_actual_price_type — varchar(255) — msrp_display_actual_price_type
  • msrp_enabled — smallint(6) — msrp_enabled
  • name — varchar(255) — name
  • news_from_date — datetime — news_from_date
  • news_to_date — datetime — news_to_date
  • price — decimal(12, 4) — price
  • price_type — int(11) — price_type
  • price_view — int(11) — price_view
  • recurring_profile — text — recurring_profile
  • required_options — smallint(5) — NOT NULL — required_options
  • shipment_type — int(11) — shipment_type
  • short_description — text — short_description
  • sku — varchar(64) — sku
  • sku_type — int(11) — sku_type
  • small_image — varchar(255) — small_image
  • small_image_label — varchar(255) — small_image_label
  • special_from_date — datetime — special_from_date
  • special_price — decimal(12, 4) — special_price
  • special_to_date — datetime — special_to_date
  • tax_class_id — int(10) — tax_class_id
  • thumbnail — varchar(255) — thumbnail
  • thumbnail_label — varchar(255) — thumbnail_label
  • updated_at — timestamp — updated_at
  • url_key — varchar(255) — url_key
  • url_path — varchar(255) — url_path
  • visibility — smallint(5) — visibility
  • weight — decimal(12, 4) — weight
  • weight_type — int(11) — weight_type

catalog_product_index_eav

  • value — int(10) — Primary key — NOT NULL — Value
  • 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

catalog_product_index_eav_decimal

  • 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
  • store_id — smallint(5) — Foreign key — NOT NULL — Store ID
  • value — decimal(12, 4) — NOT NULL — 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

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) — NOT NULL — 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

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

catalog_product_index_group_price

  • customer_group_id — smallint(5) — 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
  • price — decimal(12, 4) — Min Price

catalog_product_index_price

  • customer_group_id — smallint(5) — 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
  • group_price — decimal(12, 4) — Group price

catalog_product_index_price_bundle_idx

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group Id
  • 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
  • group_price — decimal(12, 4) — Group price
  • base_group_price — decimal(12, 4) — Base Group Price
  • group_price_percent — decimal(12, 4) — Group Price Percent

catalog_product_index_price_bundle_opt_idx

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group Id
  • 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
  • group_price — decimal(12, 4) — Group price
  • alt_group_price — decimal(12, 4) — Alt Group Price

catalog_product_index_price_bundle_opt_tmp

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group Id
  • 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
  • group_price — decimal(12, 4) — Group price
  • alt_group_price — decimal(12, 4) — Alt Group Price

catalog_product_index_price_bundle_sel_idx

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group Id
  • 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
  • group_price — decimal(12, 4) — Group price

catalog_product_index_price_bundle_sel_tmp

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group Id
  • 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
  • group_price — decimal(12, 4) — Group price

catalog_product_index_price_bundle_tmp

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group Id
  • 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
  • group_price — decimal(12, 4) — Group price
  • base_group_price — decimal(12, 4) — Base Group Price
  • group_price_percent — decimal(12, 4) — Group Price Percent

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 — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • website_id — smallint(5) — Primary key — NOT NULL — Website ID
  • price — decimal(12, 4) — Price
  • tier_price — decimal(12, 4) — Tier Price
  • group_price — decimal(12, 4) — Group 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 — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • website_id — smallint(5) — Primary key — NOT NULL — Website ID
  • price — decimal(12, 4) — Price
  • tier_price — decimal(12, 4) — Tier Price
  • group_price — decimal(12, 4) — Group price

catalog_product_index_price_cfg_opt_idx

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • 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
  • group_price — decimal(12, 4) — Group price

catalog_product_index_price_cfg_opt_tmp

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • 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
  • group_price — decimal(12, 4) — Group price

catalog_product_index_price_downlod_idx

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • 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 — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • 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 — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • 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
  • group_price — decimal(12, 4) — Group price
  • base_group_price — decimal(12, 4) — Base Group Price

catalog_product_index_price_final_tmp

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • 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
  • group_price — decimal(12, 4) — Group price
  • base_group_price — decimal(12, 4) — Base Group Price

catalog_product_index_price_idx

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • customer_group_id — smallint(5) — Primary key — NOT NULL — Customer Group ID
  • 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
  • group_price — decimal(12, 4) — Group price

and 281 more tables