DMELEMENTNVP

Name value pairs associated with a campaign element.

Column Descriptions:

NameTypeDescription
DMELEMENT_IDINTEGER NOT NULLThe identifier of the campaign element.
NAMEVARCHAR (254) NOT NULLThe name of the name-value pair.
VALUEVARCHAR (254) NOT NULLThe value of the name-value pair.
TRIGGERMATCHSMALLINT NOT NULL DEFAULT 0A flag that specifies if this parameter is required to match for the occurrence of a Trigger.
PROPERTIESVARCHAR (254)The properties associated with this name-value pair.
SEQUENCEDOUBLEThe sequence in which the data should be returned in the campaign element.
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>DMELEMENT_ID+NAME+VALUEPrimary Key
I0001194NAME+VALUENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3532DMELEMENT_IDDMELEMENTDMELEMENT_IDCascade