Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
UserRoleID |
int |
X |
|
|
|
UK
,
FK
|
UserID |
int |
|
|
|
|
UK
,
FK
|
RoleID |
int |
|
|
|
|
ExpiryDate |
datetime |
|
X |
|
|
IsTrialUsed |
bit |
|
X |
|
|
EffectiveDate |
datetime |
|
X |
|
|
CreatedByUserID |
int |
|
X |
|
|
CreatedOnDate |
datetime |
|
X |
|
|
LastModifiedByUserID |
int |
|
X |
|
|
LastModifiedOnDate |
datetime |
|
X |
|
|
Status |
int |
|
|
1 |
|
IsOwner |
bit |
|
|
0 |
Indexes:
-
PK_UserRoles
- (Primary Key)
- (Clustered)
-
IX_UserRoles_RoleUser
-
IX_UserRoles_UserRole
References:
Used by:
- Function
dbo.FitsExtendedPropertyPermission
- Function
dbo.Journal_User_Permissions
- Function
dbo.UserIsInRole
- Procedure
dbo.AddUserRole
- Procedure
dbo.DeleteUserRole
- Procedure
dbo.GetFoldersByPermissions
- Procedure
dbo.GetPortalRoles
- Procedure
dbo.GetRoles
- Procedure
dbo.GetServices
- Procedure
dbo.GetUsersByRolename
- Procedure
dbo.IsUserInRole
- Procedure
dbo.RemoveUser
- Procedure
dbo.UpdateUserRole
- View