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:
| Name | 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 (1000000) | The template XML defintion of the user interface
configuration associated with the campaign element template. |
| IMPLXML | CLOB (1000000) | The template XML definition of the runtime
implementation of the campaign element template. |
| BEHAVIORXML | CLOB (1000000) | The template XML definition of the filter to
detect the customer's online behavior for sending Triggers, and
recording behavior for Targets. |
| RELATEDXML | CLOB (1000000) | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | DMELETEMPLATE_ID | Primary Key |
| I0001147 | DMELEMENTTYPE_ID+NAME+STOREENT_ID | Unique Index |
| I0001148 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3527 | DMELEMENTTYPE_ID | DMELEMENTTYPE | DMELEMENTTYPE_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3528 | DMELETEMPLATE_ID | DMELEMENT | DMELETEMPLATE_ID | Cascade |