Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_ELEMENT
This table contains promotion element information.
Column Name Column Type Description PX_ELEMENT_ID BIGINT NOT NULL Primary key of the table. PX_PROMOTION_ID INTEGER NOT NULL Primary key of the table. NAME VARCHAR(254) NOT NULL Name to identify the element. TYPE VARCHAR(254) NOT NULL Type of the element. SUBTYPE VARCHAR(254) Subtype of the element. PARENT VARCHAR(254) Parent name of the element. SEQUENCE DOUBLE NOT NULL DEFAULT 0 Sequence number. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001201 PX_PROMOTION_ID+NAME Unique Index SQL100520030416860 PX_ELEMENT_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3546 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3547 PX_ELEMENT_ID PX_ELEMENTNVP PX_ELEMENT_ID Cascade _vcc_freeselect_bottom_