Reference > Database > WebSphere Commerce database tables > T
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 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 SQL100520030442050 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
_vcc_freeselect_bottom_