Permissions Schema
Project: SqlServer
Layout: Permissions
|
|
Tip: Click on a table to jump to the field-level descriptions for the table. |
|
int NOT NULL AUTOINCREMENT |
|
|
nvarchar( 64 ) NOT NULL |
|
|
nvarchar( 256 ) |
|
|
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) |
|
int NOT NULL AUTOINCREMENT |
|
|
int NOT NULL |
|
|
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) |
|
int NOT NULL AUTOINCREMENT |
|
|
nvarchar( 64 ) NOT NULL |
|
|
Indexes |
|
|
PK_Permissions_Permission primary key |
ON Id |
|
UX_Permissions_Permissions_UniqueName unique |
ON Name |
|
int NOT NULL AUTOINCREMENT |
|
|
nvarchar( 64 ) |
|
|
nvarchar( 128 ) |
|
|
int NOT NULL |
|
|
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) |
________________
OPEN DISCOVERY 2017.4.0