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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Descriptions 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.
Indexes Index Name Indexed Column Names Index Type SQL060903235147410 CPPMN_ID+CATALOG_ID+CATGROUP_ID Primary Key I0000287 CATALOG_ID+CATGROUP_ID Non-Unique Index I0000547 CATGROUP_ID Non-Unique Index Related reference
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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