MAILPREFERENCEGROUPCONTACT

Defines which constituent group members a mail preference applies to.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
USEPRIMARYADDRESS	bit		Default = 0	If true, use the constituent's current primary address.
USEPRIMARYEMAIL	bit		Default = 0	If true, use the constituent's current primary email address.
USEPRIMARYCONTACT	bit		Default = 0	If true, use the group's primary contact.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
MAILPREFERENCEID	uniqueidentifier		MAILPREFERENCE.ID	FK to MAILPREFERENCE
CONSTITUENTID	uniqueidentifier	yes	CONSTITUENT.LOCALID	FK to CONSTITUENT
ADDRESSID	uniqueidentifier	yes	ADDRESS.LOCALID	FK to ADDRESS
EMAILADDRESSID	uniqueidentifier	yes	EMAILADDRESS.ID	FK to EMAILADDRESS
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MAILPREFERENCEGROUPCONTACT_ADDRESSID	ADDRESSID
IX_MAILPREFERENCEGROUPCONTACT_CONSTITUENTID	CONSTITUENTID
IX_MAILPREFERENCEGROUPCONTACT_DATEADDED	DATEADDED			yes
IX_MAILPREFERENCEGROUPCONTACT_DATECHANGED	DATECHANGED
IX_MAILPREFERENCEGROUPCONTACT_MAILPREFERENCEID	MAILPREFERENCEID
PK_MAILPREFERENCEGROUPCONTACT	ID	yes	yes

Triggers

Trigger Name	Description
TR_MAILPREFERENCEGROUPCONTACT_AUDIT_UPDATE
TR_MAILPREFERENCEGROUPCONTACT_AUDIT_DELETE