Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CPPMNPROD
This table contains the purchase conditions for a promotion. If the purchase condition type in CPPMN table was "P", then this table is used to determine which items are required before this Coupon may be redeemed. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Name Column Type Description CPPMN_ID INTEGER NOT NULL Foreign key to the CPPMN table. This is a primary key. CATENTRY_ID BIGINT NOT NULL Foreign key to the CATENTRY table. This is the product ID. This is a primary key. QTYMEASURE CHAR(16) NOT NULL Specifies the quantity measure for the item. QUANTITY DOUBLE NOT NULL This is the quantity of the item that must be bought to satisfy the condition. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030321620 CPPMN_ID+CATENTRY_ID Primary Key I0000282 CATENTRY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_274 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_275 CPPMN_ID CPPMN CPPMN_ID Cascade
Related reference
_vcc_freeselect_bottom_