CAMPAIGNMEDIALINK

This table contains media links belonging to campaigns.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
DATEENTERED datetime The date the media link was entered.
TITLE nvarchar(50) Default = '' The title of the media link.
MEDIAURL UDT_WEBADDRESS Default = '' The web address of the associated document or media.
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.

Foreign Keys

Foreign Key Field Type Null Notes Description
AUTHORID uniqueidentifier yes CONSTITUENT.LOCALID The author of the media link.
CAMPAIGNMEDIALINKTYPECODEID uniqueidentifier CAMPAIGNMEDIALINKTYPECODE.ID Indicates the user-defined type of this media link.
CAMPAIGNID uniqueidentifier CAMPAIGN.LOCALID The campaign record to which this media link belongs.
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_CAMPAIGNMEDIALINK_AUTHORID AUTHORID
IX_CAMPAIGNMEDIALINK_CAMPAIGNID CAMPAIGNID
IX_CAMPAIGNMEDIALINK_DATEADDED DATEADDED yes
IX_CAMPAIGNMEDIALINK_DATECHANGED DATECHANGED
PK_CAMPAIGNMEDIALINK ID yes yes

Triggers

Trigger Name Description
TR_CAMPAIGNMEDIALINK_T2BDELETE
TR_CAMPAIGNMEDIALINK_AUDIT_UPDATE
TR_CAMPAIGNMEDIALINK_AUDIT_DELETE