APPUSERSITEBRANCH

Stores the flattened version of an application user's default site branchsite permissions. This table was created so that the sql would not have to walk the site hierarchy when querying on the default site branch.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NODELOCATIONCODE	tinyint		Default = 1	Used to describe the location of the nodes within the branch.
NODELOCATION	nvarchar(17) (Computed)	yes	CASE [NODELOCATIONCODE] WHEN 2 THEN N'Ancestor Node' WHEN 1 THEN N'Default Site Node' WHEN 0 THEN N'Descendant Node' END	Provides a translation for the 'NODELOCATIONCODE' field.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
SITEID	uniqueidentifier		SITE.ID	FK to SITE
APPUSERID	uniqueidentifier		APPUSER.ID	FK to APPUSER

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_APPUSERSITEBRANCH_APPUSERID	APPUSERID
IX_APPUSERSITEBRANCH_SITEID	SITEID
PK_APPUSERSITEBRANCH	ID	yes	yes	yes