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