Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_PROMOCD
This table contains promotion and promotion code relation information.
Column Name Column Type Description PX_PROMOCD_ID BIGINT NOT NULL Primary key of the table. PX_PROMOTION_ID INTEGER NOT NULL Foreign key to the PX_PROMOTION table. CODE VARCHAR(128) The promotion code for this promotion. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001165 PX_PROMOTION_ID+CODE Unique Index SQL100520030418330 PX_PROMOCD_ID Primary Key I0001166 CODE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3538 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade _vcc_freeselect_bottom_