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.
OPTCOUNTERSMALLINTThe 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