PX_RWDOPTION

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

Column Descriptions:

NameTypeDescription
PX_RWDOPTION_IDBIGINT NOT NULLPrimary Key of the table
PX_PROMOTION_IDINTEGER NOT NULLForeign key to PX_PROMOTION table indicates the promotion that results the reward option.
ORDERS_IDBIGINT NOT NULLForeign key to ORDERS table indicates the order that contains this reward option.
RWDCHOICECLOB (1000000)The xml represents the selection of the shopper.
RWDSPECCLOB (1000000) NOT NULLThe xml that represents the selection specification that a shopper is allowed to choose.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PX_RWDOPTION_IDPrimary Key
I0001297PX_PROMOTION_IDNon-Unique Index
I0001298ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3593PX_PROMOTION_IDPX_PROMOTIONPX_PROMOTION_IDCascade
F_3594ORDERS_IDORDERSORDERS_IDCascade