📦 Magento_Catalog · engine innodb
catalog_product_entity
Catalog Product Table
Neighbourhood (1-hop foreign-key graph — showing 6 of 38)
flowchart LR c["catalog_product_entity"]:::center n0["catalog_product_link"] click n0 "/schema/table/catalog_product_link" c -- linked_product_id --> n0 n1["catalog_compare_item"] click n1 "/schema/table/catalog_compare_item" c -- product_id --> n1 n2["catalog_product_option"] click n2 "/schema/table/catalog_product_option" c -- product_id --> n2 n3["product_alert_price"] click n3 "/schema/table/product_alert_price" c -- product_id --> n3 n4["product_alert_stock"] click n4 "/schema/table/product_alert_stock" c -- product_id --> n4 n5["weee_tax"] click n5 "/schema/table/weee_tax" c -- entity_id --> n5 click c "/schema/table/catalog_product_entity" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (38)
catalog_category_product → product_idcatalog_compare_item → product_idcatalog_product_bundle_option → parent_idcatalog_product_bundle_price_index → entity_idcatalog_product_bundle_selection → product_idcatalog_product_entity_datetime → entity_idcatalog_product_entity_decimal → entity_idcatalog_product_entity_gallery → entity_idcatalog_product_entity_int → entity_idcatalog_product_entity_media_gallery_value → entity_idcatalog_product_entity_media_gallery_value_to_entity → entity_idcatalog_product_entity_text → entity_idcatalog_product_entity_tier_price → entity_idcatalog_product_entity_varchar → entity_idcatalog_product_frontend_action → product_idcatalog_product_index_tier_price → entity_idcatalog_product_link → linked_product_idcatalog_product_link → product_idcatalog_product_option → product_idcatalog_product_relation → child_idcatalog_product_relation → parent_idcatalog_product_super_attribute → product_idcatalog_product_super_link → product_idcatalog_product_super_link → parent_idcatalog_product_website → product_idcatalog_url_rewrite_product_category → product_idcataloginventory_stock_item → product_iddownloadable_link → product_iddownloadable_sample → product_idproduct_alert_price → product_idproduct_alert_stock → product_idreport_compared_product_index → product_idreport_viewed_product_aggregated_daily → product_idreport_viewed_product_aggregated_monthly → product_idreport_viewed_product_aggregated_yearly → product_idreport_viewed_product_index → product_idweee_tax → entity_idwishlist_item → product_id
Columns (8)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id PK | int unsigned | no | Entity ID | |
| attribute_set_id | smallint unsigned | no | 0 | Attribute Set ID |
| type_id | varchar(32) | no | simple | Type ID |
| sku | varchar(64) | no | SKU | |
| has_options | smallint | no | 0 | Has Options |
| required_options | smallint unsigned | no | 0 | Required Options |
| created_at | timestamp | no | CURRENT_TIMESTAMP | Creation Time |
| updated_at | timestamp | no | CURRENT_TIMESTAMP | Update Time |
Keys & indexes
Primary key: entity_id
Indexes
- CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID (attribute_set_id) btree
- CATALOG_PRODUCT_ENTITY_SKU (sku) btree
Referenced by (38)
- catalog_category_product .product_id → .entity_id (on delete CASCADE)
- catalog_compare_item .product_id → .entity_id (on delete CASCADE)
- catalog_product_bundle_option .parent_id → .entity_id (on delete CASCADE)
- catalog_product_bundle_price_index .entity_id → .entity_id (on delete CASCADE)
- catalog_product_bundle_selection .product_id → .entity_id (on delete CASCADE)
- catalog_product_entity_datetime .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_decimal .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_gallery .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_int .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_media_gallery_value .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_media_gallery_value_to_entity .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_text .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_tier_price .entity_id → .entity_id (on delete CASCADE)
- catalog_product_entity_varchar .entity_id → .entity_id (on delete CASCADE)
- catalog_product_frontend_action .product_id → .entity_id (on delete CASCADE)
- catalog_product_index_tier_price .entity_id → .entity_id (on delete CASCADE)
- catalog_product_link .linked_product_id → .entity_id (on delete CASCADE)
- catalog_product_link .product_id → .entity_id (on delete CASCADE)
- catalog_product_option .product_id → .entity_id (on delete CASCADE)
- catalog_product_relation .child_id → .entity_id (on delete CASCADE)
- catalog_product_relation .parent_id → .entity_id (on delete CASCADE)
- catalog_product_super_attribute .product_id → .entity_id (on delete CASCADE)
- catalog_product_super_link .product_id → .entity_id (on delete CASCADE)
- catalog_product_super_link .parent_id → .entity_id (on delete CASCADE)
- catalog_product_website .product_id → .entity_id (on delete CASCADE)
- catalog_url_rewrite_product_category .product_id → .entity_id (on delete CASCADE)
- cataloginventory_stock_item .product_id → .entity_id (on delete CASCADE)
- downloadable_link .product_id → .entity_id (on delete CASCADE)
- downloadable_sample .product_id → .entity_id (on delete CASCADE)
- product_alert_price .product_id → .entity_id (on delete CASCADE)
- product_alert_stock .product_id → .entity_id (on delete CASCADE)
- report_compared_product_index .product_id → .entity_id (on delete CASCADE)
- report_viewed_product_aggregated_daily .product_id → .entity_id (on delete CASCADE)
- report_viewed_product_aggregated_monthly .product_id → .entity_id (on delete CASCADE)
- report_viewed_product_aggregated_yearly .product_id → .entity_id (on delete CASCADE)
- report_viewed_product_index .product_id → .entity_id (on delete CASCADE)
- weee_tax .entity_id → .entity_id (on delete CASCADE)
- wishlist_item .product_id → .entity_id (on delete CASCADE)