🌐 Magento_Store · engine innodb
store_website
Websites
Neighbourhood (1-hop foreign-key graph — showing 6 of 20)
flowchart LR c["store_website"]:::center n0["store"] click n0 "/schema/table/store" c -- website_id --> n0 n1["customer_entity"] click n1 "/schema/table/customer_entity" c -- website_id --> n1 n2["product_alert_price"] click n2 "/schema/table/product_alert_price" c -- website_id --> n2 n3["product_alert_stock"] click n3 "/schema/table/product_alert_stock" c -- website_id --> n3 n4["salesrule_product_attribute"] click n4 "/schema/table/salesrule_product_attribute" c -- website_id --> n4 n5["weee_tax"] click n5 "/schema/table/weee_tax" c -- website_id --> n5 click c "/schema/table/store_website" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (20)
catalog_product_bundle_price_index → website_idcatalog_product_bundle_selection_price → website_idcatalog_product_entity_tier_price → website_idcatalog_product_index_tier_price → website_idcatalog_product_index_website → website_idcatalog_product_website → website_idcatalogrule_website → website_idcustomer_eav_attribute_website → website_idcustomer_entity → website_iddownloadable_link_price → website_idpaypal_cert → website_idpersistent_session → website_idproduct_alert_price → website_idproduct_alert_stock → website_idsalesrule_product_attribute → website_idsalesrule_website → website_idsearch_synonyms → website_idstore → website_idstore_group → website_idweee_tax → website_id
Columns (6)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| website_id PK | smallint unsigned | no | Website ID | |
| code | varchar(32) | yes | Code | |
| name | varchar(64) | yes | Website Name | |
| sort_order | smallint unsigned | no | 0 | Sort Order |
| default_group_id | smallint unsigned | no | 0 | Default Group ID |
| is_default | smallint unsigned | yes | 0 | Defines Is Website Default |
Keys & indexes
Primary key: website_id
Unique
- STORE_WEBSITE_CODE (code)
Indexes
- STORE_WEBSITE_SORT_ORDER (sort_order) btree
- STORE_WEBSITE_DEFAULT_GROUP_ID (default_group_id) btree
Referenced by (20)
- catalog_product_bundle_price_index .website_id → .website_id (on delete CASCADE)
- catalog_product_bundle_selection_price .website_id → .website_id (on delete CASCADE)
- catalog_product_entity_tier_price .website_id → .website_id (on delete CASCADE)
- catalog_product_index_tier_price .website_id → .website_id (on delete CASCADE)
- catalog_product_index_website .website_id → .website_id (on delete CASCADE)
- catalog_product_website .website_id → .website_id (on delete CASCADE)
- catalogrule_website .website_id → .website_id (on delete CASCADE)
- customer_eav_attribute_website .website_id → .website_id (on delete CASCADE)
- customer_entity .website_id → .website_id (on delete SET NULL)
- downloadable_link_price .website_id → .website_id (on delete CASCADE)
- paypal_cert .website_id → .website_id (on delete CASCADE)
- persistent_session .website_id → .website_id (on delete CASCADE)
- product_alert_price .website_id → .website_id (on delete CASCADE)
- product_alert_stock .website_id → .website_id (on delete CASCADE)
- salesrule_product_attribute .website_id → .website_id (on delete CASCADE)
- salesrule_website .website_id → .website_id (on delete CASCADE)
- search_synonyms .website_id → .website_id (on delete CASCADE)
- store .website_id → .website_id (on delete CASCADE)
- store_group .website_id → .website_id (on delete CASCADE)
- weee_tax .website_id → .website_id (on delete CASCADE)