FAFGROUPSUMMARYINFORMATION_CATEGORIZED

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
GIFTCOUNT_PARTICIPANTS	int		Default = 0
GIFTCOUNT_ONLINE	int		Default = 0
GIFTCOUNT_OFFLINE	int		Default = 0
GIFTCOUNT_FROMEMAIL	int		Default = 0
GIFTCOUNT_FROMSOCIALMEDIA	int		Default = 0
GIFTCOUNT_SELF	int		Default = 0
AMOUNT_PARTICIPANTS	money		Default = 0
AMOUNT_ONLINE	money		Default = 0
AMOUNT_OFFLINE	money		Default = 0
AMOUNT_FROMEMAIL	money		Default = 0
AMOUNT_FROMSOCIALMEDIA	money		Default = 0
AMOUNT_SELF	money		Default = 0
AMOUNT_PENDING	money		Default = 0
COUNT_SOCIALMEDIAPOSTS	int		Default = 0
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		TEAMFUNDRAISINGTEAM.ID
EVENTID	uniqueidentifier	yes	EVENT.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_DATEADDED	DATEADDED			yes
IX_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_DATECHANGED	DATECHANGED
IX_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_EVENTID	EVENTID
PK_FAFGROUPSUMMARYINFORMATION_CATEGORIZED	ID	yes	yes

Triggers

Trigger Name	Description
TR_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_AUDIT_UPDATE
TR_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_AUDIT_DELETE