Open topic with navigation

NETCOMMUNITYEMAILINFO (4.0SP17)

Contains email information of Blackbaud Internet Solutions users.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

NETCOMMUNITYCLIENTUSERID

uniqueidentifier

true

Blackbaud Internet Solutions user linked to this email info.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

BBNCMAPID

int

false

0

Blackbaud Internet Solutions email info ID.

OPTEDIN

bit

false

0

Opted-in to receive email.

FORWARDINGENABLED

bit

false

0

Indicates that email forwarding is enabled.

INCOMINGEMAILADDRESS

nvarchar(510)

false

''

Incoming email address for forwarding.

FORWARDINGEMAILADDRESS

nvarchar(510)

false

''

Email address where mail is forwarded..

UPDATEDATE

datetime

true

Time the Blackbaud Internet Solutions email info was updated.

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.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_NETCOMMUNITYEMAILINFO_DATEADDED

DATEADDED

False

False

True

IX_NETCOMMUNITYEMAILINFO_DATECHANGED

DATECHANGED

False

False

False

IX_NETCOMMUNITYEMAILINFO_NETCOMMUNITYCLIENTUSERID

NETCOMMUNITYCLIENTUSERID

False

False

False

PK_NETCOMMUNITYEMAILINFO

ID

True

True

False

UIX_NETCOMMUNITYEMAILINFO_BBNCMAPID

BBNCMAPID

True

False

False
Triggers
Trigger Name Description

TR_NETCOMMUNITYEMAILINFO_AUDIT_UPDATE

TR_NETCOMMUNITYEMAILINFO_AUDIT_DELETE