Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ALLOWOTHERAMOUNT bit   Default = 1 Allow participant other amount
 SUGGESTAMOUNT money   Default = 25 Suggested amount
 ALLOWDONOROTHERAMOUNT bit   Default = 1 Allow donor other amount
 DISPLAYMINIMUMFUNDRAISINGGOAL bit   Default = 0 Display minimum fundraising goal
 DISPLAYTARGETFUNDRAISINGGOAL bit   Default = 1 Display target fundraising goal
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 GIVINGLEVELDATA nvarchar(4000)   Default = '[[''Platinum'',500],[''Gold'',250],[''Silver'',100],[''Bronze'',50],[''Friend'',25]]' Giving Levels Data
 ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL bit   Default = 1 Allow participant to change Join Team label
 ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL bit   Default = 1 Allow participant to change Join Company label
 ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL bit   Default = 1 Allow participant to change Join Event label
 JOINMYTEAMLABEL nvarchar(250)   Default = '' Join my team label text
 JOINMYCOMPANYLABEL nvarchar(250)   Default = '' Join my company label text
 JOINMYEVENTLABEL nvarchar(250)   Default = '' Join my event label text

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 PARTICIPANTWIDGETID uniqueidentifier PARTICIPANTWIDGET.ID The PARTICIPANTWIDGETID related to this extension
 EVENTWIDGETID uniqueidentifier EVENTWIDGET.ID The EVENTWIDGETID related to this extension
 TEAMWIDGETID uniqueidentifier TEAMWIDGET.ID The TEAMWIDGET related to this extension

Index Name Field(s) Unique Primary Clustered
 IX_WIDGETEXTENSION_DATEADDED DATEADDED    
 IX_WIDGETEXTENSION_DATECHANGED DATECHANGED      
 IX_WIDGETEXTENSION_PARTICIPANTWIDGETID_EVENTWIDGETID_TEAMWIDGETID PARTICIPANTWIDGETID, EVENTWIDGETID, TEAMWIDGETID      
 PK_WIDGETEXTENSION ID  

Trigger Name Description
 TR_WIDGETEXTENSION_AUDIT_UPDATE
 TR_WIDGETEXTENSION_AUDIT_DELETE

Entity-Relationship diagram of this table