📦 Magento_Catalog · engine innodb
catalog_product_index_eav_decimal
Catalog Product EAV Decimal Index Table
Columns (5)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id | int unsigned | no | Entity ID | |
| attribute_id | smallint unsigned | no | Attribute ID | |
| store_id | smallint unsigned | no | Store ID | |
| value | decimal | no | Value | |
| source_id | int unsigned | no | 0 | Original entity ID for attribute value |
Keys & indexes
Primary key: entity_id, attribute_id, store_id, value, source_id
Indexes
- CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ATTRIBUTE_ID (attribute_id) btree
- CATALOG_PRODUCT_INDEX_EAV_DECIMAL_STORE_ID (store_id) btree
- CATALOG_PRODUCT_INDEX_EAV_DECIMAL_VALUE (value) btree