USERSETTINGSCONSTITUENTSUMMARYTILES

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
SHOWTILES bit Default = 1
DATEADDED datetime Default = getdate()
DATECHANGED datetime Default = getdate()
TS timestamp
TSLONG bigint (Computed) yes CONVERT(bigint, TS)

Foreign Keys

Foreign Key Field Type Null Notes Description
ID uniqueidentifier APPUSER.ID
ADDEDBYID uniqueidentifier CHANGEAGENT.ID
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID

Indexes

Index Name Fields Unique Primary Clustered
IX_USERSETTINGSCONSTITUENTSUMMARYTILES_DATEADDED DATEADDED yes
IX_USERSETTINGSCONSTITUENTSUMMARYTILES_DATECHANGED DATECHANGED
PK_USERSETTINGSCONSTITUENTSUMMARYTILES ID yes yes

Triggers

Trigger Name Description
TR_USERSETTINGSCONSTITUENTSUMMARYTILES_AUDIT_UPDATE
TR_USERSETTINGSCONSTITUENTSUMMARYTILES_AUDIT_DELETE