FAFFUNDRAISINGROLESCONTENT

Part content data for the FAF fundraising roles part.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
STARTACOMPANYTITLE nvarchar(500) Default = '' Start a company title
STARTACOMPANYDESCRIPTION nvarchar(510) Default = '' Start a company description
STARTACOMPANYIMAGEID int Default = 0 Start a company image ID
STARTATEAMTITLE nvarchar(500) Default = '' Start a team title
STARTATEAMDESCRIPTION nvarchar(510) Default = '' Start a team description
STARTATEAMTITLEIMAGEID int Default = 0 Start a team image ID
STARTATEAMUNDERGROUPTITLE nvarchar(500) Default = '' Start a team under group title
STARTATEAMUNDERGROUPDESCRIPTION nvarchar(510) Default = '' Start a team under group description
STARTATEAMUNDERGROUPIMAGEID int Default = 0 Start a team under group image ID
STARTATEAMINDEPENDENTTITLE nvarchar(500) Default = '' Start a team independent title
STARTATEAMINDEPENDENTDESCRIPTION nvarchar(510) Default = '' Start a team independent description
STARTATEAMINDEPENDENTIMAGEID int Default = 0 Start a team independent image ID
JOINATEAMTITLE nvarchar(500) Default = '' Join a team title
JOINATEAMDESCRIPTION nvarchar(510) Default = '' Join a team description
JOINATEAMTITLEIMAGEID int Default = 0 Join a team image ID
STARTAHOUSEHOLDTITLE nvarchar(500) Default = '' Start a household title
STARTAHOUSEHOLDDESCRIPTION nvarchar(510) Default = '' Start a household description
STARTAHOUSEHOLDIMAGEID int Default = 0 Start a household image ID
STARTAHOUSEHOLDUNDERCOMPANYTITLE nvarchar(500) Default = '' Start a household under company title
STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION nvarchar(510) Default = '' Start a household under company description
STARTAHOUSEHOLDUNDERCOMPANYIMAGEID int Default = 0 Start a household under company image ID
STARTAHOUSEHOLDUNDERTEAMTITLE nvarchar(500) Default = '' Start a household under team title
STARTAHOUSEHOLDUNDERTEAMDESCRIPTION nvarchar(510) Default = '' Start a household under team description
STARTAHOUSEHOLDUNDERTEAMIMAGEID int Default = 0 Start a household under team image ID
STARTAHOUSEHOLDINDEPENDENTTITLE nvarchar(500) Default = '' Start a household independent title
STARTAHOUSEHOLDINDEPENDENTDESCRIPTION nvarchar(510) Default = '' Start a household independent description
STARTAHOUSEHOLDINDEPENDENTIMAGEID int Default = 0 Start a household independent image ID
JOINASINDIVIDUALTITLE nvarchar(500) Default = '' Join as individual title
JOINASINDIVIDUALDESCRIPTION nvarchar(510) Default = '' Join as individual description
JOINASINDIVIDUALIMAGEID int Default = 0 Join as individual image ID
JOINASINDIVIDUALUNDERCOMPANYTITLE nvarchar(500) Default = '' Join as individual under company title
JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION nvarchar(510) Default = '' Join as individual under company description
JOINASINDIVIDUALUNDERCOMPANYIMAGEID int Default = 0 Join as individual under company image ID
JOINASINDIVIDUALPARTICIPANTTITLE nvarchar(500) Default = '' Join as individual participant title
JOINASINDIVIDUALPARTICIPANTDESCRIPTION nvarchar(510) Default = '' Join as individual participant description
JOINASINDIVIDUALPARTICIPANTIMAGEID int Default = 0 Join as individual participant image ID
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) yes CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Keys

Foreign Key Field Type Null Notes Description
REGISTRATIONPAGEID int yes SitePages.ID Registration page ID.
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_FAFFUNDRAISINGROLESCONTENT_DATEADDED DATEADDED yes
IX_FAFFUNDRAISINGROLESCONTENT_DATECHANGED DATECHANGED
PK_FAFFUNDRAISINGROLESCONTENT ID yes yes

Triggers

Trigger Name Description
TR_FAFFUNDRAISINGROLESCONTENT_AUDIT_UPDATE
TR_FAFFUNDRAISINGROLESCONTENT_AUDIT_DELETE