WebSphere Commerce database table: TORCPMAP
This table stores information about the coupons that are applicable on the current shopping cart while the decision support system is running.
Column Descriptions Column Name Column Type Description ORDERS_ID BIGINT NOT NULL Foreign key to ORDERS table. This is a primary key. CPWALLET_ID BIGINT NOT NULL Foreign key to CPWALLET table. This is the coupon ID. This is a primary key. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL060903235302800 ORDERS_ID+CPWALLET_ID Primary Key I0000286 CPWALLET_ID Non-Unique Index Related reference
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_862 CPWALLET_ID CPWALLET CPWALLET_ID Cascade F_863 ORDERS_ID ORDERS ORDERS_ID Cascade