Generated using SQL Data Dictionary demo version.


Table dbo.Roles (8 rows)


  Column Data Type Identity Nullable Default
PK RoleID int X
UK , FK PortalID int X
UK RoleName nvarchar(50)
Description nvarchar(1000) X
ServiceFee money X 0
BillingFrequency char(1) X
TrialPeriod int X
TrialFrequency char(1) X
BillingPeriod int X
TrialFee money X
IsPublic bit 0
AutoAssignment bit 0
FK RoleGroupID int X
RSVPCode nvarchar(50) X
IconFile nvarchar(100) X
CreatedByUserID int X
CreatedOnDate datetime X
LastModifiedByUserID int X
LastModifiedOnDate datetime X
Status int 1
SecurityMode int 0
IsSystemRole bit 0

Indexes:


References:


Referenced by:


Used by: