Tables


SchemaSpy Analysis of costway_com

Generated on Wed Mar 08 00:39 UTC 2023

XML Representation
Insertion Order Deletion Order
TABLES 494
VIEWS 0
COLUMNS 4563
Constraints 493
Anomalies 67
Routines 0

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