Permissions Schema

Project: SqlServer

Layout: Permissions

 

Tip: Click on a table to jump to the field-level descriptions for the table.

 

 

Group

Id

int NOT NULL AUTOINCREMENT

Name

nvarchar( 64 ) NOT NULL

Description

nvarchar( 256 )

ManagingClientId

int NOT NULL

Indexes

PK_Permissions_Group primary key

ON Id

IXU_Permissions_Group_Name_ManagingClientId unique

ON Name, ManagingClientId

Foreign Keys

FK_Permissions_Group_ManagingClient

( ManagingClientId ) ref ManagingClient (ManagingClientId)

 

GroupUser

Id

int NOT NULL AUTOINCREMENT

GroupId

int NOT NULL

UserId

uniqueidentifier NOT NULL

Indexes

PK_Permissions_GroupUser primary key

ON Id

Foreign Keys

FK_Permissions_GroupUser_User

( UserId ) ref Users (UserId)

FK_Permissions_GroupUser_Group

( GroupId ) ref Group (Id)



Permission

Id

int NOT NULL AUTOINCREMENT

Name

nvarchar( 64 ) NOT NULL

Indexes

PK_Permissions_Permission primary key

ON Id

UX_Permissions_Permissions_UniqueName unique

ON Name

 

PermissionGrant

Id

int NOT NULL AUTOINCREMENT

ContextId

nvarchar( 64 )

ContextKind

nvarchar( 128 )

GroupId

int NOT NULL

PermissionId

int NOT NULL

Indexes

PK_Permissions_PermissionGrant primary key

ON Id

Foreign Keys

FK_Permissions_PermissionGrant_Group_Id

( GroupId ) ref Group (Id)

FK_Permissions_PermissionGrant_Permissions_Id

( PermissionId ) ref Permission (Id)

________________

Enterprise 2017.4.0