Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_ELEMENTNVP
This table contains promotion element values.
Column Name Column Type Description PX_ELEMENTNVP_ID BIGINT NOT NULL Primary key of the table. PX_ELEMENT_ID BIGINT NOT NULL Foreign key to the PX_ELEMENT table. NAME VARCHAR(254) NOT NULL Name of the name-value pair (NVP). VALUE VARCHAR(254) NOT NULL Value of the name-value pair (NVP). OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001197 PX_ELEMENT_ID+NAME+VALUE Unique Index SQL100520030417010 PX_ELEMENTNVP_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3547 PX_ELEMENT_ID PX_ELEMENT PX_ELEMENT_ID Cascade _vcc_freeselect_bottom_