EVENTSITE

Contains information pertaining to an event's sites.

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.

Foreign Keys

Foreign Key Field Type Null Notes Description
EVENTID uniqueidentifier EVENT.ID FK to EVENT
SITEID uniqueidentifier SITE.ID FK to SITE
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_EVENTSITE_DATEADDED DATEADDED yes
IX_EVENTSITE_DATECHANGED DATECHANGED
IX_EVENTSITE_EVENTID EVENTID
IX_EVENTSITE_SITEID SITEID
PK_EVENTSITE ID yes yes

Triggers

Trigger Name Description
TR_EVENTSITE_AUDIT_ETLDELETEDID
TR_EVENTSITE_AUDIT_UPDATE
TR_EVENTSITE_AUDIT_DELETE