📦 Magento_Catalog · engine innodb
catalog_product_index_price_idx
Catalog Product Price Indexer Index Table
Columns (9)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id | int unsigned | no | Entity 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 |
Keys & indexes
Primary key: entity_id, customer_group_id, website_id
Indexes
- CATALOG_PRODUCT_INDEX_PRICE_IDX_CUSTOMER_GROUP_ID (customer_group_id) btree
- CATALOG_PRODUCT_INDEX_PRICE_IDX_WEBSITE_ID (website_id) btree
- CATALOG_PRODUCT_INDEX_PRICE_IDX_MIN_PRICE (min_price) btree