📦 Magento_CatalogRule · engine innodb
catalogrule_product_price
CatalogRule Product Price
Columns (8)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| rule_product_price_id PK | int unsigned | no | Rule Product PriceId | |
| rule_date | date | no | Rule Date | |
| customer_group_id | int | yes | ||
| product_id | int unsigned | no | 0 | Product ID |
| rule_price | decimal | no | 0 | Rule Price |
| website_id | smallint unsigned | no | Website ID | |
| latest_start_date | date | yes | Latest StartDate | |
| earliest_end_date | date | yes | Earliest EndDate |
Keys & indexes
Primary key: rule_product_price_id
Unique
- CATRULE_PRD_PRICE_RULE_DATE_WS_ID_CSTR_GROUP_ID_PRD_ID (rule_date, website_id, customer_group_id, product_id)
Indexes
- CATALOGRULE_PRODUCT_PRICE_CUSTOMER_GROUP_ID (customer_group_id) btree
- CATALOGRULE_PRODUCT_PRICE_WEBSITE_ID (website_id) btree
- CATALOGRULE_PRODUCT_PRICE_PRODUCT_ID (product_id) btree