📦 Magento_Catalog · engine innodb
catalog_product_index_price_tmp
Catalog Product Price Indexer Temp Table
Columns (10)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id | int unsigned | no | Product ID | |
| customer_group_id | int unsigned | no | 0 | Customer Group ID |
| website_id | smallint unsigned | no | Website ID | |
| tax_class_id | smallint unsigned | yes | 0 | Tax Class ID |
| price | decimal | yes | Price | |
| final_price | decimal | yes | Final Price | |
| min_price | decimal | yes | Min Price | |
| max_price | decimal | yes | Max Price | |
| tier_price | decimal | yes | Tier Price | |
| id PK | int unsigned | no | ID |
Keys & indexes
Primary key: id
Indexes
- CAT_PRD_IDX_PRICE_TMP_ENTT_ID_CSTR_GROUP_ID_WS_ID (entity_id, customer_group_id, website_id) btree