DMELEMENT

Campaign elements associated with a marketing activity.

Column Descriptions:

Name	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	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>	DMELEMENT_ID	Primary Key
I0001149	NAME+DMACTIVITY_ID	Unique Index
I0001150	DMELETEMPLATE_ID+DMACTIVITY_ID	Non-Unique Index
I0001151	DMACTIVITY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3528	DMELETEMPLATE_ID	DMELETEMPLATE	DMELETEMPLATE_ID	Cascade
F_3529	DMACTIVITY_ID	DMACTIVITY	DMACTIVITY_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3531	DMELEMENT_ID	DMTRIGLSTN	DMELEMENT_ID	Cascade
F_3532	DMELEMENT_ID	DMELEMENTNVP	DMELEMENT_ID	Cascade
F_3595	DMELEMENT_ID	DMRANKINGITEM	DMELEMENT_ID	Cascade