EMLGRPREL

This table stores the relationship between an e-mail activity and its target customer segment.

Column Descriptions:

NameTypeDescription
MBRGRP_IDBIGINT NOT NULLThe ID of the customer segment targeted by the related e-mail activity.
EMLPROMO_IDINTEGER NOT NULLThe ID of the e-mail activity in the relationship.
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>EMLPROMO_IDPrimary Key
I0000563MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_963EMLPROMO_IDEMLPROMOEMLPROMO_IDCascade
F_964MBRGRP_IDMBRGRPMBRGRP_IDCascade