This table contains the purchase conditions for a category-level promotion. If the purchase condition type in CPPMN table was C, then this table is used to find out all the items that are required for this coupon to be redeemed. There can be more than one category condition for a given promotion. All the purchase conditions for a coupon are combined using the AND operator.
Column Name | Column Type | Column Description |
---|---|---|
CATALOG_ID | BIGINT NOT NULL |
This is the catalog ID. Foreign key to the CATALOG table. |
CATGROUP_ID | BIGINT NOT NULL |
Primary key. This is category ID. Foreign key to the CATGROUP table. |
CPPMN_ID | INTEGER NOT NULL |
Primary key. This is the promotion ID. Foreign key to the CPPMN table. |
MAXQTY | DOUBLE NULL |
This is the maximum quantity of items in the category to be bought to satisfy the condition. |
MAXVALUE | DECIMAL (20,5) NULL |
This is the maximum order value of items in the category to be bought to satisfy the condition. |
MINQTY | DOUBLE NULL |
This is the minimum quantity of items in the category to be bought to satisfy the condition. |
MINVALUE | DECIMAL (20,5) NULL |
This is the minimum order value of items in the category to be bought to satisfy the condition. |
QTYMEASURE | CHARACTER (16) NOT NULL |
Specifies the quantity measure for the item. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000287 | CATALOG_ID, CATGROUP_ID | Non-Unique Index |
SQL030416034916250 | CPPMN_ID, CATALOG_ID, CATGROUP_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_976 | CPPMN_ID | CPPMN | CPPMN_ID | Cascade |
F_977 | CATGROUP_ID | CATGROUP | CATGROUP_ID | Cascade |
F_978 | CATALOG_ID | CATALOG | CATALOG_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|