Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_PROMOAUDIT
This table contains obsolete promotion information for auditing purpose.
Column Name Column Type Description PX_PROMOTION_ID INTEGER NOT NULL Foreign key to PX_PROMOTION table VERSION INTEGER NOT NULL The version of this promotion. REVISION INTEGER NOT NULL The reversion of this promotion XMLPARAM CLOB NOT NULL The promotion rule xml OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type SQL100520030417820 PX_PROMOTION_ID+VERSION+REVISION Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3545 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade _vcc_freeselect_bottom_