EMAILADDRESS (4.0SP25)

The EMAILADDRESS table stores email addresses associated with a given constituent.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

CONSTITUENTID

uniqueidentifier

false

FK to CONSTITUENT

EMAILADDRESSTYPECODEID

uniqueidentifier

true

FK to EMAILADDRESSTYPECODE

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

INFOSOURCECODEID

uniqueidentifier

true

FK to INFOSOURCECODE

RELATIONSHIPID

uniqueidentifier

true

Stores the relationship ID this email address is associated with.
Fields
Field Field Type Null Notes Description

EMAILADDRESS

UDT_EMAILADDRESS

false

''

The constituent's email address.

ISPRIMARY

bit

false

0

Indicates this email address is the primary email address.

SEQUENCE

int

false

0

Stores the user-defined sequence for email addresses on a constituent.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

DONOTEMAIL

bit

false

0

Indicates this email address should not receive emails.

INFOSOURCECOMMENTS

nvarchar(256)

false

''

Contains additional comments about the information source.

ORIGINCODE

tinyint

false

0

Defines where the address originated.

ORIGIN

nvarchar(9) (Computed)

true

Provides a translation for the 'ORIGINCODE' field.

STARTDATE

datetime

true

The date the email address becomes valid.

ENDDATE

datetime

true

The date the email address becomes invalid.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_EMAILADDRESS_CONSTITUENTID_ISPRIMARY

CONSTITUENTID

ISPRIMARY

False

False

False

IX_EMAILADDRESS_DATEADDED

DATEADDED

False

False

True

IX_EMAILADDRESS_DATECHANGED

DATECHANGED

False

False

False

IX_EMAILADDRESS_EMAILADDRESS

EMAILADDRESS

False

False

False

IX_EMAILADDRESS_ID

ID

False

False

False

IX_EMAILADDRESS_RELATIONSHIPID

RELATIONSHIPID

False

False

False

PK_EMAILADDRESS

ID

True

True

False
Triggers
Trigger Name Description

TR_EMAILADDRESS_AUDIT_ETLDELETEDID

TR_EMAILADDRESS_TASYNC_I

TR_EMAILADDRESS_TASYNC_U

TR_EMAILADDRESS_TASYNC_D

TR_EMAILADDRESS_AUDIT_UPDATE

TR_EMAILADDRESS_AUDIT_DELETE

Referenced by
Referenced by Field

BATCHCONSTITUENTUPDATEEMAILADDRESSES

EMAILADDRESSID

BATCHEVENTSPONSORSHIP

EMAILADDRESSID

DONATIONBATCH

EMAILADDRESSID

MAILPREFERENCE

EMAILADDRESSID

MAILPREFERENCEGROUPCONTACT

EMAILADDRESSID

REGISTRANTBATCH

EMAILADDRESSID

SALESORDER

EMAILADDRESSID