Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 Name nvarchar(50)  
 SystemRole bit   Default = 0
 SiteAdminRole bit   Default = 0
 EveryoneRole bit   Default = 0
 OwnerID int
 Guid uniqueidentifier Default = (newid())
 Deleted bit   Default = 0
 Cascading bit   Default = 0
 ClientsID int  
 REQueryID int
 REQueryName nvarchar(50)
 BBSystem int
 REConstituentsOnly bit
 ImageID int
 RefreshedDate datetime

Index Name Field(s) Unique Primary Clustered
 IX_ClientRoles_ForceOrder ClientsID, EveryoneRole (DESC), Name    
 IX_ClientRoles ClientsID, Name    
 PK_Roles ID  

Referenced by Field
 ChapterRoles ClientRolesID
 CLIENTROLECHILD PARENTCLIENTROLEID
 CLIENTROLECHILD CHILDCLIENTROLEID
 CMSNOTIFICATIONROLE CLIENTROLEID
 CMSSECURITYGROUPCLIENTROLECLIENTSITE CLIENTROLESID
 NetGroup ClientRolesID
 RoleObjectPrivs ClientRolesID
 UserRoles ClientRolesID
 WorkflowRoles ClientRolesID

Entity-Relationship diagram of this table