Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
FolderPermissionID |
int |
X |
|
|
|
UK
,
FK
|
FolderID |
int |
|
|
|
|
UK
,
FK
|
PermissionID |
int |
|
|
|
|
AllowAccess |
bit |
|
|
|
|
UK
,
FK
|
RoleID |
int |
|
X |
|
|
UK
,
FK
|
UserID |
int |
|
X |
|
|
CreatedByUserID |
int |
|
X |
|
|
CreatedOnDate |
datetime |
|
X |
|
|
LastModifiedByUserID |
int |
|
X |
|
|
LastModifiedOnDate |
datetime |
|
X |
|
Indexes:
-
PK_FolderPermission
- (Primary Key)
- (Clustered)
-
IX_FolderPermission_Folders
- FolderID
- PermissionID
- RoleID
- UserID
- AllowAccess
(Included)
-
IX_FolderPermission_Roles
- RoleID
- FolderID
- PermissionID
- AllowAccess
(Included)
-
IX_FolderPermission_Users
- UserID
- FolderID
- PermissionID
- AllowAccess
(Included)
-
IX_FolderPermission_Modules
-
IX_FolderPermission_Permission
References:
Used by:
- Procedure
dbo.AddFolderPermission
- Procedure
dbo.DeleteFolderPermission
- Procedure
dbo.DeleteFolderPermissionsByFolderPath
- Procedure
dbo.DeleteFolderPermissionsByUserID
- Procedure
dbo.DeleteRole
- Procedure
dbo.UpdateFolderPermission
- View