WebSphere Commerce database table: CPPMNCAT

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 NameColumn TypeDescription
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 NameIndexed Column NamesIndex 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 NameColumn Name(s)Foreign Table NameForeign 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

Feedback