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

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
Related reference