Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMELEMENT
Campaign elements associated with a marketing activity.
Column Name Column Type Description DMELEMENT_ID INTEGER NOT NULL The unique identifier of the campaign element. NAME VARCHAR(64) NOT NULL The name of the campaign element. DMELETEMPLATE_ID INTEGER NOT NULL The identifier of the type of this campaign element. DMACTIVITY_ID INTEGER NOT NULL The identifier of the marketing activity to which this campaign element belongs. RELATED_ID INTEGER The identifier of the Trigger campaign element which needs to be detected in order to perform the Action associated with this campaign element. This is used with the predetermined display actions in dialog activities. PRIORITY SMALLINT The priority of the campaign element. If the value is null, the priority of the campaign element is the priority of the associated marketing campaign. PARENT VARCHAR(64) The name of the parent campaign element. SEQUENCE DOUBLE The sequence of this element under its parent element. FIELD1 INTEGER Customizable field. FIELD2 BIGINT Customizable field. FIELD3 DECIMAL (20,5) Customizable field. FIELD4 VARCHAR(254) Customizable field. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001149 NAME+DMACTIVITY_ID Unique Index SQL100520030326460 DMELEMENT_ID Primary Key I0001150 DMELETEMPLATE_ID+DMACTIVITY_ID Non-Unique Index I0001151 DMACTIVITY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3529 DMACTIVITY_ID DMACTIVITY DMACTIVITY_ID Cascade F_3528 DMELETEMPLATE_ID DMELETEMPLATE DMELETEMPLATE_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3532 DMELEMENT_ID DMELEMENTNVP DMELEMENT_ID Cascade F_3595 DMELEMENT_ID DMRANKINGITEM DMELEMENT_ID Cascade F_3531 DMELEMENT_ID DMTRIGLSTN DMELEMENT_ID Cascade _vcc_freeselect_bottom_