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 Descriptions
| 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 |
| SQL060903235148070
| 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