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 Descriptions:

NameTypeDescription
DMELETEMPLATE_IDINTEGER NOT NULLThe unique identifier of a campaign element template.
DMELEMENTTYPE_IDINTEGER NOT NULLThe type of the campaign element template.
NAMEVARCHAR (64) NOT NULLThe name of the campaign element template.
STOREENT_IDINTEGERThe store associated with the campaign element template. If this is null, the template is associated with all stores.
DESCRIPTIONVARCHAR (254)The description of the campaign element template.
DISPLAYXMLCLOB (1000000)The template XML defintion of the user interface configuration associated with the campaign element template.
IMPLXMLCLOB (1000000)The template XML definition of the runtime implementation of the campaign element template.
BEHAVIORXMLCLOB (1000000)The template XML definition of the filter to detect the customer's online behavior for sending Triggers, and recording behavior for Targets.
RELATEDXMLCLOB (1000000)The template XML definition of Trigger to detect in order to perform the Action associated with this campaign element.
FIELD1INTEGERCustomizable field.
FIELD2BIGINTCustomizable field.
FIELD3DECIMAL (20,5)Customizable field.
FIELD4VARCHAR (254)Customizable field.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>DMELETEMPLATE_IDPrimary Key
I0001147DMELEMENTTYPE_ID+NAME+STOREENT_IDUnique Index
I0001148STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3527DMELEMENTTYPE_IDDMELEMENTTYPEDMELEMENTTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3528DMELETEMPLATE_IDDMELEMENTDMELETEMPLATE_IDCascade