📦 Magento_Catalog · engine innodb
catalog_product_index_price_replica
Catalog Product Price Index Table
Columns (9)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id | int unsigned | no | Entity ID | |
| customer_group_id | int unsigned | no | 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_CUSTOMER_GROUP_ID (customer_group_id) btree
- CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE (min_price) btree
- CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE (website_id, customer_group_id, min_price) btree