.

Generated using SQL Data Dictionary demo version.

Table dbo.UserRoles (3 rows)

	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)
- UserRoleID

IX_UserRoles_RoleUser
- (Unique)
- RoleID
- UserID

IX_UserRoles_UserRole
- (Unique)
- UserID
- RoleID

References:

dbo.Roles
- RoleID
dbo.Users
- UserID

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
dbo.vw_UserRoles