Open topic with navigation

WIDGETEXTENSION (4.0SP20)

Widget Extension Details - This is an extension table for EVENTWIDGET, PARTICIPANTWIDGET and TEAMWIDGET

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

PARTICIPANTWIDGETID

uniqueidentifier

true

The PARTICIPANTWIDGETID related to this extension

EVENTWIDGETID

uniqueidentifier

true

The EVENTWIDGETID related to this extension

TEAMWIDGETID

uniqueidentifier

true

The TEAMWIDGET related to this extension
Fields
Field Field Type Null Notes Description

ALLOWOTHERAMOUNT

bit

false

1

Allow participant other amount

SUGGESTAMOUNT

money

false

25

Suggested amount

ALLOWDONOROTHERAMOUNT

bit

false

1

Allow donor other amount

DISPLAYMINIMUMFUNDRAISINGGOAL

bit

false

0

Display minimum fundraising goal

DISPLAYTARGETFUNDRAISINGGOAL

bit

false

1

Display target fundraising goal

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

GIVINGLEVELDATA

nvarchar(4000)

false

'[[''Platinum'',500],[''Gold'',250],[''Silver'',100],[''Bronze'',50],[''Friend'',25]]'

Giving Levels Data

ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL

bit

false

1

Allow participant to change Join Team label

ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL

bit

false

1

Allow participant to change Join Company label

ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL

bit

false

1

Allow participant to change Join Event label

JOINMYTEAMLABEL

nvarchar(250)

false

''

Join my team label text

JOINMYCOMPANYLABEL

nvarchar(250)

false

''

Join my company label text

JOINMYEVENTLABEL

nvarchar(250)

false

''

Join my event label text
Indexes
Index Name Field(s) Unique Primary Clustered

IX_WIDGETEXTENSION_DATEADDED

DATEADDED

False

False

True

IX_WIDGETEXTENSION_DATECHANGED

DATECHANGED

False

False

False

IX_WIDGETEXTENSION_PARTICIPANTWIDGETID_EVENTWIDGETID_TEAMWIDGETID

PARTICIPANTWIDGETID

EVENTWIDGETID

TEAMWIDGETID

False

False

False

PK_WIDGETEXTENSION

ID

True

True

False
Triggers
Trigger Name Description

TR_WIDGETEXTENSION_AUDIT_UPDATE

TR_WIDGETEXTENSION_AUDIT_DELETE