Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORCPMAP
This table stores information about the electronic coupons that were applied to the given (completed) Order.
Column Name Column Type Description ORDERS_ID BIGINT NOT NULL Foreign key to the ORDERS table. This is a primary key. CPWALLET_ID BIGINT NOT NULL Foreign key to the CPWALLET table. This is a primary key. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030359450 ORDERS_ID+CPWALLET_ID Primary Key I0000285 CPWALLET_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_484 CPWALLET_ID CPWALLET CPWALLET_ID Cascade F_485 ORDERS_ID ORDERS ORDERS_ID Cascade
Related reference
_vcc_freeselect_bottom_