EVENTWIDGET (4.0)

Widgets available in the Event for Admin

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

EVENTID

uniqueidentifier

false

FK to EVENT

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

WIDGETID

int

false

FK to WIDGETGALLERY

DISPLAYTEXT

nvarchar(4000)

false

''

Display Text

ROLECODE

tinyint

false

0

Role Type

ISACTIVE

bit

false

1

Indicates whether this is active or not

ALLOWEDIT

bit

false

0

Allow participant to Edit the widget

ALLOWMOVE

bit

false

0

Allow Participant to Move the widget

ALLOWREMOVE

bit

false

0

Allow Participant to Add/Remove the widget

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.

ROLE

nvarchar(11) (Computed)

true

Provides a translation for the 'ROLECODE' field.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_EVENTWIDGET_DATEADDED

DATEADDED

False

False

True

IX_EVENTWIDGET_DATECHANGED

DATECHANGED

False

False

False

PK_EVENTWIDGET

ID

True

True

False

UIX_EVENTWIDGET_WIDGETID_EVENTID_ROLECODE

WIDGETID

EVENTID

ROLECODE

True

False

False
Triggers
Trigger Name Description

TR_EVENTWIDGET_AUDIT_UPDATE

TR_EVENTWIDGET_AUDIT_DELETE

Referenced by
Referenced by Field

WIDGETEXTENSION

EVENTWIDGETID