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