🌐 Magento_Store · engine innodb
store
Stores
Neighbourhood (1-hop foreign-key graph — showing 6 of 91)
flowchart LR c["store"]:::center n0["store_group"] click n0 "/schema/table/store_group" n0 -- group_id --> c n1["store_website"] click n1 "/schema/table/store_website" n1 -- website_id --> c n2["customer_entity"] click n2 "/schema/table/customer_entity" c -- store_id --> n2 n3["sales_order"] click n3 "/schema/table/sales_order" c -- store_id --> n3 n4["eav_entity"] click n4 "/schema/table/eav_entity" c -- store_id --> n4 n5["quote_item"] click n5 "/schema/table/quote_item" c -- store_id --> n5 click c "/schema/table/store" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (91)
group_id → store_groupwebsite_id → store_websitecatalog_category_entity_datetime → store_idcatalog_category_entity_decimal → store_idcatalog_category_entity_int → store_idcatalog_category_entity_text → store_idcatalog_category_entity_varchar → store_idcatalog_compare_item → store_idcatalog_product_entity_datetime → store_idcatalog_product_entity_decimal → store_idcatalog_product_entity_gallery → store_idcatalog_product_entity_int → store_idcatalog_product_entity_media_gallery_value → store_idcatalog_product_entity_media_gallery_value_video → store_idcatalog_product_entity_text → store_idcatalog_product_entity_varchar → store_idcatalog_product_option_price → store_idcatalog_product_option_title → store_idcatalog_product_option_type_price → store_idcatalog_product_option_type_title → store_idcatalog_product_super_attribute_label → store_idcheckout_agreement_store → store_idcms_block_store → store_idcms_page_store → store_idcustomer_entity → store_iddesign_change → store_iddownloadable_link_title → store_iddownloadable_sample_title → store_ideav_attribute_label → store_ideav_attribute_option_swatch → store_ideav_attribute_option_value → store_ideav_entity → store_ideav_entity_datetime → store_ideav_entity_decimal → store_ideav_entity_int → store_ideav_entity_store → store_ideav_entity_text → store_ideav_entity_varchar → store_ideav_form_fieldset_label → store_ideav_form_type → store_idgoogleoptimizer_code → store_idlayout_link → store_idnewsletter_queue_store_link → store_idnewsletter_subscriber → store_idpaypal_billing_agreement → store_idproduct_alert_price → store_idproduct_alert_stock → store_idquote → store_idquote_item → store_idrating_option_vote_aggregated → store_idrating_store → store_idrating_title → store_idreport_compared_product_index → store_idreport_event → store_idreport_viewed_product_aggregated_daily → store_idreport_viewed_product_aggregated_monthly → store_idreport_viewed_product_aggregated_yearly → store_idreport_viewed_product_index → store_idreview_detail → store_idreview_entity_summary → store_idreview_store → store_idsales_bestsellers_aggregated_daily → store_idsales_bestsellers_aggregated_monthly → store_idsales_bestsellers_aggregated_yearly → store_idsales_creditmemo → store_idsales_invoice → store_idsales_invoiced_aggregated → store_idsales_invoiced_aggregated_order → store_idsales_order → store_idsales_order_aggregated_created → store_idsales_order_aggregated_updated → store_idsales_order_item → store_idsales_order_status_label → store_idsales_refunded_aggregated → store_idsales_refunded_aggregated_order → store_idsales_shipment → store_idsales_shipping_aggregated → store_idsales_shipping_aggregated_order → store_idsalesrule_coupon_aggregated → store_idsalesrule_coupon_aggregated_order → store_idsalesrule_coupon_aggregated_updated → store_idsalesrule_label → store_idsearch_query → store_idsearch_synonyms → store_idsitemap → store_idtax_calculation_rate_title → store_idtax_order_aggregated_created → store_idtax_order_aggregated_updated → store_idtranslation → store_idvariable_value → store_idwishlist_item → store_id
Columns (7)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| store_id PK | smallint unsigned | no | Store ID | |
| code | varchar(32) | yes | Code | |
| website_id | smallint unsigned | no | 0 | Website ID |
| group_id | smallint unsigned | no | 0 | Group ID |
| name | varchar(255) | no | Store Name | |
| sort_order | smallint unsigned | no | 0 | Store Sort Order |
| is_active | smallint unsigned | no | 0 | Store Activity |
Keys & indexes
Primary key: store_id
Unique
- STORE_CODE (code)
Indexes
- STORE_WEBSITE_ID (website_id) btree
- STORE_IS_ACTIVE_SORT_ORDER (is_active, sort_order) btree
- STORE_GROUP_ID (group_id) btree
References (2)
- group_id → store_group .group_id (on delete CASCADE)
- website_id → store_website .website_id (on delete CASCADE)
Referenced by (89)
- catalog_category_entity_datetime .store_id → .store_id (on delete CASCADE)
- catalog_category_entity_decimal .store_id → .store_id (on delete CASCADE)
- catalog_category_entity_int .store_id → .store_id (on delete CASCADE)
- catalog_category_entity_text .store_id → .store_id (on delete CASCADE)
- catalog_category_entity_varchar .store_id → .store_id (on delete CASCADE)
- catalog_compare_item .store_id → .store_id (on delete SET NULL)
- catalog_product_entity_datetime .store_id → .store_id (on delete CASCADE)
- catalog_product_entity_decimal .store_id → .store_id (on delete CASCADE)
- catalog_product_entity_gallery .store_id → .store_id (on delete CASCADE)
- catalog_product_entity_int .store_id → .store_id (on delete CASCADE)
- catalog_product_entity_media_gallery_value .store_id → .store_id (on delete CASCADE)
- catalog_product_entity_media_gallery_value_video .store_id → .store_id (on delete CASCADE)
- catalog_product_entity_text .store_id → .store_id (on delete CASCADE)
- catalog_product_entity_varchar .store_id → .store_id (on delete CASCADE)
- catalog_product_option_price .store_id → .store_id (on delete CASCADE)
- catalog_product_option_title .store_id → .store_id (on delete CASCADE)
- catalog_product_option_type_price .store_id → .store_id (on delete CASCADE)
- catalog_product_option_type_title .store_id → .store_id (on delete CASCADE)
- catalog_product_super_attribute_label .store_id → .store_id (on delete CASCADE)
- checkout_agreement_store .store_id → .store_id (on delete CASCADE)
- cms_block_store .store_id → .store_id (on delete CASCADE)
- cms_page_store .store_id → .store_id (on delete CASCADE)
- customer_entity .store_id → .store_id (on delete SET NULL)
- design_change .store_id → .store_id (on delete CASCADE)
- downloadable_link_title .store_id → .store_id (on delete CASCADE)
- downloadable_sample_title .store_id → .store_id (on delete CASCADE)
- eav_attribute_label .store_id → .store_id (on delete CASCADE)
- eav_attribute_option_swatch .store_id → .store_id (on delete CASCADE)
- eav_attribute_option_value .store_id → .store_id (on delete CASCADE)
- eav_entity .store_id → .store_id (on delete CASCADE)
- eav_entity_datetime .store_id → .store_id (on delete CASCADE)
- eav_entity_decimal .store_id → .store_id (on delete CASCADE)
- eav_entity_int .store_id → .store_id (on delete CASCADE)
- eav_entity_store .store_id → .store_id (on delete CASCADE)
- eav_entity_text .store_id → .store_id (on delete CASCADE)
- eav_entity_varchar .store_id → .store_id (on delete CASCADE)
- eav_form_fieldset_label .store_id → .store_id (on delete CASCADE)
- eav_form_type .store_id → .store_id (on delete CASCADE)
- googleoptimizer_code .store_id → .store_id (on delete CASCADE)
- layout_link .store_id → .store_id (on delete CASCADE)
- newsletter_queue_store_link .store_id → .store_id (on delete CASCADE)
- newsletter_subscriber .store_id → .store_id (on delete SET NULL)
- paypal_billing_agreement .store_id → .store_id (on delete SET NULL)
- product_alert_price .store_id → .store_id (on delete CASCADE)
- product_alert_stock .store_id → .store_id (on delete CASCADE)
- quote .store_id → .store_id (on delete CASCADE)
- quote_item .store_id → .store_id (on delete SET NULL)
- rating_option_vote_aggregated .store_id → .store_id (on delete CASCADE)
- rating_store .store_id → .store_id (on delete CASCADE)
- rating_title .store_id → .store_id (on delete CASCADE)
- report_compared_product_index .store_id → .store_id (on delete SET NULL)
- report_event .store_id → .store_id (on delete CASCADE)
- report_viewed_product_aggregated_daily .store_id → .store_id (on delete CASCADE)
- report_viewed_product_aggregated_monthly .store_id → .store_id (on delete CASCADE)
- report_viewed_product_aggregated_yearly .store_id → .store_id (on delete CASCADE)
- report_viewed_product_index .store_id → .store_id (on delete SET NULL)
- review_detail .store_id → .store_id (on delete SET NULL)
- review_entity_summary .store_id → .store_id (on delete CASCADE)
- review_store .store_id → .store_id (on delete CASCADE)
- sales_bestsellers_aggregated_daily .store_id → .store_id (on delete CASCADE)
- sales_bestsellers_aggregated_monthly .store_id → .store_id (on delete CASCADE)
- sales_bestsellers_aggregated_yearly .store_id → .store_id (on delete CASCADE)
- sales_creditmemo .store_id → .store_id (on delete SET NULL)
- sales_invoice .store_id → .store_id (on delete SET NULL)
- sales_invoiced_aggregated .store_id → .store_id (on delete SET NULL)
- sales_invoiced_aggregated_order .store_id → .store_id (on delete SET NULL)
- sales_order .store_id → .store_id (on delete SET NULL)
- sales_order_aggregated_created .store_id → .store_id (on delete SET NULL)
- sales_order_aggregated_updated .store_id → .store_id (on delete SET NULL)
- sales_order_item .store_id → .store_id (on delete SET NULL)
- sales_order_status_label .store_id → .store_id (on delete CASCADE)
- sales_refunded_aggregated .store_id → .store_id (on delete SET NULL)
- sales_refunded_aggregated_order .store_id → .store_id (on delete SET NULL)
- sales_shipment .store_id → .store_id (on delete SET NULL)
- sales_shipping_aggregated .store_id → .store_id (on delete SET NULL)
- sales_shipping_aggregated_order .store_id → .store_id (on delete SET NULL)
- salesrule_coupon_aggregated .store_id → .store_id (on delete CASCADE)
- salesrule_coupon_aggregated_order .store_id → .store_id (on delete CASCADE)
- salesrule_coupon_aggregated_updated .store_id → .store_id (on delete CASCADE)
- salesrule_label .store_id → .store_id (on delete CASCADE)
- search_query .store_id → .store_id (on delete CASCADE)
- search_synonyms .store_id → .store_id (on delete CASCADE)
- sitemap .store_id → .store_id (on delete CASCADE)
- tax_calculation_rate_title .store_id → .store_id (on delete CASCADE)
- tax_order_aggregated_created .store_id → .store_id (on delete CASCADE)
- tax_order_aggregated_updated .store_id → .store_id (on delete CASCADE)
- translation .store_id → .store_id (on delete CASCADE)
- variable_value .store_id → .store_id (on delete CASCADE)
- wishlist_item .store_id → .store_id (on delete SET NULL)