Setting

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Name	nvarchar(128)	yes
Value	nvarchar(1024)	yes
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
ADDEDBYCMSUSERID	int	yes
CHANGEDBYCMSUSERID	int	yes
TS	timestamp
TSLONG	bigint (Computed)	yes	convert(bigint, TS)
GUID	uniqueidentifier		Default = (newid())

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_Setting	ID	yes	yes	yes

Triggers

Trigger Name	Description
TR_SETTING_AUDIT_DELETE
TR_SETTING_AUDIT_UPDATE