Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMELEMENTNVP
Name value pairs associated with a campaign element.
Column Name Column Type Description DMELEMENT_ID INTEGER NOT NULL The identifier of the campaign element. NAME VARCHAR(254) NOT NULL The name of the name-value pair. VALUE VARCHAR(254) NOT NULL The value of the name-value pair. TRIGGERMATCH SMALLINT NOT NULL DEFAULT 0 A flag that specifies if this parameter is required to match for the occurrence of a Trigger. PROPERTIES VARCHAR(254) The properties associated with this name-value pair. SEQUENCE DOUBLE Reserved for IBM internal use. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030326600 DMELEMENT_ID+NAME+VALUE Primary Key I0001194 NAME+VALUE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3532 DMELEMENT_ID DMELEMENT DMELEMENT_ID Cascade _vcc_freeselect_bottom_