📦 Magento_Catalog · engine innodb
catalog_category_product_index_tmp
Catalog Category Product Indexer temporary table
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 | no | 0 | 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_TMP_PRD_ID_CTGR_ID_STORE_ID (product_id, category_id, store_id) btree