Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMELETEMPLATE
Template definitions of trigger, target, and action campaign elements. A trigger is used to wait for a customer to do something, or to wait for a certain period of time to elapse. When a trigger occurs, the activity flow can continue from where the trigger was defined in the flow. A target is used to qualify customers for subsequent actions or continue execution of the activity flow. Targets are usually based on a customer's behavior and segmentation. An action is a step to perform as part of the activity flow. Actions are the "to do" based on the previous sequence of triggers and targets. Most actions are for marketing purposes, such as display content in an e-marketing spot, or send the customer an e-mail.
Column Name Column Type Description DMELETEMPLATE_ID INTEGER NOT NULL The unique identifier of a campaign element template. DMELEMENTTYPE_ID INTEGER NOT NULL The type of the campaign element template. NAME VARCHAR(64) NOT NULL The name of the campaign element template. STOREENT_ID INTEGER The store associated with the campaign element template. If this is null, the template is associated with all stores. DESCRIPTION VARCHAR(254) The description of the campaign element template. DISPLAYXML CLOB This column is currently not used. IMPLXML CLOB The template XML definition of the runtime implementation of the campaign element template. BEHAVIORXML CLOB The template XML definition of the filter to detect the customer's online behavior for sending Triggers, and recording behavior for Targets. RELATEDXML CLOB The template XML definition of Trigger to detect in order to perform the Action associated with this campaign 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 I0001147 DMELEMENTTYPE_ID+NAME+STOREENT_ID Unique Index SQL100520030327040 DMELETEMPLATE_ID Primary Key I0001148 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3527 DMELEMENTTYPE_ID DMELEMENTTYPE DMELEMENTTYPE_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3528 DMELETEMPLATE_ID DMELEMENT DMELETEMPLATE_ID Cascade _vcc_freeselect_bottom_