Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NUMBERCOMPANIESTODISPLAY smallint   Default = ((5)) Number of companies to display
 NUMBERTEAMSTODISPLAY smallint   Default = ((5)) Number of teams to display
 NUMBERHOUSEHOLDSTODISPLAY smallint   Default = ((5)) Number of households to display
 NUMBERPARTICIPANTSTODISPLAY smallint   Default = ((5)) Number of participants to display
 PLAYEROPTIONSTITLE nvarchar(200)   Default = '' Player Options Title
 WIDTH smallint   Default = ((0)) Maximum dimension width for donor wall
 HEIGHT smallint   Default = ((0)) Maximum dimension height for donor wall
 SCROLLINGDIRECTIONCODE tinyint   Default = 1 Direction of scroll (asc or desc)
 SCROLLINGDIRECTION nvarchar(10) (Computed) CASE [SCROLLINGDIRECTIONCODE] WHEN 0 THEN N'Ascending' WHEN 1 THEN N'Descending' END Provides a translation for the 'SCROLLINGDIRECTIONCODE' field.
 SPEED smallint   Default = ((0)) Speed at which donor names scroll
 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.
 DISPLAYCOMPANYNAME bit   Default = 1 Display company name
 DISPLAYCOMPANYPICTURE bit   Default = 1 Display company picture
 DISPLAYCOMPANYSTORY bit   Default = 1 Display company story
 DISPLAYCOMPANYTOTALRAISED bit   Default = 1 Display total raised
 DISPLAYCOMPANYFUNDRAISINGGOAL bit   Default = 1 Display fundraising goal
 DISPLAYTEAMNAME bit   Default = 1 Display team name
 DISPLAYTEAMPICTURE bit   Default = 1 Display team picture
 DISPLAYTEAMSTORY bit   Default = 1 Display team story
 DISPLAYTEAMTOTALRAISED bit   Default = 1 Display total raised
 DISPLAYTEAMFUNDRAISINGGOAL bit   Default = 1 Display fundraising goal
 DISPLAYHOUSEHOLDNAME bit   Default = 1 Display household name
 DISPLAYHOUSEHOLDPICTURE bit   Default = 1 Display household picture
 DISPLAYHOUSEHOLDSTORY bit   Default = 1 Display household story
 DISPLAYHOUSEHOLDTOTALRAISED bit   Default = 1 Display total raised
 DISPLAYHOUSEHOLDFUNDRAISINGGOAL bit   Default = 1 Display fundraising goal
 DISPLAYPARTICIPANTNAME bit   Default = 1 Display participant name
 DISPLAYPARTICIPANTPICTURE bit   Default = 1 Display participant picture
 DISPLAYPARTICIPANTSTORY bit   Default = 1 Display participant story
 DISPLAYPARTICIPANTTOTALRAISED bit   Default = 1 Display total raised
 DISPLAYPARTICIPANTFUNDRAISINGGOAL bit   Default = 1 Display fundraising goal
 DISPLAYPLAYPAUSEOPTIONS bit   Default = 1 Display play and pause options
 DISPLAYCOMPANIES bit   Default = 1 Display companies
 DISPLAYTEAMS bit   Default = 1 Display teams
 DISPLAYHOUSEHOLDS bit   Default = 1 Display households
 DISPLAYPARTICIPANTS bit   Default = 1 Display participants
 DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME bit   Default = 1 Display team name in addition to fundraiser name
 DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME bit   Default = 1 Display company name in addition to fundraiser name

Foreign Key Field Type Null Notes Description
 EVENTID uniqueidentifier   EVENT.ID Foreign Key to Event table
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_FAFTOPFUNDRAISERDISPLAYOPTION_DATEADDED DATEADDED    
 IX_FAFTOPFUNDRAISERDISPLAYOPTION_DATECHANGED DATECHANGED      
 IX_FAFTOPFUNDRAISERDISPLAYOPTION_EVENTID EVENTID      
 PK_FAFTOPFUNDRAISERDISPLAYOPTION ID  

Trigger Name Description
 TR_FAFTOPFUNDRAISERDISPLAYOPTION_AUDIT_UPDATE
 TR_FAFTOPFUNDRAISERDISPLAYOPTION_AUDIT_DELETE

Entity-Relationship diagram of this table