📦 Magento_Catalog · engine innodb
catalog_category_product_index_replica
Catalog Category Product Index
Columns (6)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| category_id | int unsigned | no | 0 | Category ID |
| product_id | int unsigned | no | 0 | Product ID |
| position | int | yes | Position | |
| is_parent | smallint unsigned | no | 0 | Is Parent |
| store_id | smallint unsigned | no | 0 | Store ID |
| visibility | smallint unsigned | no | Visibility |
Keys & indexes
Primary key: category_id, product_id, store_id
Indexes
- CAT_CTGR_PRD_IDX_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY (product_id, store_id, category_id, visibility) btree
- CAT_CTGR_PRD_IDX_STORE_ID_CTGR_ID_VISIBILITY_IS_PARENT_POSITION (store_id, category_id, visibility, is_parent, position) btree