DMEXPFAMILY

The set of related marketing activities.

Column Descriptions:

NameTypeDescription
DMACTIVITY_IDINTEGER NOT NULLThe identifier of a marketing activity.
FAMILY_IDINTEGER NOT NULLThe ID of the activity which is the first activity from a set of activity versions. All versions of the same activity will have the same name and family_id, but will have different sequence numbers.
SEQUENCESMALLINT NOT NULL DEFAULT 0The sequence number of the activity.
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>DMACTIVITY_IDPrimary Key
I0001200FAMILY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3550DMACTIVITY_IDDMACTIVITYDMACTIVITY_IDCascade