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.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031218370 CPPMN_ID+CATENTRY_ID Primary Key
I0000282 CATENTRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_274 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_275 CPPMN_ID CPPMN CPPMN_ID Cascade

Feedback