Generated using SQL Data Dictionary demo version.


View dbo.vw_UserRoles


Column Data Type Nullable
UserRoleID int
RoleID int
UserID int
PortalID int
RoleName nvarchar(50)
Username nvarchar(100)
Description nvarchar(1000) X
DisplayName nvarchar(128)
Email nvarchar(256) X
Status int
IsOwner bit
SecurityMode int
ServiceFee money X
BillingFrequency char(1) X
TrialPeriod int X
TrialFrequency char(1) X
BillingPeriod int X
TrialFee money X
IsPublic bit
AutoAssignment bit
RoleGroupID int X
RSVPCode nvarchar(50) X
IconFile nvarchar(100) X
EffectiveDate datetime X
ExpiryDate datetime X
IsTrialUsed bit X
CreatedByUserID int X
CreatedOnDate datetime X
LastModifiedByUserID int X
LastModifiedOnDate datetime X

Used by:


Uses: