Name value pairs associated with a campaign
element.
Column Descriptions:
Name | Type | Description |
DMELEMENT_ID | INTEGER NOT NULL | The identifier of the campaign element. |
NAME | VARCHAR (254) NOT NULL | The name of the name-value pair. |
VALUE | VARCHAR (254) NOT NULL | The value of the name-value pair. |
TRIGGERMATCH | SMALLINT NOT NULL DEFAULT 0 | A flag that specifies if this parameter is
required to match for the occurrence of a Trigger. |
PROPERTIES | VARCHAR (254) | The properties associated with this name-value
pair. |
SEQUENCE | DOUBLE | The sequence in which the data should be returned
in the campaign element. |
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+NAME+VALUE | Primary Key |
I0001194 | NAME+VALUE | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3532 | DMELEMENT_ID | DMELEMENT | DMELEMENT_ID | Cascade |