Primary Key Field Type
 ID uniqueidentifier

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) CONVERT(bigint, TS) Numeric representation of the timestamp.

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

Index Name Field(s) Unique Primary Clustered
 IX_FAFFUNDRAISINGROLESCONTENT_DATEADDED DATEADDED    
 IX_FAFFUNDRAISINGROLESCONTENT_DATECHANGED DATECHANGED      
 PK_FAFFUNDRAISINGROLESCONTENT ID  

Trigger Name Description
 TR_FAFFUNDRAISINGROLESCONTENT_AUDIT_UPDATE
 TR_FAFFUNDRAISINGROLESCONTENT_AUDIT_DELETE