Database Properties
Database Type: MySQL - 5.7.38-log
Tables
Table / View | Children | Parents | Columns | Rows | Type | Comments |
---|---|---|---|---|---|---|
paypal_settlement_report | 1 | 0 | 5 | 0 | Table | Paypal Settlement Report Table |
wishlist_item_option | 0 | 1 | 5 | 265630 | Table | Wishlist Item Option Table |
product_alert_stock | 0 | 3 | 8 | 0 | Table | Product Alert Stock |
sendmail_subscribe_product | 0 | 0 | 11 | 15325 | Table | |
riskified_full_declination_sent | 0 | 1 | 2 | 7628 | Table | riskified_full_declination_sent |
rating_option_vote | 0 | 3 | 10 | 791073 | Table | Rating option values |
log_summary_type | 0 | 0 | 4 | 0 | Table | Log Summary Types Table |
faq_helpful | 0 | 0 | 6 | 233 | Table | |
catalog_product_index_price_downlod_idx | 0 | 0 | 5 | 0 | Table | Indexer Table for price of downloadable products |
core_cache_tag | 0 | 0 | 2 | 0 | Table | Tag Caches |
catalogrule_website | 0 | 2 | 2 | 0 | Table | Catalog Rules To Websites Relations |
tax_class | 9 | 0 | 4 | 17 | Table | Tax Class |
magenotification_extension_feedbackmessage | 0 | 0 | 9 | 0 | Table | |
permission_variable | 0 | 0 | 3 | 15 | Table | System variables that can be processed via content filter |
catalog_product_index_eav_decimal_idx | 0 | 0 | 4 | 0 | Table | Catalog Product EAV Decimal Indexer Index Table |
catalog_product_index_price_cfg_opt_agr_idx | 0 | 0 | 7 | 0 | Table | Catalog Product Price Indexer Config Option Aggregate Index |
m_feedexport_rule_product | 0 | 3 | 4 | 247744 | Table | |
catalog_category_entity_text | 0 | 3 | 6 | 6286 | Table | Catalog Category Text Attribute Backend Table |
cataloginventory_stock_status | 0 | 3 | 5 | 12325 | Table | Cataloginventory Stock Status |
core_email_template | 0 | 0 | 12 | 27 | Table | Email Templates |
poll_vote | 0 | 1 | 6 | 0 | Table | Poll Vote |
admin_role | 1 | 0 | 7 | 126 | Table | Admin Role Table |
report_viewed_product_aggregated_daily | 0 | 2 | 8 | 0 | Table | Most Viewed Products Aggregated Daily |
permission_block | 0 | 0 | 3 | 2 | Table | System blocks that can be processed via content filter |
api_rule | 0 | 1 | 7 | 579 | Table | Api ACL Rules |
riskified_full_declination_authorizenet | 0 | 0 | 4 | 3605 | Table | riskified_full_declination_authorizenet |
sales_invoiced_aggregated | 0 | 1 | 9 | 11493 | Table | Sales Invoiced Aggregated |
core_url_rewrite | 0 | 3 | 10 | 361812 | Table | Url Rewrites |
enterprise_logging_event | 1 | 1 | 12 | 347798 | Table | Enterprise Logging Event |
xmlconnect_config_data | 0 | 1 | 4 | 0 | Table | Xmlconnect Configuration Data |
sales_order_aggregated_created | 0 | 1 | 20 | 14951 | Table | Sales Order Aggregated Created |
salesrule_customer_coupon | 0 | 0 | 6 | 649857 | Table | |
catalog_category_product_index_tmp | 0 | 1 | 6 | 0 | Table | Catalog Category Product Indexer Temp Table |
catalog_product_bundle_option_value | 0 | 2 | 4 | 0 | Table | Catalog Product Bundle Option Value |
xmlconnect_notification_template | 1 | 1 | 8 | 0 | Table | Xmlconnect Notification Template |
core_cache_option | 19 | 0 | 2 | 13 | Table | Cache Options |
catalogsearch_query | 1 | 1 | 11 | 113340 | Table | Catalog search query table |
plumrocket_sociallogin_account | 0 | 1 | 4 | 40770 | Table | Social Login Customer |
sales_flat_order | 17 | 3 | 140 | 1064948 | Table | Sales Flat Order |
rpc_banner | 0 | 0 | 7 | 10 | Table | |
catalog_category_entity_int | 0 | 3 | 6 | 7388 | Table | Catalog Category Integer Attribute Backend Table |
dataflow_profile_history | 0 | 1 | 5 | 7 | Table | Dataflow Profile History |
sales_flat_order_1203 | 0 | 3 | 140 | 1071319 | Table | Sales Flat Order |
aw_share_product | 0 | 0 | 4 | 5134 | Table | |
cataloginventory_stock_status_tmp | 0 | 0 | 5 | 0 | Table | Cataloginventory Stock Status Indexer Tmp |
core_resource | 5 | 0 | 3 | 98 | Table | Resources |
product_visit_list | 0 | 0 | 16 | 0 | Table | |
catalog_product_entity_varchar | 0 | 3 | 6 | 614498 | Table | Catalog Product Varchar Attribute Backend Table |
catalogrule_product | 0 | 4 | 13 | 0 | Table | CatalogRule Product |
eav_entity_text | 0 | 3 | 6 | 0 | Table | Eav Entity Value Prefix |
customer_address_entity_int | 0 | 3 | 5 | 583440 | Table | Customer Address Entity Int |
downloadable_link_purchased_item | 0 | 2 | 16 | 0 | Table | Downloadable Link Purchased Item Table |
core_session | 2 | 0 | 3 | 0 | Table | Database Sessions Storage |
directory_currency_rate | 0 | 0 | 3 | 4 | Table | Directory Currency Rate |
review_store | 0 | 2 | 2 | 528988 | Table | Review Store |
catalog_category_entity | 10 | 1 | 10 | 1234 | Table | Catalog Category Table |
eav_form_fieldset_label | 0 | 2 | 3 | 2 | Table | Eav Form Fieldset Label |
sales_flat_order_payment | 1 | 1 | 56 | 1139302 | Table | Sales Flat Order Payment |
core_layout_link | 0 | 2 | 6 | 0 | Table | Layout Link |
catalog_product_enabled_index | 0 | 2 | 3 | 0 | Table | Catalog Product Visibility Index Table |
catalog_product_link_attribute_varchar | 0 | 2 | 4 | 0 | Table | Catalog Product Link Varchar Attribute Table |
sales_flat_quote_address_1203 | 0 | 1 | 62 | 19269 | Table | Sales Flat Quote Address |
admin_assert | 0 | 0 | 3 | 0 | Table | Admin Assert Table |
catalog_product_option_type_title | 0 | 2 | 4 | 0 | Table | Catalog Product Option Type Title Table |
sales_order_tax_item | 0 | 2 | 4 | 45344 | Table | Sales Order Tax Item |
catalog_product_link_attribute_int | 0 | 2 | 4 | 16 | Table | Catalog Product Link Integer Attribute Table |
rpc_quote_equipment | 0 | 0 | 3 | 15363 | Table | |
dataflow_session | 1 | 0 | 7 | 0 | Table | Dataflow Session |
catalog_product_entity_tier_price | 0 | 3 | 7 | 33 | Table | Catalog Product Tier Price Attribute Backend Table |
report_viewed_product_index | 0 | 3 | 6 | 41919441 | Table | Reports Viewed Product Index Table |
aw_afp_blocks | 1 | 0 | 10 | 400 | Table | All AFP blocks are stored in this table |
aw_points_sign | 0 | 0 | 4 | 530101 | Table | |
rule_restrictions | 0 | 0 | 4 | 2 | Table | rule_restrictions |
catalog_category_anc_products_index_tmp | 0 | 0 | 3 | 0 | Table | Catalog Category Anchor Product Indexer Temp Table |
bannerslider_report | 0 | 0 | 6 | 20279 | Table | |
customer_entity_decimal | 0 | 3 | 5 | 0 | Table | Customer Entity Decimal |
wishlist_item | 1 | 3 | 7 | 187812 | Table | Wishlist items |
customer_address_entity_decimal | 0 | 3 | 5 | 0 | Table | Customer Address Entity Decimal |
core_translate | 0 | 1 | 6 | 0 | Table | Translations |
catalog_product_index_eav_idx | 0 | 0 | 4 | 28392 | Table | Catalog Product EAV Indexer Index Table |
review_entity | 1 | 1 | 2 | 3 | Table | Review entities |
catalog_product_index_price_opt_idx | 0 | 0 | 7 | 0 | Table | Catalog Product Price Indexer Option Index Table |
tax_calculation_rate | 2 | 1 | 9 | 2 | Table | Tax Calculation Rate |
catalog_category_entity_copy1 | 0 | 1 | 10 | 1234 | Table | Catalog Category Table |
eav_entity_int | 0 | 3 | 6 | 0 | Table | Eav Entity Value Prefix |
hooya_blacklist_record | 0 | 0 | 12 | 421 | Table | |
product_visit_config | 0 | 0 | 7 | 0 | Table | |
sales_order_status_label | 0 | 2 | 3 | 0 | Table | Sales Order Status Label Table |
hooya_trending_cover | 0 | 0 | 7 | 8 | Table | |
core_cache | 0 | 0 | 5 | 0 | Table | Caches |
customer_register_ip | 0 | 0 | 4 | 883895 | Table | |
catalog_product_index_eav_decimal | 0 | 3 | 4 | 0 | Table | Catalog Product EAV Decimal Index Table |
hooya_notes | 0 | 0 | 15 | 19 | Table | |
review | 3 | 2 | 7 | 260043 | Table | Review base information |
aw_points_transaction_orderspend | 0 | 0 | 5 | 62712 | Table | |
catalog_category_anc_categs_index_tmp | 0 | 0 | 2 | 0 | Table | Catalog Category Anchor Indexer Temp Table |
index_process_event | 0 | 2 | 3 | 345 | Table | Index Process Event |
catalog_product_index_price_bundle_idx | 0 | 1 | 16 | 0 | Table | Catalog Product Index Price Bundle Idx |
m_feedexport_feed_history | 0 | 1 | 7 | 1129 | Table | |
salesrule | 6 | 0 | 34 | 7065 | Table | Salesrule |
catalog_product_super_attribute_pricing | 0 | 2 | 6 | 3568 | Table | Catalog Product Super Attribute Pricing Table |
salesrule_customer | 0 | 2 | 4 | 223694 | Table | Salesrule Customer |
sales_shipping_aggregated | 0 | 1 | 8 | 12585 | Table | Sales Shipping Aggregated |
aw_afp_productimages | 0 | 1 | 4 | 833 | Table | Product Images Storage |
catalog_product_index_price_cfg_opt_idx | 0 | 0 | 7 | 0 | Table | Catalog Product Price Indexer Config Option Index Table |
review_status | 1 | 1 | 2 | 3 | Table | Review statuses |
log_quote | 0 | 0 | 4 | 7 | Table | Log Quotes Table |
manageteam | 0 | 0 | 10 | 0 | Table | |
xmlconnect_images | 0 | 1 | 5 | 0 | Table | Xmlconnect Images |
api_user | 1 | 0 | 11 | 5 | Table | Api Users |
catalog_product_index_price_bundle_opt_idx | 0 | 0 | 11 | 0 | Table | Catalog Product Index Price Bundle Opt Idx |
tax_calculation_rate_title | 0 | 2 | 4 | 0 | Table | Tax Calculation Rate Title |
catalog_category_entity_decimal | 0 | 3 | 6 | 1230 | Table | Catalog Category Decimal Attribute Backend Table |
product_city_sku | 0 | 0 | 9 | 3 | Table | 特殊SKU与城市地区关系表 |
catalog_product_index_tier_price | 0 | 3 | 4 | 786 | Table | Catalog Product Tier Price Index Table |
hooya_vote_activity | 0 | 0 | 9 | 2 | Table | |
m_feedexport_rule_feed | 0 | 2 | 3 | 60 | Table | |
m_feedexport_rule | 2 | 0 | 8 | 60 | Table | |
catalog_product_option_price | 0 | 2 | 5 | 0 | Table | Catalog Product Option Price Table |
dataflow_profile | 2 | 1 | 10 | 6 | Table | Dataflow Profile |
salesrule_coupon | 1 | 1 | 11 | 1805523 | Table | Salesrule Coupon |
activity_emails | 0 | 0 | 7 | 83 | Table | 场景活动邮件用户记录 |
catalog_product_index_price_idx | 0 | 1 | 10 | 329143 | Table | Catalog Product Price Indexer Index Table |
sales_flat_shipment | 4 | 2 | 15 | 973375 | Table | Sales Flat Shipment |
newsletter_problem | 0 | 2 | 5 | 1439 | Table | Newsletter Problems |
hooya_shop_by_room | 0 | 0 | 17 | 8 | Table | |
customer_support_record | 0 | 0 | 4 | 1194 | Table | |
catalog_eav_attribute | 0 | 1 | 19 | 148 | Table | Catalog EAV Attribute Table |
cms_block | 1 | 0 | 7 | 42 | Table | CMS Block Table |
catalog_product_super_attribute_label | 0 | 2 | 5 | 4950 | Table | Catalog Product Super Attribute Label Table |
rating_title | 0 | 2 | 3 | 0 | Table | Rating Title |
catalog_product_index_price_bundle_sel_tmp | 0 | 0 | 10 | 0 | Table | Catalog Product Index Price Bundle Sel Tmp |
xmlconnect_application | 4 | 2 | 10 | 0 | Table | Xmlconnect Application |
review_entity_summary | 0 | 1 | 6 | 20188 | Table | Review aggregates |
customer_entity_varchar | 0 | 3 | 5 | 3280465 | Table | Customer Entity Varchar |
twilio_sms | 0 | 0 | 8 | 1153 | Table | |
customer_address_entity_text | 0 | 3 | 5 | 582476 | Table | Customer Address Entity Text |
catalog_product_index_price_opt_agr_idx | 0 | 0 | 8 | 0 | Table | Catalog Product Price Indexer Option Aggregate Index Table |
catalog_product_bundle_option | 2 | 1 | 5 | 0 | Table | Catalog Product Bundle Option |
sales_flat_order_cancel_order | 0 | 0 | 26 | 20897 | Table | |
customer_address_entity_varchar | 0 | 3 | 5 | 4836903 | Table | Customer Address Entity Varchar |
op_avatax_queue | 0 | 1 | 12 | 3392 | Table | Used by One Pica AvaTax extension |
sales_flat_creditmemo_comment | 0 | 1 | 6 | 22560 | Table | Sales Flat Creditmemo Comment |
sales_flat_order_grid | 0 | 4 | 17 | 1065735 | Table | Sales Flat Order Grid |
sales_refunded_aggregated | 0 | 1 | 8 | 3024 | Table | Sales Refunded Aggregated |
catalog_category_anc_products_index_idx | 0 | 0 | 3 | 0 | Table | Catalog Category Anchor Product Indexer Index Table |
m_feedexport_performance_order | 0 | 5 | 8 | 399817 | Table | |
oauth_nonce | 0 | 0 | 2 | 0 | Table | oauth_nonce |
aw_core_logger | 0 | 0 | 15 | 106415 | Table | |
api2_acl_role | 2 | 0 | 4 | 2 | Table | Api2 Global ACL Roles |
hooya_tools_shipment | 0 | 0 | 17 | 2 | Table | |
wishlist | 1 | 2 | 5 | 521082 | Table | Wishlist main Table |
catalog_product_index_price_cfg_opt_tmp | 0 | 0 | 7 | 0 | Table | Catalog Product Price Indexer Config Option Temp Table |
sales_flat_quote_item_option | 0 | 1 | 5 | 115291 | Table | Sales Flat Quote Item Option |
core_flag | 0 | 0 | 5 | 13 | Table | Flag |
catalog_product_index_eav | 0 | 3 | 4 | 25751 | Table | Catalog Product EAV Index Table |
hooya_hotkeyword_list | 0 | 0 | 6 | 23 | Table | |
catalog_product_bundle_price_index | 0 | 3 | 5 | 0 | Table | Catalog Product Bundle Price Index |
tax_order_aggregated_created | 0 | 1 | 8 | 247826 | Table | Tax Order Aggregation |
rating_entity | 1 | 0 | 2 | 3 | Table | Rating entities |
hooya_wallofjoy | 0 | 0 | 4 | 54 | Table | |
customer_register_source | 0 | 0 | 3 | 912619 | Table | |
sales_refunded_aggregated_order | 0 | 1 | 8 | 5036 | Table | Sales Refunded Aggregated Order |
cms_page_202209211517 | 0 | 0 | 18 | 397 | Table | CMS Page Table |
downloadable_link | 2 | 1 | 11 | 0 | Table | Downloadable Link Table |
salesrule_customer_sign_coupon | 0 | 0 | 7 | 812603 | Table | |
log_customer | 0 | 1 | 7 | 320242 | Table | Log Customers Table |
eav_entity_varchar | 0 | 3 | 6 | 0 | Table | Eav Entity Value Prefix |
cataloginventory_stock | 2 | 0 | 2 | 0 | Table | Cataloginventory Stock |
aw_points_summary | 1 | 0 | 10 | 946885 | Table | |
salesrule_label | 0 | 2 | 4 | 0 | Table | Salesrule Label |
salesrule_customer_group | 0 | 2 | 2 | 64534 | Table | Sales Rules To Customer Groups Relations |
bannerslider_value | 0 | 2 | 5 | 0 | Table | |
eav_attribute_group | 1 | 1 | 5 | 25 | Table | Eav Attribute Group |
core_email_template_202209211515 | 0 | 0 | 12 | 25 | Table | Email Templates |
sitejabber_review | 0 | 0 | 3 | 12635 | Table | |
weee_discount | 0 | 3 | 4 | 0 | Table | Weee Discount |
eav_entity_datetime | 0 | 3 | 6 | 0 | Table | Eav Entity Value Prefix |
sales_bestsellers_aggregated_yearly | 0 | 2 | 8 | 90774 | Table | Sales Bestsellers Aggregated Yearly |
ship_tmp_copy | 0 | 0 | 4 | 0 | Table | |
downloadable_link_purchased | 1 | 2 | 10 | 0 | Table | Downloadable Link Purchased Table |
smtppro_email_log | 0 | 0 | 6 | 639478 | Table | |
catalog_product_flat_1 | 0 | 2 | 70 | 10126 | Table | Catalog Product Flat (Store 1) |
related_category_seo | 0 | 0 | 3 | 60 | Table | |
xmlconnect_queue | 0 | 1 | 9 | 0 | Table | Xmlconnect Notification Queue |
admin_user | 3 | 0 | 15 | 112 | Table | Admin User Table |
sales_flat_order_status_history | 0 | 2 | 8 | 8928206 | Table | Sales Flat Order Status History |
shipping_tablerate | 0 | 0 | 9 | 0 | Table | Shipping Tablerate |
oracle_email_uniq_send | 0 | 0 | 5 | 117018 | Table | 场景邮件用户发送(针对场景只发一次) |
cms_page_store | 0 | 2 | 2 | 416 | Table | CMS Page To Store Linkage Table |
op_avatax_log | 0 | 1 | 14 | 46341 | Table | Used by One Pica AvaTax extension |
api_assert | 0 | 0 | 3 | 0 | Table | Api ACL Asserts |
review_image | 0 | 0 | 3 | 26452 | Table | |
sales_flat_order_item | 2 | 2 | 90 | 1497756 | Table | Sales Flat Order Item |
eav_form_fieldset | 2 | 1 | 4 | 2 | Table | Eav Form Fieldset |
api_role | 1 | 0 | 7 | 10 | Table | Api ACL Roles |
catalog_product_option_title | 0 | 2 | 4 | 0 | Table | Catalog Product Option Title Table |
catalog_product_entity_datetime | 0 | 3 | 6 | 251150 | Table | Catalog Product Datetime Attribute Backend Table |
newsletter_subscriber | 2 | 2 | 15 | 670432 | Table | Newsletter Subscriber |
gift_message | 0 | 0 | 5 | 0 | Table | Gift Message |
magenotification_license | 0 | 0 | 8 | 0 | Table | |
catalog_category_product_index | 0 | 3 | 6 | 25010 | Table | Catalog Category Product Index |
sales_flat_shipment_item | 0 | 1 | 12 | 1374702 | Table | Sales Flat Shipment Item |
aw_points_rate | 0 | 0 | 6 | 3 | Table | |
sales_flat_quote_item_option_1203 | 0 | 1 | 5 | 81363 | Table | Sales Flat Quote Item Option |
core_variable_value | 0 | 2 | 5 | 0 | Table | Variable Value |
admin_rule | 0 | 1 | 7 | 10017 | Table | Admin Rule Table |
core_config_data | 0 | 0 | 6 | 1419 | Table | Config Data |
core_variable | 1 | 0 | 3 | 0 | Table | Variables |
sales_flat_shipment_grid | 0 | 2 | 10 | 974820 | Table | Sales Flat Shipment Grid |
cataloginventory_stock_item | 0 | 2 | 25 | 22268 | Table | Cataloginventory Stock Item |
catalog_product_super_attribute | 2 | 1 | 4 | 4716 | Table | Catalog Product Super Attribute Table |
persistent_session | 0 | 2 | 6 | 0 | Table | Persistent Session |
catalog_category_product_index_enbl_idx | 0 | 0 | 2 | 0 | Table | Catalog Category Product Enabled Indexer Index Table |
hooya_marketing | 0 | 0 | 18 | 4 | Table | |
order_invitation_email | 0 | 0 | 11 | 6025 | Table | 订单完成定时发邮件表 |
sales_bestsellers_aggregated_daily | 0 | 2 | 8 | 1356648 | Table | Sales Bestsellers Aggregated Daily |
magenotification_extension_feedback | 0 | 0 | 17 | 0 | Table | |
sales_flat_order_cancel_order_history | 0 | 0 | 6 | 29238 | Table | |
customer_group | 14 | 1 | 3 | 29 | Table | Customer Group |
sales_flat_order_source | 0 | 0 | 3 | 283178 | Table | |
hooya_relcate | 0 | 0 | 8 | 703 | Table | |
riskified_full_historical_sent | 0 | 0 | 3 | 90134 | Table | riskified_full_historical_sent |
m_feedexport_performance_aggregated | 0 | 3 | 8 | 126925 | Table | |
catalog_product_pk | 0 | 0 | 15 | 0 | Table | 产品PK活动表 |
newsletter_record | 0 | 0 | 3 | 100109 | Table | |
sales_order_aggregated_updated | 0 | 1 | 20 | 19220 | Table | Sales Order Aggregated Updated |
aw_points_exchange_product | 0 | 1 | 2 | 95 | Table | Point Exchange Catalog Product Table |
dataflow_batch_import | 0 | 1 | 4 | 0 | Table | Dataflow Batch Import |
api2_acl_attribute | 0 | 0 | 5 | 0 | Table | Api2 Filter ACL Attributes |
sales_recurring_profile_order | 0 | 2 | 3 | 0 | Table | Sales Recurring Profile Order |
downloadable_link_title | 0 | 2 | 4 | 0 | Table | Link Title Table |
catalog_product_bundle_selection_price | 0 | 2 | 4 | 0 | Table | Catalog Product Bundle Selection Price |
dataflow_import_data | 0 | 1 | 5 | 0 | Table | Dataflow Import Data |
downloadable_sample_title | 0 | 2 | 4 | 0 | Table | Downloadable Sample Title Table |
customer_entity | 26 | 4 | 21 | 997777 | Table | Customer Entity |
faq_list | 0 | 0 | 12 | 31185 | Table | |
sales_flat_quote_item_12031402 | 0 | 4 | 60 | 40274 | Table | Sales Flat Quote Item |
eav_form_type_entity | 0 | 2 | 2 | 8 | Table | Eav Form Type Entity |
eav_attribute_option_value | 0 | 2 | 4 | 850 | Table | Eav Attribute Option Value |
sales_recurring_profile | 1 | 3 | 33 | 0 | Table | Sales Recurring Profile |
rpc_uuid_relation | 0 | 0 | 4 | 54641 | Table | |
aw_points_warn_email | 0 | 0 | 2 | 40715 | Table | |
catalog_product_link_type | 2 | 1 | 2 | 4 | Table | Catalog Product Link Type Table |
magenotification_log | 0 | 0 | 9 | 0 | Table | |
widget_instance | 1 | 0 | 7 | 0 | Table | Instances of Widget for Package Theme |
sales_flat_invoice_comment | 0 | 1 | 6 | 3731 | Table | Sales Flat Invoice Comment |
widget_instance_page_layout | 0 | 2 | 2 | 0 | Table | Layout updates |
m_mstcore_urlrewrite | 0 | 0 | 5 | 0 | Table | |
customer_address_entity_datetime | 0 | 3 | 5 | 0 | Table | Customer Address Entity Datetime |
coupon_aggregated_order | 0 | 2 | 10 | 0 | Table | Coupon Aggregated Order |
index_event | 1 | 0 | 7 | 62281 | Table | Index Event |
customer_entity_text | 0 | 3 | 5 | 0 | Table | Customer Entity Text |
aw_points_assignment | 0 | 0 | 4 | 112520 | Table | |
hooya_notes_records | 0 | 0 | 3 | 13335 | Table | |
catalog_product_index_website | 0 | 1 | 3 | 1 | Table | Catalog Product Website Index Table |
catalog_category_flat_store_1_copy1 | 0 | 2 | 36 | 1192 | Table | Catalog Category Flat (Store 1) |
sales_order_tax | 1 | 0 | 12 | 621133 | Table | Sales Order Tax Table |
adminnotification_inbox | 0 | 0 | 8 | 377 | Table | Adminnotification Inbox |
bannerslider_slider | 0 | 0 | 21 | 4 | Table | |
report_compared_product_index | 0 | 3 | 6 | 0 | Table | Reports Compared Product Index Table |
tax_calculation | 0 | 4 | 5 | 0 | Table | Tax Calculation |
report_viewed_product_aggregated_monthly | 0 | 2 | 8 | 0 | Table | Most Viewed Products Aggregated Monthly |
room_style | 0 | 0 | 8 | 93 | Table | |
customer_eav_attribute_website | 0 | 2 | 6 | 0 | Table | Customer Eav Attribute Website |
customer_form_attribute | 0 | 1 | 2 | 100 | Table | Customer Form Attribute |
core_store_group | 4 | 2 | 5 | 2 | Table | Store Groups |
room_block_product | 0 | 0 | 5 | 2601 | Table | |
sales_flat_quote_stock_email_record | 0 | 0 | 4 | 464 | Table | |
poll_answer | 1 | 1 | 5 | 4 | Table | Poll Answers |
sales_order_status_state | 0 | 1 | 3 | 18 | Table | Sales Order Status Table |
oauth_consumer | 1 | 0 | 8 | 0 | Table | OAuth Consumers |
eav_form_type | 3 | 1 | 6 | 5 | Table | Eav Form Type |
catalogrule | 4 | 0 | 15 | 0 | Table | CatalogRule |
catalog_product_entity | 62 | 2 | 9 | 21600 | Table | Catalog Product Table |
paypal_cert | 0 | 1 | 4 | 0 | Table | Paypal Certificate Table |
rating | 5 | 1 | 4 | 3 | Table | Ratings |
cataloginventory_stock_status_idx | 0 | 0 | 5 | 12325 | Table | Cataloginventory Stock Status Indexer Idx |
directory_country | 4 | 0 | 3 | 246 | Table | Directory Country |
customer_plus_change_record | 0 | 0 | 7 | 327 | Table | PLUS会员时间变动表 |
bannerslider_banner | 1 | 0 | 31 | 753 | Table | |
coupon_aggregated_updated | 0 | 2 | 13 | 311795 | Table | Coupon Aggregated Updated |
sales_shipping_aggregated_order | 0 | 1 | 8 | 17821 | Table | Sales Shipping Aggregated Order |
sales_flat_quote_address | 2 | 1 | 62 | 17297 | Table | Sales Flat Quote Address |
hooya_instagram | 0 | 0 | 6 | 173 | Table | |
catalogrule_affected_product | 0 | 0 | 1 | 0 | Table | CatalogRule Affected Product |
catalog_product_comparison | 0 | 0 | 10 | 5 | Table | 产品竞品信息对比表 |
paypal_settlement_report_row | 0 | 1 | 19 | 0 | Table | Paypal Settlement Report Row Table |
walmart_tmp | 0 | 0 | 5 | 3462 | Table | |
wishlist_item_stock_alert | 0 | 0 | 3 | 1267 | Table | |
room_block | 0 | 0 | 5 | 214 | Table | |
m_feedexport_feed | 6 | 1 | 39 | 68 | Table | |
aw_points_coupon_transaction | 0 | 0 | 4 | 0 | Table | |
sales_billing_agreement | 1 | 3 | 9 | 0 | Table | Sales Billing Agreement |
catalog_product_index_price_final_tmp | 0 | 1 | 12 | 0 | Table | Catalog Product Price Indexer Final Temp Table |
catalog_product_index_price_downlod_tmp | 0 | 0 | 5 | 0 | Table | Temporary Indexer Table for price of downloadable products |
directory_country_format | 0 | 1 | 4 | 0 | Table | Directory Country Format |
m_feedexport_feed_product | 0 | 2 | 4 | 307477 | Table | |
poll_store | 0 | 2 | 2 | 0 | Table | Poll Store |
api2_acl_user | 0 | 2 | 2 | 0 | Table | Api2 Global ACL Users |
eav_attribute_option | 1 | 1 | 5 | 908 | Table | Eav Attribute Option |
report_event_types | 1 | 0 | 3 | 6 | Table | Reports Event Type Table |
magenotification | 0 | 0 | 4 | 0 | Table | |
room_category | 0 | 0 | 10 | 12 | Table | |
catalog_product_index_eav_tmp | 0 | 0 | 4 | 4 | Table | Catalog Product EAV Indexer Temp Table |
catalog_category_product_index_idx | 0 | 1 | 6 | 0 | Table | Catalog Category Product Indexer Index Table |
catalog_product_link_attribute_decimal | 0 | 2 | 4 | 0 | Table | Catalog Product Link Decimal Attribute Table |
product_alert_price | 0 | 3 | 9 | 0 | Table | Product Alert Price |
catalog_product_index_price_cfg_opt_agr_tmp | 0 | 0 | 7 | 0 | Table | Catalog Product Price Indexer Config Option Aggregate Temp T |
eav_entity_type | 21 | 2 | 16 | 8 | Table | Eav Entity Type |
rpc_rule_equipment | 0 | 0 | 4 | 344 | Table | |
dataflow_batch | 2 | 2 | 6 | 0 | Table | Dataflow Batch |
catalog_product_index_price_opt_tmp | 0 | 0 | 7 | 0 | Table | Catalog Product Price Indexer Option Temp Table |
sync_emails | 0 | 0 | 10 | 68428 | Table | |
rating_option | 1 | 2 | 5 | 15 | Table | Rating options |
rating_store | 0 | 2 | 2 | 6 | Table | Rating Store |
catalog_product_pk_record | 0 | 0 | 7 | 57 | Table | 产品PK活动投票记录表 |
log_visitor | 0 | 1 | 6 | 1731 | Table | Log Visitors Table |
sales_flat_quote_shipping_rate | 0 | 1 | 12 | 12285 | Table | Sales Flat Quote Shipping Rate |
catalog_compare_item | 0 | 3 | 5 | 0 | Table | Catalog Compare Table |
newsletter_subscriber_info | 0 | 0 | 6 | 1848 | Table | |
log_url | 0 | 0 | 3 | 2710256 | Table | Log URL Table |
riskified_full_retry | 0 | 1 | 6 | 0 | Table | riskified_full_retry |
catalogrule_customer_group | 0 | 2 | 2 | 0 | Table | Catalog Rules To Customer Groups Relations |
tag_summary | 0 | 2 | 8 | 0 | Table | Tag Summary |
eav_attribute_label | 0 | 2 | 4 | 32 | Table | Eav Attribute Label |
log_visitor_online | 0 | 0 | 7 | 8 | Table | Log Visitor Online Table |
sales_flat_quote_payment | 0 | 1 | 22 | 8326 | Table | Sales Flat Quote Payment |
tag_relation | 0 | 4 | 7 | 0 | Table | Tag Relation |
zeon_landingpage_store | 0 | 2 | 2 | 21 | Table | Zeon Landing Page Store |
customer_eav_attribute | 0 | 1 | 8 | 48 | Table | Customer Eav Attribute |
sales_flat_shipment_comment | 0 | 1 | 6 | 1031535 | Table | Sales Flat Shipment Comment |
catalog_product_entity_media_gallery_value | 0 | 2 | 5 | 303202 | Table | Catalog Product Media Gallery Attribute Value Table |
ava_exemption_certificate | 0 | 1 | 26 | 70 | Table | |
catalog_product_index_price_tmp | 0 | 1 | 10 | 29 | Table | Catalog Product Price Indexer Temp Table |
aw_points_transaction | 0 | 2 | 17 | 2820057 | Table | |
hooya_trending_like | 0 | 0 | 6 | 6661 | Table | |
log_visitor_info | 0 | 0 | 7 | 0 | Table | Log Visitor Info Table |
hooya_trending | 0 | 0 | 8 | 170 | Table | |
sales_invoiced_aggregated_order | 0 | 1 | 9 | 11455 | Table | Sales Invoiced Aggregated Order |
catalogsearch_fulltext | 0 | 1 | 4 | 4390 | Table | Catalog search result table |
unallowable_sku | 0 | 0 | 4 | 0 | Table | |
tax_order_aggregated_updated | 0 | 1 | 8 | 205333 | Table | Tax Order Aggregated Updated |
catalog_category_anc_categs_index_idx | 0 | 0 | 2 | 0 | Table | Catalog Category Anchor Indexer Index Table |
enterprise_logging_event_changes | 0 | 1 | 6 | 80631 | Table | Enterprise Logging Event Changes |
sales_flat_shipment_track | 0 | 2 | 11 | 1165495 | Table | Sales Flat Shipment Track |
sales_order_status | 6 | 0 | 2 | 19 | Table | Sales Order Status Table |
overstock_tmp | 0 | 0 | 5 | 476 | Table | |
catalog_product_index_price_bundle_tmp | 0 | 1 | 16 | 21 | Table | Catalog Product Index Price Bundle Tmp |
salesrule_product_attribute | 0 | 4 | 4 | 49036 | Table | Salesrule Product Attribute |
catalog_category_entity_varchar | 0 | 3 | 6 | 9924 | Table | Catalog Category Varchar Attribute Backend Table |
front_page_faq_catalog | 0 | 0 | 4 | 23 | Table | |
widget | 0 | 0 | 4 | 0 | Table | Preconfigured Widgets |
sales_flat_order_item_1203 | 0 | 2 | 89 | 1598919 | Table | Sales Flat Order Item |
paypal_payment_transaction | 0 | 0 | 4 | 0 | Table | PayPal Payflow Link Payment Transaction |
sendfriend_log | 0 | 0 | 4 | 0 | Table | Send to friend function log storage table |
downloadable_link_price | 0 | 2 | 4 | 0 | Table | Downloadable Link Price Table |
eav_form_element | 0 | 3 | 5 | 52 | Table | Eav Form Element |
weee_tax | 0 | 4 | 8 | 0 | Table | Weee Tax |
newsletter_queue_link | 0 | 2 | 4 | 3719 | Table | Newsletter Queue Link |
catalog_treasure_hunt | 0 | 0 | 5 | 5934 | Table | 用户寻宝活动 |
m_feedexport_custom_attribute | 0 | 0 | 4 | 15 | Table | |
catalog_product_index_eav_decimal_tmp | 0 | 0 | 4 | 0 | Table | Catalog Product EAV Decimal Indexer Temp Table |
eav_entity | 5 | 3 | 9 | 0 | Table | Eav Entity |
hooya_wallofjoy_like | 0 | 0 | 6 | 565 | Table | |
catalog_product_website | 0 | 2 | 2 | 24178 | Table | Catalog Product To Website Linkage Table |
aw_points_exchange_order | 0 | 1 | 3 | 252 | Table | Point Exchange Order Table |
dataflow_batch_export | 0 | 1 | 4 | 0 | Table | Dataflow Batch Export |
api_session | 0 | 1 | 3 | 617 | Table | Api Sessions |
sales_flat_quote_address_item | 1 | 3 | 40 | 0 | Table | Sales Flat Quote Address Item |
catalog_product_fee | 0 | 0 | 3 | 16116 | Table | |
importexport_importdata | 0 | 0 | 4 | 0 | Table | Import Data Table |
hooya_vote_record | 0 | 0 | 5 | 125 | Table | |
catalog_product_relation | 0 | 2 | 2 | 11122 | Table | Catalog Product Relation Table |
sales_bestsellers_aggregated_monthly | 0 | 2 | 8 | 406825 | Table | Sales Bestsellers Aggregated Monthly |
m_feedexport_template | 0 | 0 | 6 | 50 | Table | |
newsletter_queue_store_link | 0 | 2 | 2 | 19 | Table | Newsletter Queue Store Link |
widget_instance_page | 1 | 1 | 8 | 0 | Table | Instance of Widget on Page |
captcha_log | 0 | 0 | 4 | 0 | Table | Count Login Attempts |
directory_country_region_name | 0 | 1 | 3 | 488 | Table | Directory Country Region Name |
review_detail | 0 | 3 | 9 | 260544 | Table | Review detail information |
directory_country_region | 1 | 1 | 4 | 488 | Table | Directory Country Region |
customer_subreg | 0 | 1 | 4 | 335428 | Table | |
review_helpful | 0 | 0 | 6 | 3431 | Table | |
zeon_landingpage | 1 | 0 | 13 | 21 | Table | Zeon Landing Page |
catalog_product_super_link | 0 | 2 | 3 | 11331 | Table | Catalog Product Super Link Table |
catalog_product_option_type_price | 0 | 2 | 5 | 0 | Table | Catalog Product Option Type Price Table |
front_page_faq | 0 | 0 | 7 | 83 | Table | |
catalog_product_entity_decimal | 0 | 3 | 6 | 201746 | Table | Catalog Product Decimal Attribute Backend Table |
catalog_product_option_type_value | 2 | 1 | 4 | 0 | Table | Catalog Product Option Type Value Table |
eav_entity_decimal | 0 | 3 | 6 | 0 | Table | Eav Entity Value Prefix |
plumbase_product | 0 | 0 | 4 | 2 | Table | |
sales_flat_quote | 5 | 1 | 52 | 20791 | Table | Sales Flat Quote |
log_summary | 0 | 1 | 6 | 0 | Table | Log Summary Table |
sales_flat_order_item_contract | 0 | 0 | 16 | 2490 | Table | |
aw_points_coupon | 0 | 0 | 12 | 0 | Table | |
catalog_product_index_group_price | 0 | 3 | 4 | 747 | Table | Catalog Product Group Price Index Table |
catalog_product_entity_media_gallery | 1 | 2 | 4 | 307170 | Table | Catalog Product Media Gallery Attribute Backend Table |
catalog_product_option | 3 | 1 | 10 | 0 | Table | Catalog Product Option Table |
check_order_info | 0 | 0 | 13 | 117 | Table | |
xmlconnect_history | 0 | 3 | 9 | 0 | Table | Xmlconnect History |
catalog_product_index_price_bundle_opt_tmp | 0 | 0 | 11 | 0 | Table | Catalog Product Index Price Bundle Opt Tmp |
tax_calculation_rule | 1 | 0 | 5 | 0 | Table | Tax Calculation Rule |
hooya_shop_by_sets | 0 | 0 | 20 | 4 | Table | |
check_credit_transaction | 0 | 0 | 8 | 187 | Table | |
aw_points_invitation | 0 | 1 | 10 | 0 | Table | |
core_layout_update | 2 | 0 | 4 | 0 | Table | Layout Updates |
sales_payment_transaction | 1 | 3 | 10 | 846270 | Table | Sales Payment Transaction |
catalog_product_index_price_opt_agr_tmp | 0 | 0 | 8 | 0 | Table | Catalog Product Price Indexer Option Aggregate Temp Table |
catalog_category_flat_store_1 | 0 | 2 | 40 | 1220 | Table | Catalog Category Flat (Store 1) |
catalog_product_bundle_selection | 1 | 2 | 10 | 0 | Table | Catalog Product Bundle Selection |
eav_entity_store | 0 | 2 | 5 | 4 | Table | Eav Entity Store |
salesrule_coupon_usage | 0 | 2 | 3 | 210708 | Table | Salesrule Coupon Usage |
customer_wholesale | 0 | 0 | 8 | 153434 | Table | |
catalog_product_entity_group_price | 0 | 3 | 6 | 757 | Table | Catalog Product Group Price Attribute Backend Table |
customer_serial | 0 | 0 | 9 | 126 | Table | |
sitemap | 0 | 1 | 6 | 0 | Table | Google Sitemap |
newsletter_queue | 3 | 1 | 11 | 19 | Table | Newsletter Queue |
catalog_product_link_attribute | 3 | 2 | 4 | 5 | Table | Catalog Product Link Attribute Table |
customer_entity_int | 0 | 3 | 5 | 1014640 | Table | Customer Entity Int |
design_change | 0 | 1 | 5 | 0 | Table | Design Changes |
oauth_token | 0 | 3 | 12 | 0 | Table | OAuth Tokens |
sales_flat_quote_item | 5 | 4 | 60 | 26322 | Table | Sales Flat Quote Item |
customer_plus_invite | 0 | 0 | 7 | 23 | Table | 会员升级PLUS邀请记录表 |
sales_flat_invoice_item | 0 | 1 | 33 | 1361782 | Table | Sales Flat Invoice Item |
catalog_product_index_price_bundle_sel_idx | 0 | 0 | 10 | 0 | Table | Catalog Product Index Price Bundle Sel Idx |
core_store | 127 | 3 | 7 | 2 | Table | Stores |
tag | 3 | 2 | 5 | 0 | Table | Tag |
core_config_data_copy | 0 | 0 | 6 | 1419 | Table | Config Data |
customer_business | 0 | 0 | 11 | 187 | Table | |
core_website | 29 | 2 | 6 | 2 | Table | Websites |
sales_flat_creditmemo | 3 | 2 | 48 | 23973 | Table | Sales Flat Creditmemo |
customer_plus_order | 0 | 2 | 25 | 2078 | Table | 会员升级PLUS订单表 |
customer_address_entity | 5 | 2 | 8 | 583270 | Table | Customer Address Entity |
sales_flat_invoice | 3 | 2 | 44 | 995420 | Table | Sales Flat Invoice |
sales_flat_order_address | 0 | 2 | 27 | 2067419 | Table | Sales Flat Order Address |
ship_tmp | 0 | 0 | 4 | 582 | Table | |
checkout_agreement | 1 | 0 | 7 | 0 | Table | Checkout Agreement |
coupon_aggregated | 0 | 2 | 13 | 287682 | Table | Coupon Aggregated |
poll | 2 | 1 | 9 | 0 | Table | Poll |
sales_flat_creditmemo_grid | 0 | 2 | 21 | 24303 | Table | Sales Flat Creditmemo Grid |
catalogsearch_result | 0 | 2 | 3 | 0 | Table | Catalog search result table |
catalog_product_entity_gallery | 0 | 3 | 7 | 0 | Table | Catalog Product Gallery Attribute Backend Table |
catalog_product_index_price_final_idx | 0 | 1 | 12 | 0 | Table | Catalog Product Price Indexer Final Index Table |
referral_child | 0 | 0 | 4 | 975 | Table | |
api2_acl_rule | 0 | 1 | 4 | 0 | Table | Api2 Global ACL Rules |
m_feedexport_mapping_category | 0 | 0 | 6 | 11 | Table | |
newsletter_template | 1 | 0 | 12 | 9 | Table | Newsletter Template |
customer_entity_datetime | 0 | 3 | 5 | 58926 | Table | Customer Entity Datetime |
sales_flat_quote_product_price_email_record | 0 | 0 | 4 | 64 | Table | |
sales_flat_creditmemo_item | 0 | 1 | 33 | 35483 | Table | Sales Flat Creditmemo Item |
sales_flat_invoice_grid | 0 | 2 | 15 | 995436 | Table | Sales Flat Invoice Grid |
eav_entity_attribute | 0 | 3 | 6 | 268 | Table | Eav Entity Attributes |
customer_feedback | 0 | 0 | 7 | 4232 | Table | |
catalog_product_entity_point_price | 0 | 3 | 7 | 190 | Table | Catalog Product Point Price Attribute Backend Table |
index_process | 1 | 1 | 6 | 9 | Table | Index Process |
sales_flat_resend | 0 | 0 | 11 | 4739 | Table | |
m_mstcore_logger | 0 | 0 | 8 | 0 | Table | |
customer_plus_no_gird | 0 | 0 | 2 | 0 | Table | 会员PLUS编号表 |
cron_schedule | 0 | 0 | 8 | 51 | Table | Cron Schedule |
ipsecurity_log | 0 | 0 | 7 | 31356 | Table | ip security log - count of block qty |
checkout_agreement_store | 0 | 2 | 2 | 0 | Table | Checkout Agreement Store |
walmart_tmp_new | 0 | 0 | 6 | 3427 | Table | |
catalog_product_bundle_stock_index | 0 | 0 | 5 | 0 | Table | Catalog Product Bundle Stock Index |
catalog_category_product_index_enbl_tmp | 0 | 0 | 2 | 0 | Table | Catalog Category Product Enabled Indexer Temp Table |
m_feedexport_performance_click | 0 | 4 | 6 | 12193600 | Table | |
salesrule_website | 0 | 2 | 2 | 6839 | Table | Sales Rules To Websites Relations |
report_viewed_product_aggregated_yearly | 0 | 2 | 8 | 0 | Table | Most Viewed Products Aggregated Yearly |
catalog_category_entity_datetime | 0 | 3 | 6 | 2460 | Table | Catalog Category Datetime Attribute Backend Table |
cms_page | 1 | 0 | 18 | 375 | Table | CMS Page Table |
salesrule_share_coupon | 0 | 0 | 6 | 710 | Table | |
catalog_product_entity_int | 0 | 3 | 6 | 442265 | Table | Catalog Product Integer Attribute Backend Table |
eav_attribute | 34 | 1 | 17 | 196 | Table | Eav Attribute |
aw_points_rule | 0 | 0 | 14 | 3 | Table | |
aw_share_product_log | 0 | 0 | 5 | 8468 | Table | |
catalog_product_entity_text | 0 | 3 | 6 | 154629 | Table | Catalog Product Text Attribute Backend Table |
referral_link | 0 | 0 | 5 | 30 | Table | |
rating_option_vote_aggregated | 0 | 2 | 8 | 66033 | Table | Rating vote aggregated |
catalogrule_product_price | 0 | 3 | 8 | 0 | Table | CatalogRule Product Price |
sales_billing_agreement_order | 0 | 2 | 2 | 0 | Table | Sales Billing Agreement Order |
m_mstcore_attachment | 0 | 0 | 8 | 0 | Table | |
catalog_product_link | 3 | 3 | 4 | 16 | Table | Catalog Product To Product Linkage Table |
downloadable_sample | 1 | 1 | 6 | 0 | Table | Downloadable Sample Table |
aw_points_dropship | 0 | 0 | 15 | 13772 | Table | |
eav_attribute_set | 10 | 1 | 4 | 9 | Table | Eav Attribute Set |
catalog_product_index_price | 0 | 4 | 10 | 350370 | Table | Catalog Product Price Index Table |
catalog_category_product | 0 | 2 | 3 | 33998 | Table | Catalog Product To Category Linkage Table |
report_event | 0 | 2 | 7 | 1313882 | Table | Reports Event Table |
cms_block_store | 0 | 2 | 2 | 51 | Table | CMS Block To Store Linkage Table |
catalogrule_group_website | 0 | 3 | 3 | 0 | Table | CatalogRule Group Website |
hooya_sales_deals | 0 | 0 | 10 | 4 | Table | |
hooya_shop_by_catagory | 0 | 0 | 11 | 19 | Table | |
log_url_info | 0 | 0 | 3 | 2388797 | Table | Log URL Info Table |
tag_properties | 0 | 2 | 3 | 0 | Table | Tag Properties |