Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_RWDOPTION
This table contains reward option information associated with a promotion application that will be used at evaluation time.
Column Name Column Type Description PX_RWDOPTION_ID BIGINT NOT NULL Primary Key of the table PX_PROMOTION_ID INTEGER NOT NULL Foreign key to PX_PROMOTION table indicates the promotion that results the reward option. ORDERS_ID BIGINT NOT NULL Foreign key to ORDERS table indicates the order that contains this reward option. RWDCHOICE CLOB The xml represents the selection of the shopper. RWDSPEC CLOB NOT NULL The xml represents the selection specification that a shopper is allowed to chose. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type SQL100520030418660 PX_RWDOPTION_ID Primary Key I0001297 PX_PROMOTION_ID Non-Unique Index I0001298 ORDERS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3594 ORDERS_ID ORDERS ORDERS_ID Cascade F_3593 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade _vcc_freeselect_bottom_