PX_RWDOPTION

This table contains reward option information associated with a promotion application that will be used at evaluation time.

Column Descriptions:

Name	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 (1000000)	The XML represents the selection of the shopper.
RWDSPEC	CLOB (1000000) NOT NULL	The XML that represents the selection specification that a shopper is allowed to choose.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PX_RWDOPTION_ID	Primary Key
I0001297	PX_PROMOTION_ID	Non-Unique Index
I0001298	ORDERS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3593	PX_PROMOTION_ID	PX_PROMOTION	PX_PROMOTION_ID	Cascade
F_3594	ORDERS_ID	ORDERS	ORDERS_ID	Cascade