Generated using SQL Data Dictionary demo version.

DNN

(Last updated on Tue, Dec 23rd at 7:50 PM)

Tables:

Views:

Tables:

• Table dbo.Affiliates (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	AffiliateId	int	X
  FK	VendorId	int		X
  	StartDate	datetime		X
  	EndDate	datetime		X
  	CPC	float
  	Clicks	int
  	CPA	float
  	Acquisitions	int

  
  

  Indexes:

  
  

  • PK_Affiliates

    • (Primary Key)
    • (Clustered)
    
    
    
    • AffiliateId
  
  

  References:

  
  

  • dbo.Vendors

    
    
    
    • VendorId
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddAffiliate

    
    
    
  • Procedure 

    dbo.DeleteAffiliate

    
    
    
  • Procedure 

    dbo.GetAffiliate

    
    
    
  • Procedure 

    dbo.GetAffiliates

    
    
    
  • Procedure 

    dbo.UpdateAffiliate

    
    
    
  • Procedure 

    dbo.UpdateAffiliateStats

    
    
    

• Table dbo.AnonymousUsers (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UserID	char(36)
  PK, FK	PortalID	int
  	TabID	int
  	CreationDate	datetime			getdate()
  	LastActiveDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_AnonymousUsers

    • (Primary Key)
    • (Clustered)
    
    
    
    • UserID
    • PortalID
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Used by:

  
  

  • Procedure 

    dbo.DeleteUsersOnline

    
    
    
  • Procedure 

    dbo.UpdateAnonymousUser

    
    
    

• Table dbo.aspnet_Applications (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  UK	ApplicationName	nvarchar(256)
  UK	LoweredApplicationName	nvarchar(256)
  PK	ApplicationId	uniqueidentifier			newid()
  	Description	nvarchar(256)		X

  
  

  Indexes:

  
  

  • PK__aspnet_A__C93A4C98135FB156

    • (Primary Key)
    
    
    
    • ApplicationId
  
  

  • UQ__aspnet_A__17477DE432C1C91F

    • (Unique)
    
    
    
    • LoweredApplicationName
  
  

  • UQ__aspnet_A__3091033132B6B49A

    • (Unique)
    
    
    
    • ApplicationName
  
  

  • aspnet_Applications_Index

    • (Clustered)
    
    
    
    • LoweredApplicationName
  
  

  Referenced by:

  
  

  • dbo.aspnet_Membership

    
    
    
    • ApplicationId
    
    

  • dbo.aspnet_Users

    
    
    
    • ApplicationId
    
    

  Used by:

  
  

  • Procedure 

    dbo.aspnet_AnyDataInTables

    
    
    
  • Procedure 

    dbo.aspnet_Applications_CreateApplication

    
    
    
  • Procedure 

    dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer

    
    
    
  • Procedure 

    dbo.aspnet_Membership_FindUsersByEmail

    
    
    
  • Procedure 

    dbo.aspnet_Membership_FindUsersByName

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetAllUsers

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetNumberOfUsersOnline

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetPasswordWithFormat

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByEmail

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByName

    
    
    
  • Procedure 

    dbo.aspnet_Membership_ResetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_SetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UnlockUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UpdateUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UpdateUserInfo

    
    
    
  • Procedure 

    dbo.aspnet_Users_DeleteUser

    
    
    
  • View 

    dbo.vw_aspnet_Applications

    
    
    

• Table dbo.aspnet_Membership (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  FK	ApplicationId	uniqueidentifier
  PK, FK	UserId	uniqueidentifier
  	Password	nvarchar(128)
  	PasswordFormat	int			0
  	PasswordSalt	nvarchar(128)
  	MobilePIN	nvarchar(16)		X
  	Email	nvarchar(256)		X
  	LoweredEmail	nvarchar(256)		X
  	PasswordQuestion	nvarchar(256)		X
  	PasswordAnswer	nvarchar(128)		X
  	IsApproved	bit
  	IsLockedOut	bit
  	CreateDate	datetime
  	LastLoginDate	datetime
  	LastPasswordChangedDate	datetime
  	LastLockoutDate	datetime
  	FailedPasswordAttemptCount	int
  	FailedPasswordAttemptWindowStart	datetime
  	FailedPasswordAnswerAttemptCount	int
  	FailedPasswordAnswerAttemptWindowStart	datetime
  	Comment	ntext		X

  
  

  Indexes:

  
  

  • PK__aspnet_M__1788CC4DAC708830

    • (Primary Key)
    
    
    
    • UserId
  
  

  • aspnet_Membership_index

    • (Clustered)
    
    
    
    • ApplicationId
    • LoweredEmail
  
  

  References:

  
  

  • dbo.aspnet_Applications

    
    
    
    • ApplicationId
    
    

  • dbo.aspnet_Users

    
    
    
    • UserId
    
    

  Used by:

  
  

  • Procedure 

    dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer

    
    
    
  • Procedure 

    dbo.aspnet_Membership_CreateUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetNumberOfUsersOnline

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetPasswordWithFormat

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByEmail

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByName

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByUserId

    
    
    
  • Procedure 

    dbo.aspnet_Membership_ResetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_SetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UnlockUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UpdateUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UpdateUserInfo

    
    
    
  • View 

    dbo.vw_aspnet_MembershipUsers

    
    
    

• Table dbo.aspnet_SchemaVersions (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	Feature	nvarchar(128)
  PK	CompatibleSchemaVersion	nvarchar(128)
  	IsCurrentVersion	bit

  
  

  Indexes:

  
  

  • PK__aspnet_S__5A1E6BC16D3C338C

    • (Primary Key)
    • (Clustered)
    
    
    
    • Feature
    • CompatibleSchemaVersion
  
  

  Used by:

  
  

  • Procedure 

    dbo.aspnet_CheckSchemaVersion

    
    
    
  • Procedure 

    dbo.aspnet_RegisterSchemaVersion

    
    
    
  • Procedure 

    dbo.aspnet_UnRegisterSchemaVersion

    
    
    

• Table dbo.aspnet_Users (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  UK , FK	ApplicationId	uniqueidentifier
  PK	UserId	uniqueidentifier			newid()
  	UserName	nvarchar(256)
  UK	LoweredUserName	nvarchar(256)
  	MobileAlias	nvarchar(16)		X	NULL
  	IsAnonymous	bit			0
  	LastActivityDate	datetime

  
  

  Indexes:

  
  

  • PK__aspnet_U__1788CC4D4C6A2C60

    • (Primary Key)
    
    
    
    • UserId
  
  

  • aspnet_Users_Index

    • (Unique)
    • (Clustered)
    
    
    
    • ApplicationId
    • LoweredUserName
  
  

  • aspnet_Users_Index2

    
    
    
    • ApplicationId
    • LastActivityDate
  
  

  References:

  
  

  • dbo.aspnet_Applications

    
    
    
    • ApplicationId
    
    

  Referenced by:

  
  

  • dbo.aspnet_Membership

    
    
    
    • UserId
    
    

  Used by:

  
  

  • Procedure 

    dbo.aspnet_AnyDataInTables

    
    
    
  • Procedure 

    dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer

    
    
    
  • Procedure 

    dbo.aspnet_Membership_CreateUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetNumberOfUsersOnline

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetPasswordWithFormat

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByEmail

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByName

    
    
    
  • Procedure 

    dbo.aspnet_Membership_GetUserByUserId

    
    
    
  • Procedure 

    dbo.aspnet_Membership_ResetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_SetPassword

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UnlockUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UpdateUser

    
    
    
  • Procedure 

    dbo.aspnet_Membership_UpdateUserInfo

    
    
    
  • Procedure 

    dbo.aspnet_Users_CreateUser

    
    
    
  • Procedure 

    dbo.aspnet_Users_DeleteUser

    
    
    
  • Procedure 

    dbo.ChangeUsername

    
    
    
  • View 

    dbo.vw_aspnet_MembershipUsers

    
    
    
  • View 

    dbo.vw_aspnet_Users

    
    
    

• Table dbo.Assemblies (41 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	AssemblyID	int	X
  FK	PackageID	int		X
  	AssemblyName	nvarchar(250)
  	Version	nvarchar(20)

  
  

  Indexes:

  
  

  • PK_PackageAssemblies

    • (Primary Key)
    • (Clustered)
    
    
    
    • AssemblyID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.RegisterAssembly

    
    
    
  • Procedure 

    dbo.UnRegisterAssembly

    
    
    

• Table dbo.Authentication (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	AuthenticationID	int	X
  FK	PackageID	int			-1
  	AuthenticationType	nvarchar(100)
  	IsEnabled	bit			0
  	SettingsControlSrc	nvarchar(250)
  	LoginControlSrc	nvarchar(250)
  	LogoffControlSrc	nvarchar(250)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_Authentication

    • (Primary Key)
    • (Clustered)
    
    
    
    • AuthenticationID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddAuthentication

    
    
    
  • Procedure 

    dbo.DeleteAuthentication

    
    
    
  • Procedure 

    dbo.GetAuthenticationService

    
    
    
  • Procedure 

    dbo.GetAuthenticationServiceByPackageID

    
    
    
  • Procedure 

    dbo.GetAuthenticationServiceByType

    
    
    
  • Procedure 

    dbo.GetAuthenticationServices

    
    
    
  • Procedure 

    dbo.GetEnabledAuthenticationServices

    
    
    
  • Procedure 

    dbo.UpdateAuthentication

    
    
    

• Table dbo.Banners (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	BannerId	int	X
  FK	VendorId	int
  	ImageFile	nvarchar(100)		X
  	BannerName	nvarchar(100)
  	Impressions	int
  	CPM	float
  	Views	int			0
  	ClickThroughs	int			0
  	StartDate	datetime		X
  	EndDate	datetime		X
  	CreatedByUser	nvarchar(100)
  	CreatedDate	datetime
  	BannerTypeId	int		X
  	Description	nvarchar(2000)		X
  	GroupName	nvarchar(100)		X
  	Criteria	bit			1
  	URL	nvarchar(255)		X
  	Width	int			0
  	Height	int			0

  
  

  Indexes:

  
  

  • PK_Banner

    • (Primary Key)
    • (Clustered)
    
    
    
    • BannerId
  
  

  • IX_Banners

    
    
    
    • BannerTypeId
  
  

  • IX_Banners_1

    
    
    
    • VendorId
  
  

  References:

  
  

  • dbo.Vendors

    
    
    
    • VendorId
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddBanner

    
    
    
  • Procedure 

    dbo.DeleteBanner

    
    
    
  • Procedure 

    dbo.FindBanners

    
    
    
  • Procedure 

    dbo.GetBanner

    
    
    
  • Procedure 

    dbo.GetBannerGroups

    
    
    
  • Procedure 

    dbo.GetBanners

    
    
    
  • Procedure 

    dbo.UpdateBanner

    
    
    
  • Procedure 

    dbo.UpdateBannerClickThrough

    
    
    
  • Procedure 

    dbo.UpdateBannerViews

    
    
    

• Table dbo.Classification (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ClassificationId	int	X
  	ClassificationName	nvarchar(200)
  FK	ParentId	int		X

  
  

  Indexes:

  
  

  • PK_VendorCategory

    • (Primary Key)
    • (Clustered)
    
    
    
    • ClassificationId
  
  

  • IX_Classification

    
    
    
    • ParentId
  
  

  References:

  
  

  • dbo.Classification

    
    
    
    • ClassificationId (ParentId)
    
    

  Referenced by:

  
  

  • dbo.Classification

    
    
    
    • ParentId (ClassificationId)
    
    

  • dbo.VendorClassification

    
    
    
    • ClassificationId
    
    

  Used by:

  
  

  • Procedure 

    dbo.GetVendorClassifications

    
    
    

• Table dbo.ContentItems (142 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ContentItemID	int	X
  	Content	nvarchar(max)		X
  FK	ContentTypeID	int
  	TabID	int
  	ModuleID	int
  	ContentKey	nvarchar(250)		X
  	Indexed	bit			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  FK	StateID	int		X

  
  

  Indexes:

  
  

  • PK_ContentItems

    • (Primary Key)
    • (Clustered)
    
    
    
    • ContentItemID
  
  

  • IX_ContentItems_TabID

    
    
    
    • TabID
  
  

  References:

  
  

  • dbo.ContentTypes

    
    
    
    • ContentTypeID
    
    

  • dbo.ContentWorkflowStates

    
    
    
    • StateID
    
    

  Referenced by:

  
  

  • dbo.ContentItems_MetaData

    
    
    
    • ContentItemID
    
    

  • dbo.ContentItems_Tags

    
    
    
    • ContentItemID
    
    

  • dbo.ContentWorkflowLogs

    
    
    
    • ContentItemID
    
    

  • dbo.Files

    
    
    
    • ContentItemID
    
    

  • dbo.Modules

    
    
    
    • ContentItemID
    
    

  • dbo.Tabs

    
    
    
    • ContentItemID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddContentItem

    
    
    
  • Procedure 

    dbo.AddTabAfter

    
    
    
  • Procedure 

    dbo.AddTabBefore

    
    
    
  • Procedure 

    dbo.AddTabToEnd

    
    
    
  • Procedure 

    dbo.DeleteContentItem

    
    
    
  • Procedure 

    dbo.DeleteTab

    
    
    
  • Procedure 

    dbo.DeleteTranslatedTabs

    
    
    
  • Procedure 

    dbo.GetContentItem

    
    
    
  • Procedure 

    dbo.GetContentItems

    
    
    
  • Procedure 

    dbo.GetContentItemsByContentType

    
    
    
  • Procedure 

    dbo.GetContentItemsByModuleId

    
    
    
  • Procedure 

    dbo.GetContentItemsByTabId

    
    
    
  • Procedure 

    dbo.GetContentItemsByTerm

    
    
    
  • Procedure 

    dbo.GetContentItemsByVocabularyId

    
    
    
  • Procedure 

    dbo.GetTerm

    
    
    
  • Procedure 

    dbo.GetTermUsage

    
    
    
  • Procedure 

    dbo.GetUnIndexedContentItems

    
    
    
  • Procedure 

    dbo.Journal_GetSearchItems

    
    
    
  • Procedure 

    dbo.UpdateContentItem

    
    
    
  • View 

    dbo.vw_DesktopModules

    
    
    
  • View 

    dbo.vw_Modules

    
    
    
  • View 

    dbo.vw_TabModules

    
    
    
  • View 

    dbo.vw_Tabs

    
    
    

• Table dbo.ContentItems_MetaData (13 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ContentItemMetaDataID	int	X
  FK	ContentItemID	int
  FK	MetaDataID	int
  	MetaDataValue	nvarchar(max)		X

  
  

  Indexes:

  
  

  • PK_Content_MetaData

    • (Primary Key)
    • (Clustered)
    
    
    
    • ContentItemMetaDataID
  
  

  References:

  
  

  • dbo.ContentItems

    
    
    
    • ContentItemID
    
    

  • dbo.MetaData

    
    
    
    • MetaDataID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddMetaData

    
    
    
  • Procedure 

    dbo.DeleteMetaData

    
    
    
  • Procedure 

    dbo.GetMetaData

    
    
    

• Table dbo.ContentItems_Tags (27 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ContentItemTagID	int	X
  UK , FK	ContentItemID	int
  UK , FK	TermID	int

  
  

  Indexes:

  
  

  • PK_ContentItems_Tags

    • (Primary Key)
    • (Clustered)
    
    
    
    • ContentItemTagID
  
  

  • IX_ContentItems_Tags

    • (Unique)
    
    
    
    • ContentItemID
    • TermID
  
  

  • IX_ContentItems_Tags_TermID

    
    
    
    • TermID
  
  

  References:

  
  

  • dbo.ContentItems

    
    
    
    • ContentItemID
    
    

  • dbo.Taxonomy_Terms

    
    
    
    • TermID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddTermToContent

    
    
    
  • Procedure 

    dbo.GetContentItemsByTerm

    
    
    
  • Procedure 

    dbo.GetContentItemsByVocabularyId

    
    
    
  • Procedure 

    dbo.GetTerm

    
    
    
  • Procedure 

    dbo.GetTermsByContent

    
    
    
  • Procedure 

    dbo.GetTermUsage

    
    
    
  • Procedure 

    dbo.RemoveTermsFromContent

    
    
    

• Table dbo.ContentTypes (6 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ContentTypeID	int	X
  UK	ContentType	nvarchar(100)

  
  

  Indexes:

  
  

  • PK_ContentTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • ContentTypeID
  
  

  • IX_ContentTypes_ContentType

    • (Unique)
    
    
    
    • ContentType
  
  

  Referenced by:

  
  

  • dbo.ContentItems

    
    
    
    • ContentTypeID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddContentType

    
    
    
  • Procedure 

    dbo.DeleteContentType

    
    
    
  • Procedure 

    dbo.GetContentTypes

    
    
    
  • Procedure 

    dbo.UpdateContentType

    
    
    

• Table dbo.ContentWorkflowLogs (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	WorkflowLogID	int	X
  	Action	nvarchar(40)
  	Comment	nvarchar(256)
  	Date	datetime
  	User	int
  FK	WorkflowID	int
  FK	ContentItemID	int

  
  

  Indexes:

  
  

  • PK_ContentWorkflowLogs

    • (Primary Key)
    • (Clustered)
    
    
    
    • WorkflowLogID
  
  

  References:

  
  

  • dbo.ContentItems

    
    
    
    • ContentItemID
    
    

  • dbo.ContentWorkflows

    
    
    
    • WorkflowID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddContentWorkflowLog

    
    
    
  • Procedure 

    dbo.DeleteContentWorkflowLogs

    
    
    
  • Procedure 

    dbo.GetContentWorkflowLogs

    
    
    

• Table dbo.ContentWorkflows (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	WorkflowID	int	X
  UK	PortalID	int		X
  UK	WorkflowName	nvarchar(40)
  	Description	nvarchar(256)		X
  	IsDeleted	bit
  	StartAfterCreating	bit
  	StartAfterEditing	bit
  	DispositionEnabled	bit

  
  

  Indexes:

  
  

  • PK_ContentWorkflows

    • (Primary Key)
    • (Clustered)
    
    
    
    • WorkflowID
  
  

  • IX_ContentWorkflows

    • (Unique)
    
    
    
    • PortalID
    • WorkflowName
  
  

  Referenced by:

  
  

  • dbo.ContentWorkflowLogs

    
    
    
    • WorkflowID
    
    

  • dbo.ContentWorkflowSources

    
    
    
    • WorkflowID
    
    

  • dbo.ContentWorkflowStates

    
    
    
    • WorkflowID
    
    

  • dbo.Folders

    
    
    
    • WorkflowID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddContentWorkflow

    
    
    
  • Procedure 

    dbo.GetContentWorkflow

    
    
    
  • Procedure 

    dbo.GetContentWorkflows

    
    
    
  • Procedure 

    dbo.UpdateContentWorkflow

    
    
    

• Table dbo.ContentWorkflowSources (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SourceID	int	X
  UK , FK	WorkflowID	int
  UK	SourceName	nvarchar(20)
  	SourceType	nvarchar(250)

  
  

  Indexes:

  
  

  • PK_ContentWorkflowSources

    • (Primary Key)
    • (Clustered)
    
    
    
    • SourceID
  
  

  • IX_ContentWorkflowSources

    • (Unique)
    
    
    
    • WorkflowID
    • SourceName
  
  

  References:

  
  

  • dbo.ContentWorkflows

    
    
    
    • WorkflowID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddContentWorkflowSource

    
    
    
  • Procedure 

    dbo.GetContentWorkflowSource

    
    
    

• Table dbo.ContentWorkflowStatePermission (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	WorkflowStatePermissionID	int	X
  UK , FK	StateID	int
  UK , FK	PermissionID	int
  	AllowAccess	bit
  UK	RoleID	int		X
  UK , FK	UserID	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_ContentWorkflowStatePermission

    • (Primary Key)
    • (Clustered)
    
    
    
    • WorkflowStatePermissionID
  
  

  • IX_ContentWorkflowStatePermission

    • (Unique)
    
    
    
    • StateID
    • PermissionID
    • RoleID
    • UserID
  
  

  References:

  
  

  • dbo.ContentWorkflowStates

    
    
    
    • StateID
    
    

  • dbo.Permission

    
    
    
    • PermissionID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddContentWorkflowStatePermission

    
    
    
  • Procedure 

    dbo.DeleteContentWorkflowStatePermission

    
    
    
  • Procedure 

    dbo.UpdateContentWorkflowStatePermission

    
    
    
  • View 

    dbo.vw_ContentWorkflowStatePermissions

    
    
    

• Table dbo.ContentWorkflowStates (3 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	StateID	int	X
  UK , FK	WorkflowID	int
  UK	StateName	nvarchar(40)
  	Order	int
  	IsActive	bit
  	SendEmail	bit
  	SendMessage	bit
  	IsDisposalState	bit
  	OnCompleteMessageSubject	nvarchar(256)
  	OnCompleteMessageBody	nvarchar(1024)
  	OnDiscardMessageSubject	nvarchar(256)
  	OnDiscardMessageBody	nvarchar(1024)

  
  

  Indexes:

  
  

  • PK_ContentWorkflowStates

    • (Primary Key)
    • (Clustered)
    
    
    
    • StateID
  
  

  • IX_ContentWorkflowStates

    • (Unique)
    
    
    
    • WorkflowID
    • StateName
  
  

  References:

  
  

  • dbo.ContentWorkflows

    
    
    
    • WorkflowID
    
    

  Referenced by:

  
  

  • dbo.ContentItems

    
    
    
    • StateID
    
    

  • dbo.ContentWorkflowStatePermission

    
    
    
    • StateID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddContentWorkflowState

    
    
    
  • Procedure 

    dbo.DeleteContentWorkflowState

    
    
    
  • Procedure 

    dbo.GetContentWorkflowState

    
    
    
  • Procedure 

    dbo.GetContentWorkflowStates

    
    
    
  • Procedure 

    dbo.UpdateContentWorkflowState

    
    
    

• Table dbo.CoreMessaging_MessageAttachments (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	MessageAttachmentID	int	X
  FK	MessageID	int
  	FileID	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_CoreMessaging_MessageAttachments

    • (Primary Key)
    • (Clustered)
    
    
    
    • MessageAttachmentID
  
  

  • IX_CoreMessaging_MessageAttachments_MessageID

    
    
    
    • MessageID
  
  

  References:

  
  

  • dbo.CoreMessaging_Messages

    
    
    
    • MessageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_DeleteMessageAttachment

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetArchiveBox

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageAttachment

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageAttachmentsByMessage

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageThread

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetSentBox

    
    
    
  • Procedure 

    dbo.CoreMessaging_SaveMessageAttachment

    
    
    

• Table dbo.CoreMessaging_MessageRecipients (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	RecipientID	int	X
  FK	MessageID	int
  	UserID	int
  	Read	bit			0
  	Archived	bit			0
  	EmailSent	bit			0
  	EmailSentDate	datetime		X
  	EmailSchedulerInstance	uniqueidentifier		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	SendToast	bit			0

  
  

  Indexes:

  
  

  • PK_CoreMessaging_MessageRecipients

    • (Primary Key)
    • (Clustered)
    
    
    
    • RecipientID
  
  

  • IX_CoreMessaging_MessageRecipients_UserID

    
    
    
    • UserID
    • Read (Descending)
    • Archived
  
  

  References:

  
  

  • dbo.CoreMessaging_Messages

    
    
    
    • MessageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_ConvertLegacyMessages

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountArchivedConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountArchivedMessages

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountArchivedMessagesByConversation

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountNewThreads

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountNotifications

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountSentConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountTotalConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_CreateMessageRecipientsForRole

    
    
    
  • Procedure 

    dbo.CoreMessaging_CreateMessageReply

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteMessageRecipient

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteMessageRecipientByMessageAndUser

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteUserFromConversation

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetArchiveBox

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageRecipient

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageRecipientsByMessage

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageRecipientsByMessageAndUser

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageRecipientsByUser

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageThread

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNextMessagesForDigestDispatch

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNextMessagesForInstantDispatch

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotifications

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetSentBox

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetToasts

    
    
    
  • Procedure 

    dbo.CoreMessaging_IsToastPending

    
    
    
  • Procedure 

    dbo.CoreMessaging_MarkMessageAsDispatched

    
    
    
  • Procedure 

    dbo.CoreMessaging_MarkMessageAsSent

    
    
    
  • Procedure 

    dbo.CoreMessaging_MarkReadyForToast

    
    
    
  • Procedure 

    dbo.CoreMessaging_MarkToastSent

    
    
    
  • Procedure 

    dbo.CoreMessaging_SaveMessageRecipient

    
    
    
  • Procedure 

    dbo.CoreMessaging_UpdateMessageArchivedStatus

    
    
    
  • Procedure 

    dbo.CoreMessaging_UpdateMessageReadStatus

    
    
    
  • View 

    dbo.vw_CoreMessaging_Messages

    
    
    
  • View 

    dbo.vw_MessagesForDispatch

    
    
    

• Table dbo.CoreMessaging_Messages (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	MessageID	int	X
  	PortalID	int		X
  FK	NotificationTypeID	int		X
  	To	nvarchar(2000)		X
  	From	nvarchar(200)		X
  	Subject	nvarchar(400)		X
  	Body	nvarchar(max)		X
  	ConversationID	int		X
  	ReplyAllAllowed	bit		X
  	SenderUserID	int		X
  	ExpirationDate	datetime		X
  	Context	nvarchar(200)		X
  	IncludeDismissAction	bit		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_CoreMessaging_Messages

    • (Primary Key)
    • (Clustered)
    
    
    
    • MessageID
  
  

  • IX_CoreMessaging_Messages_SenderUserID

    
    
    
    • SenderUserID
    • CreatedOnDate (Descending)
  
  

  References:

  
  

  • dbo.CoreMessaging_NotificationTypes

    
    
    
    • NotificationTypeID
    
    

  Referenced by:

  
  

  • dbo.CoreMessaging_MessageAttachments

    
    
    
    • MessageID
    
    

  • dbo.CoreMessaging_MessageRecipients

    
    
    
    • MessageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_ConvertLegacyMessages

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountArchivedConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountArchivedMessages

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountArchivedMessagesByConversation

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountMessagesByConversation

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountNewThreads

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountNotifications

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountSentConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountSentMessages

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountTotalConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_CreateMessageReply

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteMessage

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteNotification

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteNotificationType

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteUserFromConversation

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetArchiveBox

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetLastSentMessage

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessage

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageConversations

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessagesBySender

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetMessageThread

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNextMessagesForDigestDispatch

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNextMessagesForInstantDispatch

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotification

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotificationByContext

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotifications

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetSentBox

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetToasts

    
    
    
  • Procedure 

    dbo.CoreMessaging_SaveMessage

    
    
    
  • Procedure 

    dbo.CoreMessaging_SendNotification

    
    
    
  • Procedure 

    dbo.CoreMessaging_UpdateMessageArchivedStatus

    
    
    
  • Procedure 

    dbo.CoreMessaging_UpdateMessageReadStatus

    
    
    
  • View 

    dbo.vw_CoreMessaging_Messages

    
    
    
  • View 

    dbo.vw_MessagesForDispatch

    
    
    

• Table dbo.CoreMessaging_NotificationTypeActions (7 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	NotificationTypeActionID	int	X
  FK	NotificationTypeID	int
  	NameResourceKey	nvarchar(100)
  	DescriptionResourceKey	nvarchar(100)		X
  	ConfirmResourceKey	nvarchar(100)		X
  	Order	int
  	APICall	nvarchar(500)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_CoreMessaging_NotificationTypeActions

    • (Primary Key)
    • (Clustered)
    
    
    
    • NotificationTypeActionID
  
  

  • IX_CoreMessaging_NotificationTypeActions

    
    
    
    • NotificationTypeID
  
  

  References:

  
  

  • dbo.CoreMessaging_NotificationTypes

    
    
    
    • NotificationTypeID
    
    

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_AddNotificationTypeAction

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteNotificationType

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteNotificationTypeAction

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotificationTypeAction

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotificationTypeActionByName

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotificationTypeActions

    
    
    

• Table dbo.CoreMessaging_NotificationTypes (15 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	NotificationTypeID	int	X
  UK	Name	nvarchar(100)
  	Description	nvarchar(2000)		X
  	TTL	int		X
  FK	DesktopModuleID	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_CoreMessaging_NotificationTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • NotificationTypeID
  
  

  • IX_CoreMessaging_NotificationTypes

    • (Unique)
    
    
    
    • Name
  
  

  References:

  
  

  • dbo.DesktopModules

    
    
    
    • DesktopModuleID
    
    

  Referenced by:

  
  

  • dbo.CoreMessaging_Messages

    
    
    
    • NotificationTypeID
    
    

  • dbo.CoreMessaging_NotificationTypeActions

    
    
    
    • NotificationTypeID
    
    

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_CreateNotificationType

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteNotificationType

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotificationType

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetNotificationTypeByName

    
    
    

• Table dbo.CoreMessaging_Subscriptions (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SubscriptionId	int	X
  FK	UserId	int
  FK	PortalId	int		X
  FK	SubscriptionTypeId	int
  	ObjectKey	nvarchar(255)		X
  	ObjectData	nvarchar(max)		X
  	Description	nvarchar(255)
  	CreatedOnDate	datetime
  FK	ModuleId	int		X
  	TabId	int		X

  
  

  Indexes:

  
  

  • PK_CoreMessaging_Subscriptions

    • (Primary Key)
    • (Clustered)
    
    
    
    • SubscriptionId
  
  

  References:

  
  

  • dbo.Modules

    
    
    
    • ModuleID (ModuleId)
    
    

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  • dbo.CoreMessaging_SubscriptionTypes

    
    
    
    • SubscriptionTypeId
    
    

  • dbo.Users

    
    
    
    • UserID (UserId)
    
    

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_AddSubscription

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteSubscription

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetSubscriptionsByContent

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetSubscriptionsByUser

    
    
    
  • Procedure 

    dbo.CoreMessaging_IsSubscribed

    
    
    
  • Procedure 

    dbo.CoreMessaging_UpdateSubscriptionDescription

    
    
    

• Table dbo.CoreMessaging_SubscriptionTypes (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SubscriptionTypeId	int	X
  	SubscriptionName	nvarchar(50)
  	FriendlyName	nvarchar(50)
  	DesktopModuleId	int		X

  
  

  Indexes:

  
  

  • PK_CoreMessaging_SubscriptionTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • SubscriptionTypeId
  
  

  Referenced by:

  
  

  • dbo.CoreMessaging_Subscriptions

    
    
    
    • SubscriptionTypeId
    
    

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_AddSubscriptionType

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteSubscriptionType

    
    
    
  • Procedure 

    dbo.CoreMessaging_GetSubscriptionTypes

    
    
    

• Table dbo.CoreMessaging_UserPreferences (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UserPreferenceId	int	X
  	PortalId	int
  	UserId	int
  	MessagesEmailFrequency	int
  	NotificationsEmailFrequency	int

  
  

  Indexes:

  
  

  • PK_CoreMessaging_UserPreferences

    • (Primary Key)
    • (Clustered)
    
    
    
    • UserPreferenceId
  
  

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_GetUserPreference

    
    
    
  • Procedure 

    dbo.CoreMessaging_SetUserPreference

    
    
    
  • View 

    dbo.vw_MessagesForDispatch

    
    
    

• Table dbo.Dashboard_Controls (6 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	DashboardControlID	int	X
  	DashboardControlKey	nvarchar(50)
  	IsEnabled	bit
  	DashboardControlSrc	nvarchar(250)
  	DashboardControlLocalResources	nvarchar(250)
  	ControllerClass	nvarchar(250)		X
  	ViewOrder	int			0
  FK	PackageID	int			-1

  
  

  Indexes:

  
  

  • PK_Dashboard

    • (Primary Key)
    • (Clustered)
    
    
    
    • DashboardControlID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.Dashboard_AddControl

    
    
    
  • Procedure 

    dbo.Dashboard_DeleteControl

    
    
    
  • Procedure 

    dbo.Dashboard_GetControls

    
    
    
  • Procedure 

    dbo.Dashboard_GetDashboardControlByKey

    
    
    
  • Procedure 

    dbo.Dashboard_GetDashboardControlByPackageId

    
    
    
  • Procedure 

    dbo.Dashboard_UpdateControl

    
    
    

• Table dbo.DesktopModulePermission (29 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	DesktopModulePermissionID	int	X
  UK , FK	PortalDesktopModuleID	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_DesktopModulePermission

    • (Primary Key)
    • (Clustered)
    
    
    
    • DesktopModulePermissionID
  
  

  • IX_DesktopModulePermission_DesktopModules

    • (Unique)
    
    
    
    • PortalDesktopModuleID
    • PermissionID
    • RoleID
    • UserID
    • AllowAccess (Included)
  
  

  • IX_DesktopModulePermission_Roles

    • (Unique)
    
    
    
    • RoleID
    • PortalDesktopModuleID
    • PermissionID
    • AllowAccess (Included)
  
  

  • IX_DesktopModulePermission_Users

    • (Unique)
    
    
    
    • UserID
    • PortalDesktopModuleID
    • PermissionID
    • AllowAccess (Included)
  
  

  References:

  
  

  • dbo.Permission

    
    
    
    • PermissionID
    
    

  • dbo.PortalDesktopModules

    
    
    
    • PortalDesktopModuleID
    
    

  • dbo.Roles

    
    
    
    • RoleID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddDesktopModulePermission

    
    
    
  • Procedure 

    dbo.DeleteDesktopModulePermission

    
    
    
  • Procedure 

    dbo.DeleteDesktopModulePermissionsByPortalDesktopModuleID

    
    
    
  • Procedure 

    dbo.DeleteDesktopModulePermissionsByUserID

    
    
    
  • Procedure 

    dbo.DeleteRole

    
    
    
  • Procedure 

    dbo.UpdateDesktopModulePermission

    
    
    
  • View 

    dbo.vw_DesktopModulePermissions

    
    
    

• Table dbo.DesktopModules (45 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	DesktopModuleID	int	X
  	FriendlyName	nvarchar(128)
  	Description	nvarchar(2000)		X
  	Version	nvarchar(8)		X
  	IsPremium	bit
  	IsAdmin	bit
  	BusinessControllerClass	nvarchar(200)		X
  	FolderName	nvarchar(128)
  UK	ModuleName	nvarchar(128)
  	SupportedFeatures	int			0
  	CompatibleVersions	nvarchar(500)		X
  	Dependencies	nvarchar(400)		X
  	Permissions	nvarchar(400)		X
  FK	PackageID	int			-1
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	ContentItemId	int			-1
  	Shareable	int			0

  
  

  Indexes:

  
  

  • PK_DesktopModules

    • (Primary Key)
    • (Clustered)
    
    
    
    • DesktopModuleID
  
  

  • IX_DesktopModules_ModuleName

    • (Unique)
    
    
    
    • ModuleName
  
  

  • IX_DesktopModules_FriendlyName

    
    
    
    • FriendlyName
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Referenced by:

  
  

  • dbo.CoreMessaging_NotificationTypes

    
    
    
    • DesktopModuleID
    
    

  • dbo.ModuleDefinitions

    
    
    
    • DesktopModuleID
    
    

  • dbo.PortalDesktopModules

    
    
    
    • DesktopModuleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddDesktopModule

    
    
    
  • Procedure 

    dbo.Dashboard_GetInstalledModules

    
    
    
  • Procedure 

    dbo.DeleteDesktopModule

    
    
    
  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    
  • Procedure 

    dbo.GetModulePackagesInUse

    
    
    
  • Procedure 

    dbo.GetPortalDesktopModules

    
    
    
  • Procedure 

    dbo.GetTabsByPackageID

    
    
    
  • Procedure 

    dbo.UpdateDesktopModule

    
    
    
  • View 

    dbo.vw_DesktopModules

    
    
    
  • View 

    dbo.vw_Modules

    
    
    
  • View 

    dbo.vw_TabModules

    
    
    

• Table dbo.EventLog (25 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  	LogGUID	varchar(36)
  FK	LogTypeKey	nvarchar(35)
  FK	LogConfigID	int		X
  	LogUserID	int		X
  	LogUserName	nvarchar(50)		X
  	LogPortalID	int		X
  	LogPortalName	nvarchar(100)		X
  	LogCreateDate	datetime
  	LogServerName	nvarchar(50)
  	LogProperties	ntext
  	LogNotificationPending	bit		X
  PK	LogEventID	bigint	X

  
  

  Indexes:

  
  

  • PK_EventLogMaster

    • (Primary Key)
    • (Clustered)
    
    
    
    • LogEventID
  
  

  • IX_EventLog_LogConfigID

    
    
    
    • LogConfigID
    • LogNotificationPending
    • LogCreateDate
    • LogEventID (Included)
  
  

  • IX_EventLog_LogCreateDate

    
    
    
    • LogCreateDate
    • LogConfigID (Included)
  
  

  • IX_EventLog_LogGUID

    
    
    
    • LogGUID
  
  

  • IX_EventLog_LogType

    
    
    
    • LogTypeKey
    • LogPortalID
  
  

  References:

  
  

  • dbo.EventLogConfig

    
    
    
    • ID (LogConfigID)
    
    

  • dbo.EventLogTypes

    
    
    
    • LogTypeKey
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddEventLog

    
    
    
  • Procedure 

    dbo.DeleteEventLog

    
    
    
  • Procedure 

    dbo.GetEventLog

    
    
    
  • Procedure 

    dbo.GetEventLogByLogGUID

    
    
    
  • Procedure 

    dbo.GetEventLogPendingNotif

    
    
    
  • Procedure 

    dbo.GetEventLogPendingNotifConfig

    
    
    
  • Procedure 

    dbo.PurgeEventLog

    
    
    
  • Procedure 

    dbo.UpdateEventLogPendingNotif

    
    
    

• Table dbo.EventLogConfig (119 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ID	int	X
  UK , FK	LogTypeKey	nvarchar(35)		X
  UK	LogTypePortalID	int		X
  	LoggingIsActive	bit
  	KeepMostRecent	int
  	EmailNotificationIsActive	bit
  	NotificationThreshold	int		X
  	NotificationThresholdTime	int		X
  	NotificationThresholdTimeType	int		X
  	MailFromAddress	nvarchar(50)
  	MailToAddress	nvarchar(50)

  
  

  Indexes:

  
  

  • PK_EventLogConfig

    • (Primary Key)
    • (Clustered)
    
    
    
    • ID
  
  

  • IX_LogTypeKey_LogTypePortalID

    • (Unique)
    
    
    
    • LogTypeKey
    • LogTypePortalID
  
  

  References:

  
  

  • dbo.EventLogTypes

    
    
    
    • LogTypeKey
    
    

  Referenced by:

  
  

  • dbo.EventLog

    
    
    
    • LogConfigID (ID)
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddEventLog

    
    
    
  • Procedure 

    dbo.AddEventLogConfig

    
    
    
  • Procedure 

    dbo.DeleteEventLogConfig

    
    
    
  • Procedure 

    dbo.GetEventLogConfig

    
    
    
  • Procedure 

    dbo.GetEventLogPendingNotifConfig

    
    
    
  • Procedure 

    dbo.PurgeEventLog

    
    
    
  • Procedure 

    dbo.SaveCoreAuditTypes

    
    
    
  • Procedure 

    dbo.UpdateEventLogConfig

    
    
    

• Table dbo.EventLogTypes (146 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	LogTypeKey	nvarchar(35)
  	LogTypeFriendlyName	nvarchar(50)
  	LogTypeDescription	nvarchar(128)
  	LogTypeOwner	nvarchar(100)
  	LogTypeCSSClass	nvarchar(40)

  
  

  Indexes:

  
  

  • PK_EventLogTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • LogTypeKey
  
  

  Referenced by:

  
  

  • dbo.EventLog

    
    
    
    • LogTypeKey
    
    

  • dbo.EventLogConfig

    
    
    
    • LogTypeKey
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddEventLog

    
    
    
  • Procedure 

    dbo.AddEventLogType

    
    
    
  • Procedure 

    dbo.DeleteEventLogType

    
    
    
  • Procedure 

    dbo.GetEventLogConfig

    
    
    
  • Procedure 

    dbo.GetEventLogType

    
    
    
  • Procedure 

    dbo.SaveCoreAuditTypes

    
    
    
  • Procedure 

    dbo.UpdateEventLogType

    
    
    

• Table dbo.EventQueue (15 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	EventMessageID	int	X
  	EventName	nvarchar(100)
  	Priority	int
  	ProcessorType	nvarchar(250)
  	ProcessorCommand	nvarchar(250)
  	Body	nvarchar(250)
  	Sender	nvarchar(250)
  	Subscriber	nvarchar(100)
  	AuthorizedRoles	nvarchar(250)
  	ExceptionMessage	nvarchar(250)
  	SentDate	datetime
  	ExpirationDate	datetime
  	Attributes	ntext
  	IsComplete	bit			0

  
  

  Indexes:

  
  

  • PK_EventQueue

    • (Primary Key)
    • (Clustered)
    
    
    
    • EventMessageID
  
  

  Used by:

  
  

  • Procedure 

    dbo.AddEventMessage

    
    
    
  • Procedure 

    dbo.GetEventMessages

    
    
    
  • Procedure 

    dbo.GetEventMessagesBySubscriber

    
    
    
  • Procedure 

    dbo.SetEventMessageComplete

    
    
    

• Table dbo.ExtensionUrlProviderConfiguration (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ExtensionUrlProviderID	int
  PK	PortalID	int

  
  

  Indexes:

  
  

  • PK_ExtensionUrlProviderConfiguration

    • (Primary Key)
    • (Clustered)
    
    
    
    • ExtensionUrlProviderID
    • PortalID
  
  

  Used by:

  
  

  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    
  • View 

    dbo.vw_ExtensionUrlProviders

    
    
    

• Table dbo.ExtensionUrlProviders (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ExtensionUrlProviderID	int	X
  	ProviderName	nvarchar(150)
  	ProviderType	nvarchar(1000)
  	SettingsControlSrc	nvarchar(1000)		X
  	IsActive	bit
  	RewriteAllUrls	bit
  	RedirectAllUrls	bit
  	ReplaceAllUrls	bit
  	DesktopModuleId	int		X

  
  

  Indexes:

  
  

  • PK_ExtensionUrlProviders

    • (Primary Key)
    • (Clustered)
    
    
    
    • ExtensionUrlProviderID
  
  

  Used by:

  
  

  • Procedure 

    dbo.AddExtensionUrlProvider

    
    
    
  • Procedure 

    dbo.DeleteExtensionUrlProvider

    
    
    
  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    
  • Procedure 

    dbo.UpdateExtensionUrlProvider

    
    
    
  • View 

    dbo.vw_ExtensionUrlProviders

    
    
    

• Table dbo.ExtensionUrlProviderSetting (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ExtensionUrlProviderID	int
  PK	PortalID	int
  PK	SettingName	nvarchar(100)
  	SettingValue	nvarchar(2000)

  
  

  Indexes:

  
  

  • PK_ExtensionUrlProviderSetting

    • (Primary Key)
    • (Clustered)
    
    
    
    • ExtensionUrlProviderID
    • PortalID
    • SettingName
  
  

  Used by:

  
  

  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    
  • Procedure 

    dbo.SaveExtensionUrlProviderSetting

    
    
    

• Table dbo.ExtensionUrlProviderTab (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ExtensionUrlProviderID	int
  PK	PortalID	int
  PK	TabID	int
  	IsActive	bit

  
  

  Indexes:

  
  

  • PK_ExtensionUrlProviderTab

    • (Primary Key)
    • (Clustered)
    
    
    
    • ExtensionUrlProviderID
    • PortalID
    • TabID
  
  

  Used by:

  
  

  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    

• Table dbo.Files (200 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	FileId	int	X
  UK , FK	PortalId	int		X
  UK	FileName	nvarchar(246)
  	Extension	nvarchar(100)
  	Size	int
  	Width	int		X
  	Height	int		X
  	ContentType	nvarchar(200)
  UK , FK	FolderID	int
  	Content	image		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  UK	UniqueId	uniqueidentifier			newid()
  	VersionGuid	uniqueidentifier			newid()
  	SHA1Hash	varchar(40)		X
  	LastModificationTime	datetime			getdate()
  	Folder	nvarchar(246)		X
  	Title	nvarchar(256)		X
  	StartDate	date			getdate()
  	EnablePublishPeriod	bit			0
  	EndDate	date		X
  	PublishedVersion	int			1
  FK	ContentItemID	int		X

  
  

  Indexes:

  
  

  • PK_File

    • (Primary Key)
    • (Clustered)
    
    
    
    • FileId
  
  

  • IX_Files_PortalID

    • (Unique)
    
    
    
    • PortalId
    • FolderID
    • FileName
    • FileId (Included)
    • PublishedVersion (Included)
  
  

  • IX_Files_UniqueId

    • (Unique)
    
    
    
    • UniqueId
  
  

  • IX_Files_ContentID

    
    
    
    • ContentItemID
    • FileId (Included)
    • FolderID (Included)
    • FileName (Included)
    • PublishedVersion (Included)
  
  

  • IX_Files_FileID

    
    
    
    • FileId
    • PortalId (Included)
    • FolderID (Included)
    • FileName (Included)
    • PublishedVersion (Included)
  
  

  References:

  
  

  • dbo.ContentItems

    
    
    
    • ContentItemID
    
    

  • dbo.Folders

    
    
    
    • FolderID
    
    

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  Referenced by:

  
  

  • dbo.FileVersions

    
    
    
    • FileId
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddFile

    
    
    
  • Procedure 

    dbo.AddFileVersion

    
    
    
  • Procedure 

    dbo.ClearFileContent

    
    
    
  • Procedure 

    dbo.CountLegacyFiles

    
    
    
  • Procedure 

    dbo.DeleteFile

    
    
    
  • Procedure 

    dbo.DeleteFiles

    
    
    
  • Procedure 

    dbo.DeleteFileVersion

    
    
    
  • Procedure 

    dbo.GetBanner

    
    
    
  • Procedure 

    dbo.GetFileByUniqueID

    
    
    
  • Procedure 

    dbo.GetFileContent

    
    
    
  • Procedure 

    dbo.GetFileVersionsInFolder

    
    
    
  • Procedure 

    dbo.GetPortalSpaceUsed

    
    
    
  • Procedure 

    dbo.GetVendor

    
    
    
  • Procedure 

    dbo.ResetFilePublishedVersion

    
    
    
  • Procedure 

    dbo.SetPublishedVersion

    
    
    
  • Procedure 

    dbo.UpdateFile

    
    
    
  • Procedure 

    dbo.UpdateFileContent

    
    
    
  • Procedure 

    dbo.UpdateFileHashCode

    
    
    
  • Procedure 

    dbo.UpdateFileLastModificationTime

    
    
    
  • Procedure 

    dbo.UpdateFileVersion

    
    
    
  • View 

    dbo.vw_Files

    
    
    

• Table dbo.FileVersions (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	FileId	int
  PK	Version	int
  	FileName	nvarchar(246)
  	Extension	nvarchar(100)
  	Size	int
  	Width	int		X
  	Height	int		X
  	ContentType	nvarchar(200)
  	Content	image		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	SHA1Hash	varchar(40)		X

  
  

  Indexes:

  
  

  • PK_FileVersions

    • (Primary Key)
    • (Clustered)
    
    
    
    • FileId
    • Version
  
  

  References:

  
  

  • dbo.Files

    
    
    
    • FileId
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddFileVersion

    
    
    
  • Procedure 

    dbo.DeleteFileVersion

    
    
    
  • Procedure 

    dbo.GetFileVersion

    
    
    
  • Procedure 

    dbo.GetFileVersionContent

    
    
    
  • Procedure 

    dbo.GetFileVersions

    
    
    
  • Procedure 

    dbo.GetFileVersionsInFolder

    
    
    
  • Procedure 

    dbo.SetPublishedVersion

    
    
    

• Table dbo.FolderMappings (6 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	FolderMappingID	int	X
  UK , FK	PortalID	int		X
  UK	MappingName	nvarchar(50)
  	FolderProviderType	nvarchar(50)
  	Priority	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_FolderMappings

    • (Primary Key)
    • (Clustered)
    
    
    
    • FolderMappingID
  
  

  • IX_FolderMappings

    • (Unique)
    
    
    
    • PortalID
    • MappingName
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Referenced by:

  
  

  • dbo.FolderMappingsSettings

    
    
    
    • FolderMappingID
    
    

  • dbo.Folders

    
    
    
    • FolderMappingID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddDefaultFolderTypes

    
    
    
  • Procedure 

    dbo.AddFolder

    
    
    
  • Procedure 

    dbo.AddFolderMapping

    
    
    
  • Procedure 

    dbo.DeleteFolderMapping

    
    
    
  • Procedure 

    dbo.GetFolderMapping

    
    
    
  • Procedure 

    dbo.GetFolderMappingByMappingName

    
    
    
  • Procedure 

    dbo.GetFolderMappings

    
    
    
  • Procedure 

    dbo.UpdateFolderMapping

    
    
    

• Table dbo.FolderMappingsSettings (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	FolderMappingID	int
  PK	SettingName	nvarchar(50)
  	SettingValue	nvarchar(2000)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_FolderMappingsSettings

    • (Primary Key)
    • (Clustered)
    
    
    
    • FolderMappingID
    • SettingName
  
  

  References:

  
  

  • dbo.FolderMappings

    
    
    
    • FolderMappingID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddFolderMappingsSetting

    
    
    
  • Procedure 

    dbo.GetFolderMappingsSetting

    
    
    
  • Procedure 

    dbo.GetFolderMappingsSettings

    
    
    
  • Procedure 

    dbo.UpdateFolderMappingsSetting

    
    
    

• Table dbo.FolderPermission (20 rows)

  
  

  	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)
    
    
    
    • FolderPermissionID
  
  

  • IX_FolderPermission_Folders

    • (Unique)
    
    
    
    • FolderID
    • PermissionID
    • RoleID
    • UserID
    • AllowAccess (Included)
  
  

  • IX_FolderPermission_Roles

    • (Unique)
    
    
    
    • RoleID
    • FolderID
    • PermissionID
    • AllowAccess (Included)
  
  

  • IX_FolderPermission_Users

    • (Unique)
    
    
    
    • UserID
    • FolderID
    • PermissionID
    • AllowAccess (Included)
  
  

  • IX_FolderPermission_Modules

    
    
    
    • FolderID
  
  

  • IX_FolderPermission_Permission

    
    
    
    • PermissionID
  
  

  References:

  
  

  • dbo.Folders

    
    
    
    • FolderID
    
    

  • dbo.Permission

    
    
    
    • PermissionID
    
    

  • dbo.Roles

    
    
    
    • RoleID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddFolderPermission

    
    
    
  • Procedure 

    dbo.DeleteFolderPermission

    
    
    
  • Procedure 

    dbo.DeleteFolderPermissionsByFolderPath

    
    
    
  • Procedure 

    dbo.DeleteFolderPermissionsByUserID

    
    
    
  • Procedure 

    dbo.DeleteRole

    
    
    
  • Procedure 

    dbo.UpdateFolderPermission

    
    
    
  • View 

    dbo.vw_FolderPermissions

    
    
    

• Table dbo.Folders (45 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, UK	FolderID	int	X
  UK , FK	PortalID	int		X
  UK	FolderPath	nvarchar(300)
  	StorageLocation	int			0
  	IsProtected	bit			0
  	IsCached	bit			0
  	LastUpdated	datetime		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  UK	UniqueId	uniqueidentifier			newid()
  	VersionGuid	uniqueidentifier			newid()
  FK	FolderMappingID	int
  	ParentID	int		X
  	IsVersioned	bit			0
  FK	WorkflowID	int		X
  	MappedPath	nvarchar(300)		X

  
  

  Indexes:

  
  

  • PK_Folders

    • (Primary Key)
    • (Clustered)
    
    
    
    • FolderID
  
  

  • IX_FolderPath

    • (Unique)
    
    
    
    • PortalID
    • FolderPath
  
  

  • IX_Folders_FolderID

    • (Unique)
    
    
    
    • FolderID
    • PortalID (Included)
    • FolderPath (Included)
    • StorageLocation (Included)
    • IsCached (Included)
    • FolderMappingID (Included)
  
  

  • IX_Folders_UniqueId

    • (Unique)
    
    
    
    • UniqueId
  
  

  • IX_Folders_ParentID

    
    
    
    • PortalID
    • ParentID
    • FolderPath
    • FolderID (Included)
  
  

  References:

  
  

  • dbo.ContentWorkflows

    
    
    
    • WorkflowID
    
    

  • dbo.FolderMappings

    
    
    
    • FolderMappingID
    
    

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Referenced by:

  
  

  • dbo.Files

    
    
    
    • FolderID
    
    

  • dbo.FolderPermission

    
    
    
    • FolderID
    
    

  Used by:

  
  

  • Function 

    dbo.GetFileFolderFunc

    
    
    
  • Procedure 

    dbo.AddFolder

    
    
    
  • Procedure 

    dbo.DeleteFolder

    
    
    
  • Procedure 

    dbo.DeleteFolderPermissionsByFolderPath

    
    
    
  • Procedure 

    dbo.DeleteFolderPermissionsByUserID

    
    
    
  • Procedure 

    dbo.GetBanner

    
    
    
  • Procedure 

    dbo.GetFolderByFolderID

    
    
    
  • Procedure 

    dbo.GetFolderByFolderPath

    
    
    
  • Procedure 

    dbo.GetFolderByUniqueID

    
    
    
  • Procedure 

    dbo.GetFolders

    
    
    
  • Procedure 

    dbo.GetFoldersByPermissions

    
    
    
  • Procedure 

    dbo.GetLegacyFolderCount

    
    
    
  • Procedure 

    dbo.GetVendor

    
    
    
  • Procedure 

    dbo.UpdateFolder

    
    
    
  • Procedure 

    dbo.UpdateFolderVersion

    
    
    
  • Procedure 

    dbo.UpdateLegacyFolders

    
    
    
  • View 

    dbo.vw_Files

    
    
    
  • View 

    dbo.vw_FolderPermissions

    
    
    

• Table dbo.HostSettings (60 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SettingName	nvarchar(50)
  	SettingValue	nvarchar(256)
  	SettingIsSecure	bit			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_HostSettings

    • (Primary Key)
    • (Clustered)
    
    
    
    • SettingName
  
  

  Used by:

  
  

  • Procedure 

    dbo.AddHostSetting

    
    
    
  • Procedure 

    dbo.GetHostSetting

    
    
    
  • Procedure 

    dbo.GetHostSettings

    
    
    
  • Procedure 

    dbo.UpdateHostSetting

    
    
    

• Table dbo.HtmlText (3 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  FK	ModuleID	int
  PK	ItemID	int	X
  	Content	ntext		X
  	Version	int		X
  FK	StateID	int		X
  	IsPublished	bit		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	Summary	ntext		X

  
  

  Indexes:

  
  

  • PK_HtmlText

    • (Primary Key)
    • (Clustered)
    
    
    
    • ItemID
  
  

  • IX_HtmlText_ModuleID_Version

    
    
    
    • ModuleID
    • Version
  
  

  References:

  
  

  • dbo.Modules

    
    
    
    • ModuleID
    
    

  • dbo.WorkflowStates

    
    
    
    • StateID
    
    

  Referenced by:

  
  

  • dbo.HtmlTextLog

    
    
    
    • ItemID
    
    

  • dbo.HtmlTextUsers

    
    
    
    • ItemID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddHtmlText

    
    
    
  • Procedure 

    dbo.DeleteHtmlText

    
    
    
  • Procedure 

    dbo.DeleteHtmlTextUsers

    
    
    
  • Procedure 

    dbo.GetAllHtmlText

    
    
    
  • Procedure 

    dbo.GetHtmlText

    
    
    
  • Procedure 

    dbo.GetTopHtmlText

    
    
    
  • Procedure 

    dbo.UpdateHtmlText

    
    
    

• Table dbo.HtmlTextLog (3 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	HtmlTextLogID	int	X
  FK	ItemID	int
  FK	StateID	int
  	Comment	nvarchar(4000)		X
  	Approved	bit
  	CreatedByUserID	int
  	CreatedOnDate	datetime

  
  

  Indexes:

  
  

  • PK_HtmlTextLog

    • (Primary Key)
    • (Clustered)
    
    
    
    • HtmlTextLogID
  
  

  • IX_HtmlTextLog_ItemID

    
    
    
    • ItemID
    • HtmlTextLogID (Included)
  
  

  References:

  
  

  • dbo.HtmlText

    
    
    
    • ItemID
    
    

  • dbo.WorkflowStates

    
    
    
    • StateID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddHtmlTextLog

    
    
    
  • Procedure 

    dbo.GetHtmlTextLog

    
    
    

• Table dbo.HtmlTextUsers (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	HtmlTextUserID	int	X
  FK	ItemID	int
  	StateID	int
  	ModuleID	int
  	TabID	int
  	UserID	int
  	CreatedOnDate	datetime

  
  

  Indexes:

  
  

  • PK_HtmlTextUsers

    • (Primary Key)
    • (Clustered)
    
    
    
    • HtmlTextUserID
  
  

  References:

  
  

  • dbo.HtmlText

    
    
    
    • ItemID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddHtmlTextUser

    
    
    
  • Procedure 

    dbo.DeleteHtmlTextUsers

    
    
    
  • Procedure 

    dbo.GetHtmlTextUser

    
    
    

• Table dbo.IPFilter (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	IPFilterID	int	X
  	IPAddress	nvarchar(50)		X
  	SubnetMask	nvarchar(50)		X
  	RuleType	tinyint		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_IPFilter

    • (Primary Key)
    • (Clustered)
    
    
    
    • IPFilterID
  
  

  Used by:

  
  

  • Procedure 

    dbo.AddIPFilter

    
    
    
  • Procedure 

    dbo.DeleteIPFilter

    
    
    
  • Procedure 

    dbo.GetIPFilter

    
    
    
  • Procedure 

    dbo.GetIPFilters

    
    
    
  • Procedure 

    dbo.UpdateIPFilter

    
    
    

• Table dbo.JavaScriptLibraries (5 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JavaScriptLibraryID	int	X
  FK	PackageID	int
  	LibraryName	nvarchar(200)
  	Version	nvarchar(10)
  	FileName	nvarchar(100)
  	ObjectName	nvarchar(100)
  	PreferredScriptLocation	int
  	CDNPath	nvarchar(250)

  
  

  Indexes:

  
  

  • PK_JavaScriptLIbraries

    • (Primary Key)
    • (Clustered)
    
    
    
    • JavaScriptLibraryID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.DeleteJavaScriptLibrary

    
    
    
  • Procedure 

    dbo.GetJavaScriptLibraries

    
    
    
  • Procedure 

    dbo.SaveJavaScriptLibrary

    
    
    

• Table dbo.Journal (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JournalId	int	X
  FK	JournalTypeId	int
  	UserId	int		X
  	DateCreated	datetime		X
  	DateUpdated	datetime		X
  	PortalId	int		X
  	ProfileId	int			-1
  	GroupId	int			-1
  	Title	nvarchar(255)		X
  	Summary	nvarchar(2000)		X
  	ItemData	nvarchar(2000)		X
  	ImageURL	nvarchar(255)		X
  	ObjectKey	nvarchar(255)		X
  	AccessKey	uniqueidentifier		X
  	ContentItemId	int		X
  	IsDeleted	bit			0
  	CommentsDisabled	bit			0
  	CommentsHidden	bit			0

  
  

  Indexes:

  
  

  • PK_Journal

    • (Primary Key)
    • (Clustered)
    
    
    
    • JournalId
  
  

  • IX_Journal_ContentItemId

    
    
    
    • ContentItemId
    • GroupId (Included)
  
  

  References:

  
  

  • dbo.Journal_Types

    
    
    
    • JournalTypeId
    
    

  Referenced by:

  
  

  • dbo.Journal_Data

    
    
    
    • JournalId
    
    

  • dbo.Journal_Comments

    
    
    
    • JournalId
    
    

  Used by:

  
  

  • Procedure 

    dbo.Journal_Comments_ToggleDisable

    
    
    
  • Procedure 

    dbo.Journal_Comments_ToggleHidden

    
    
    
  • Procedure 

    dbo.Journal_Delete

    
    
    
  • Procedure 

    dbo.Journal_DeleteByGroupId

    
    
    
  • Procedure 

    dbo.Journal_DeleteByKey

    
    
    
  • Procedure 

    dbo.Journal_Get

    
    
    
  • Procedure 

    dbo.Journal_GetByKey

    
    
    
  • Procedure 

    dbo.Journal_GetSearchItems

    
    
    
  • Procedure 

    dbo.Journal_GetStatsForGroup

    
    
    
  • Procedure 

    dbo.Journal_Like

    
    
    
  • Procedure 

    dbo.Journal_LikeList

    
    
    
  • Procedure 

    dbo.Journal_ListForGroup

    
    
    
  • Procedure 

    dbo.Journal_ListForProfile

    
    
    
  • Procedure 

    dbo.Journal_ListForSummary

    
    
    
  • Procedure 

    dbo.Journal_Save

    
    
    
  • Procedure 

    dbo.Journal_Types_Delete

    
    
    
  • Procedure 

    dbo.Journal_Update

    
    
    
  • Procedure 

    dbo.Journal_UpdateContentItemId

    
    
    

• Table dbo.Journal_Access (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JournalAccessId	int	X
  	JournalTypeId	int
  	PortalId	int
  	Name	nvarchar(50)
  	AccessKey	uniqueidentifier
  	IsEnabled	bit
  	DateCreated	datetime

  
  

  Indexes:

  
  

  • PK_Journal_Access

    • (Primary Key)
    • (Clustered)
    
    
    
    • JournalAccessId
  
  

• Table dbo.Journal_Comments (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CommentId	int	X
  FK	JournalId	int
  	UserId	int
  	Comment	nvarchar(2000)		X
  	DateCreated	datetime
  	DateUpdated	datetime
  	CommentXML	xml		X

  
  

  Indexes:

  
  

  • PK_Journal_Comments

    • (Primary Key)
    • (Clustered)
    
    
    
    • CommentId
  
  

  References:

  
  

  • dbo.Journal

    
    
    
    • JournalId
    
    

  Used by:

  
  

  • Procedure 

    dbo.Journal_Comment_Delete

    
    
    
  • Procedure 

    dbo.Journal_Comment_Get

    
    
    
  • Procedure 

    dbo.Journal_Comment_Like

    
    
    
  • Procedure 

    dbo.Journal_Comment_List

    
    
    
  • Procedure 

    dbo.Journal_Comment_ListByJournalIds

    
    
    
  • Procedure 

    dbo.Journal_Comment_Save

    
    
    
  • Procedure 

    dbo.Journal_Delete

    
    
    
  • Procedure 

    dbo.Journal_DeleteByGroupId

    
    
    
  • Procedure 

    dbo.Journal_DeleteByKey

    
    
    
  • Procedure 

    dbo.Journal_GetSearchItems

    
    
    

• Table dbo.Journal_Data (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JournalDataId	int	X
  FK	JournalId	int
  	JournalXML	xml

  
  

  Indexes:

  
  

  • PK_Journal_Data

    • (Primary Key)
    • (Clustered)
    
    
    
    • JournalDataId
  
  

  References:

  
  

  • dbo.Journal

    
    
    
    • JournalId
    
    

  Used by:

  
  

  • Procedure 

    dbo.Journal_Get

    
    
    
  • Procedure 

    dbo.Journal_GetByKey

    
    
    
  • Procedure 

    dbo.Journal_Like

    
    
    
  • Procedure 

    dbo.Journal_LikeList

    
    
    
  • Procedure 

    dbo.Journal_ListForGroup

    
    
    
  • Procedure 

    dbo.Journal_ListForProfile

    
    
    
  • Procedure 

    dbo.Journal_ListForSummary

    
    
    
  • Procedure 

    dbo.Journal_Save

    
    
    

• Table dbo.Journal_Security (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JournalSecurityId	int	X
  UK	JournalId	int
  UK	SecurityKey	nvarchar(50)

  
  

  Indexes:

  
  

  • PK_Journal_Security

    • (Primary Key)
    • (Clustered)
    
    
    
    • JournalSecurityId
  
  

  • IX_Journal_Security

    • (Unique)
    
    
    
    • JournalId (Descending)
    • SecurityKey
  
  

  Used by:

  
  

  • Procedure 

    dbo.Journal_Delete

    
    
    
  • Procedure 

    dbo.Journal_DeleteByGroupId

    
    
    
  • Procedure 

    dbo.Journal_DeleteByKey

    
    
    
  • Procedure 

    dbo.Journal_Get

    
    
    
  • Procedure 

    dbo.Journal_GetSearchItems

    
    
    
  • Procedure 

    dbo.Journal_ListForGroup

    
    
    
  • Procedure 

    dbo.Journal_ListForProfile

    
    
    
  • Procedure 

    dbo.Journal_ListForSummary

    
    
    
  • Procedure 

    dbo.Journal_Save

    
    
    
  • Procedure 

    dbo.Journal_Types_Delete

    
    
    
  • Procedure 

    dbo.Journal_Update

    
    
    

• Table dbo.Journal_TypeFilters (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JournalTypeFilterId	int	X
  	PortalId	int
  	ModuleId	int
  	JournalTypeId	int

  
  

  Indexes:

  
  

  • PK_Journal_TypeFilters

    • (Primary Key)
    • (Clustered)
    
    
    
    • JournalTypeFilterId
  
  

  Used by:

  
  

  • Procedure 

    dbo.Journal_ListForGroup

    
    
    
  • Procedure 

    dbo.Journal_ListForProfile

    
    
    
  • Procedure 

    dbo.Journal_ListForSummary

    
    
    
  • Procedure 

    dbo.Journal_TypeFilters_Delete

    
    
    
  • Procedure 

    dbo.Journal_TypeFilters_List

    
    
    
  • Procedure 

    dbo.Journal_TypeFilters_Save

    
    
    
  • Procedure 

    dbo.Journal_Types_Delete

    
    
    

• Table dbo.Journal_Types (35 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JournalTypeId	int
  	JournalType	nvarchar(25)		X
  	icon	nvarchar(25)		X
  	PortalId	int			-1
  	IsEnabled	bit			1
  	AppliesToProfile	bit			1
  	AppliesToGroup	bit			1
  	AppliesToStream	bit			1
  	Options	nvarchar(max)		X
  	SupportsNotify	bit			0
  	EnableComments	bit			1

  
  

  Indexes:

  
  

  • PK_JournalTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • JournalTypeId
  
  

  Referenced by:

  
  

  • dbo.Journal

    
    
    
    • JournalTypeId
    
    

  Used by:

  
  

  • Procedure 

    dbo.Journal_Get

    
    
    
  • Procedure 

    dbo.Journal_GetByKey

    
    
    
  • Procedure 

    dbo.Journal_GetStatsForGroup

    
    
    
  • Procedure 

    dbo.Journal_ListForGroup

    
    
    
  • Procedure 

    dbo.Journal_ListForProfile

    
    
    
  • Procedure 

    dbo.Journal_ListForSummary

    
    
    
  • Procedure 

    dbo.Journal_TypeFilters_List

    
    
    
  • Procedure 

    dbo.Journal_Types_Delete

    
    
    
  • Procedure 

    dbo.Journal_Types_Get

    
    
    
  • Procedure 

    dbo.Journal_Types_GetById

    
    
    
  • Procedure 

    dbo.Journal_Types_List

    
    
    
  • Procedure 

    dbo.Journal_Types_Save

    
    
    

• Table dbo.LanguagePacks (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	LanguagePackID	int	X
  UK , FK	PackageID	int
  	DependentPackageID	int
  UK	LanguageID	int
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_LanguagePacks

    • (Primary Key)
    • (Clustered)
    
    
    
    • LanguagePackID
  
  

  • IX_LanguagePacks

    • (Unique)
    
    
    
    • LanguageID
    • PackageID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddLanguagePack

    
    
    
  • Procedure 

    dbo.DeleteLanguagePack

    
    
    
  • Procedure 

    dbo.GetLanguagePackByPackage

    
    
    
  • Procedure 

    dbo.UpdateLanguagePack

    
    
    

• Table dbo.Languages (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	LanguageID	int	X
  UK	CultureCode	nvarchar(50)
  	CultureName	nvarchar(200)
  	FallbackCulture	nvarchar(50)		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_Languages

    • (Primary Key)
    • (Clustered)
    
    
    
    • LanguageID
  
  

  • IX_Languages

    • (Unique)
    
    
    
    • CultureCode
  
  

  Referenced by:

  
  

  • dbo.PortalLanguages

    
    
    
    • LanguageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddLanguage

    
    
    
  • Procedure 

    dbo.DeleteLanguage

    
    
    
  • Procedure 

    dbo.EnsureLocalizationExists

    
    
    
  • Procedure 

    dbo.GetLanguages

    
    
    
  • Procedure 

    dbo.GetLanguagesByPortal

    
    
    
  • Procedure 

    dbo.UpdateLanguage

    
    
    

• Table dbo.Lists (627 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	EntryID	int	X
  UK	ListName	nvarchar(50)
  UK	Value	nvarchar(100)
  UK	Text	nvarchar(150)
  UK	ParentID	int			0
  	Level	int			0
  	SortOrder	int			0
  	DefinitionID	int			0
  	Description	nvarchar(500)		X
  	PortalID	int			-1
  	SystemList	bit			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_Lists

    • (Primary Key)
    • (Clustered)
    
    
    
    • EntryID
  
  

  • IX_Lists_ListName_Value_Text_ParentID

    • (Unique)
    
    
    
    • ListName
    • Value
    • Text
    • ParentID
  
  

  • IX_Lists_ParentID

    • (Unique)
    
    
    
    • ParentID
    • ListName
    • Value
    • SortOrder (Included)
    • DefinitionID (Included)
    • Text (Included)
  
  

  • IX_Lists_ListName_ParentID

    
    
    
    • ListName
    • ParentID
  
  

  • IX_Lists_SortOrder

    
    
    
    • PortalID
    • ParentID
    • ListName
    • SortOrder
    • DefinitionID (Included)
    • Value (Included)
    • Text (Included)
  
  

  Used by:

  
  

  • Function 

    dbo.GetListParentKey

    
    
    
  • Procedure 

    dbo.AddListEntry

    
    
    
  • Procedure 

    dbo.DeleteListEntryByID

    
    
    
  • Procedure 

    dbo.GetAvailableUsersForIndex

    
    
    
  • Procedure 

    dbo.UpdateListEntry

    
    
    
  • Procedure 

    dbo.UpdateListSortOrder

    
    
    
  • View 

    dbo.vw_Lists

    
    
    

• Table dbo.Messaging_Messages (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	MessageID	bigint	X
  	PortalID	int
  	FromUserID	int
  	ToUserName	nvarchar(50)		X
  	FromUserName	nvarchar(50)		X
  	ToUserID	int		X
  	ToRoleID	int		X
  	Status	tinyint
  	Subject	nvarchar(max)		X
  	Body	nvarchar(max)		X
  	Date	datetime
  	Conversation	uniqueidentifier
  	ReplyTo	bigint		X
  	AllowReply	bit
  	SkipPortal	bit
  	EmailSent	bit
  	EmailSentDate	datetime		X
  	EmailSchedulerInstance	uniqueidentifier		X

  
  

  Indexes:

  
  

  • PK_Messaging_Messages

    • (Primary Key)
    • (Clustered)
    
    
    
    • MessageID
  
  

  • IX_Messaging_Messages_EmailSent_EmailSchedulerInstance_Status

    
    
    
    • EmailSent
    • EmailSchedulerInstance
    • Status
    • Date (Descending)
  
  

  • IX_Messaging_Messages_FromUserID_Status

    
    
    
    • FromUserID
    • Status
    • Date (Descending)
  
  

  • IX_Messaging_Messages_ToUserID_Status_SkipPortal

    
    
    
    • ToUserID
    • Status
    • SkipPortal
    • Date (Descending)
  
  

  Used by:

  
  

  • Procedure 

    dbo.CoreMessaging_ConvertLegacyMessages

    
    
    
  • Procedure 

    dbo.CoreMessaging_CountLegacyMessages

    
    
    
  • Procedure 

    dbo.CoreMessaging_DeleteLegacyMessage

    
    
    
  • Procedure 

    dbo.Messaging_GetInbox

    
    
    
  • Procedure 

    dbo.Messaging_GetInboxCount

    
    
    
  • Procedure 

    dbo.Messaging_GetMessage

    
    
    
  • Procedure 

    dbo.Messaging_GetNewMessageCount

    
    
    
  • Procedure 

    dbo.Messaging_GetNextMessageForDispatch

    
    
    
  • Procedure 

    dbo.Messaging_MarkMessageAsDispatched

    
    
    
  • Procedure 

    dbo.Messaging_Save_Message

    
    
    
  • Procedure 

    dbo.Messaging_UpdateMessage

    
    
    

• Table dbo.MetaData (15 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	MetaDataID	int	X
  UK	MetaDataName	nvarchar(100)
  	MetaDataDescription	nvarchar(2500)		X

  
  

  Indexes:

  
  

  • PK_MetaData

    • (Primary Key)
    • (Clustered)
    
    
    
    • MetaDataID
  
  

  • IX_MetaData_MetaDataName

    • (Unique)
    
    
    
    • MetaDataName
  
  

  Referenced by:

  
  

  • dbo.ContentItems_MetaData

    
    
    
    • MetaDataID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddMetaData

    
    
    
  • Procedure 

    dbo.DeleteMetaData

    
    
    
  • Procedure 

    dbo.GetMetaData

    
    
    

• Table dbo.Mobile_PreviewProfiles (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	Id	int	X
  FK	PortalId	int
  	Name	nvarchar(50)
  	Width	int
  	Height	int
  	UserAgent	nvarchar(260)
  	SortOrder	int			0
  	CreatedByUserID	int
  	CreatedOnDate	datetime			getdate()
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_Mobile_PreviewProfiles

    • (Primary Key)
    • (Clustered)
    
    
    
    • Id
  
  

  • IX_Mobile_PreviewProfiles_SortOrder

    
    
    
    • SortOrder
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  Used by:

  
  

  • Procedure 

    dbo.Mobile_DeletePreviewProfile

    
    
    
  • Procedure 

    dbo.Mobile_GetPreviewProfiles

    
    
    
  • Procedure 

    dbo.Mobile_SavePreviewProfile

    
    
    

• Table dbo.Mobile_RedirectionRules (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	Id	int	X
  FK	RedirectionId	int
  	Capability	nvarchar(50)
  	Expression	nvarchar(50)

  
  

  Indexes:

  
  

  • PK_Mobile_RedirectionRules

    • (Primary Key)
    • (Clustered)
    
    
    
    • Id
  
  

  References:

  
  

  • dbo.Mobile_Redirections

    
    
    
    • Id (RedirectionId)
    
    

  Used by:

  
  

  • Procedure 

    dbo.Mobile_DeleteRedirection

    
    
    
  • Procedure 

    dbo.Mobile_DeleteRedirectionRule

    
    
    
  • Procedure 

    dbo.Mobile_GetRedirectionRules

    
    
    
  • Procedure 

    dbo.Mobile_SaveRedirectionRule

    
    
    

• Table dbo.Mobile_Redirections (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	Id	int	X
  FK	PortalId	int
  	Name	nvarchar(50)
  	Type	int
  	SortOrder	int			0
  	SourceTabId	int
  	IncludeChildTabs	bit
  	TargetType	int
  	TargetValue	nvarchar(260)
  	Enabled	bit
  	CreatedByUserID	int
  	CreatedOnDate	datetime			getdate()
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_Mobile_Redirections

    • (Primary Key)
    • (Clustered)
    
    
    
    • Id
  
  

  • IX_Mobile_Redirections_SortOrder

    
    
    
    • SortOrder
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  Referenced by:

  
  

  • dbo.Mobile_RedirectionRules

    
    
    
    • RedirectionId (Id)
    
    

  Used by:

  
  

  • Procedure 

    dbo.Mobile_DeleteRedirection

    
    
    
  • Procedure 

    dbo.Mobile_GetAllRedirections

    
    
    
  • Procedure 

    dbo.Mobile_GetRedirections

    
    
    
  • Procedure 

    dbo.Mobile_SaveRedirection

    
    
    

• Table dbo.ModuleControls (143 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ModuleControlID	int	X
  UK , FK	ModuleDefID	int		X
  UK	ControlKey	nvarchar(50)		X
  	ControlTitle	nvarchar(50)		X
  UK	ControlSrc	nvarchar(256)		X
  	IconFile	nvarchar(100)		X
  	ControlType	int
  	ViewOrder	int		X
  	HelpUrl	nvarchar(200)		X
  	SupportsPartialRendering	bit			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	SupportsPopUps	bit			0

  
  

  Indexes:

  
  

  • PK_ModuleControls

    • (Primary Key)
    • (Clustered)
    
    
    
    • ModuleControlID
  
  

  • IX_ModuleControls

    • (Unique)
    
    
    
    • ModuleDefID
    • ControlKey
    • ControlSrc
  
  

  • IX_ModuleControls_ControlKey_ViewOrder

    
    
    
    • ControlKey
    • ViewOrder
  
  

  References:

  
  

  • dbo.ModuleDefinitions

    
    
    
    • ModuleDefID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddModuleControl

    
    
    
  • Procedure 

    dbo.DeleteModuleControl

    
    
    
  • Procedure 

    dbo.GetModuleControls

    
    
    
  • Procedure 

    dbo.UpdateModuleControl

    
    
    
  • View 

    dbo.vw_Modules

    
    
    
  • View 

    dbo.vw_TabModules

    
    
    

• Table dbo.ModuleDefinitions (48 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ModuleDefID	int	X
  	FriendlyName	nvarchar(128)
  FK	DesktopModuleID	int
  	DefaultCacheTime	int			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  UK	DefinitionName	nvarchar(128)

  
  

  Indexes:

  
  

  • PK_ModuleDefinitions

    • (Primary Key)
    • (Clustered)
    
    
    
    • ModuleDefID
  
  

  • IX_ModuleDefinitions

    • (Unique)
    
    
    
    • DefinitionName
  
  

  • IX_ModuleDefinitions_1

    
    
    
    • DesktopModuleID
  
  

  References:

  
  

  • dbo.DesktopModules

    
    
    
    • DesktopModuleID
    
    

  Referenced by:

  
  

  • dbo.ModuleControls

    
    
    
    • ModuleDefID
    
    

  • dbo.Modules

    
    
    
    • ModuleDefID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddModuleDefinition

    
    
    
  • Procedure 

    dbo.Dashboard_GetInstalledModules

    
    
    
  • Procedure 

    dbo.DeleteDesktopModule

    
    
    
  • Procedure 

    dbo.DeleteModuleDefinition

    
    
    
  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    
  • Procedure 

    dbo.GetModuleByDefinition

    
    
    
  • Procedure 

    dbo.GetModuleDefinitions

    
    
    
  • Procedure 

    dbo.GetSearchResultModules

    
    
    
  • Procedure 

    dbo.UpdateModuleDefinition

    
    
    
  • View 

    dbo.vw_Modules

    
    
    
  • View 

    dbo.vw_TabModules

    
    
    

• Table dbo.ModulePermission (77 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ModulePermissionID	int	X
  UK , FK	ModuleID	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
  	PortalID	int

  
  

  Indexes:

  
  

  • PK_ModulePermission

    • (Primary Key)
    • (Clustered)
    
    
    
    • ModulePermissionID
  
  

  • IX_ModulePermission_Modules

    • (Unique)
    
    
    
    • ModuleID
    • PermissionID
    • RoleID
    • UserID
    • AllowAccess (Included)
  
  

  • IX_ModulePermission_Roles

    • (Unique)
    
    
    
    • RoleID
    • ModuleID
    • PermissionID
    • AllowAccess (Included)
  
  

  • IX_ModulePermission_Users

    • (Unique)
    
    
    
    • UserID
    • ModuleID
    • PermissionID
    • AllowAccess (Included)
  
  

  • IX_ModulePermission_Permission

    
    
    
    • PermissionID
  
  

  References:

  
  

  • dbo.Modules

    
    
    
    • ModuleID
    
    

  • dbo.Permission

    
    
    
    • PermissionID
    
    

  • dbo.Roles

    
    
    
    • RoleID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddModulePermission

    
    
    
  • Procedure 

    dbo.DeleteModulePermission

    
    
    
  • Procedure 

    dbo.DeleteModulePermissionsByModuleID

    
    
    
  • Procedure 

    dbo.DeleteModulePermissionsByUserID

    
    
    
  • Procedure 

    dbo.DeleteRole

    
    
    
  • Procedure 

    dbo.UpdateModulePermission

    
    
    
  • View 

    dbo.vw_ModulePermissions

    
    
    

• Table dbo.Modules (62 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ModuleID	int	X
  FK	ModuleDefID	int
  	AllTabs	bit			0
  	IsDeleted	bit			0
  	InheritViewPermissions	bit		X
  	StartDate	datetime		X
  	EndDate	datetime		X
  	PortalID	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X	getdate()
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X	getdate()
  	LastContentModifiedOnDate	datetime		X
  FK	ContentItemID	int		X
  	IsShareable	bit			1
  	IsShareableViewOnly	bit			1

  
  

  Indexes:

  
  

  • PK_Modules

    • (Primary Key)
    • (Clustered)
    
    
    
    • ModuleID
  
  

  • IX_Modules_ModuleDefId

    
    
    
    • ModuleDefID
    • ModuleID (Included)
  
  

  • IX_Modules_PortalId

    
    
    
    • PortalID
  
  

  References:

  
  

  • dbo.ContentItems

    
    
    
    • ContentItemID
    
    

  • dbo.ModuleDefinitions

    
    
    
    • ModuleDefID
    
    

  Referenced by:

  
  

  • dbo.CoreMessaging_Subscriptions

    
    
    
    • ModuleId (ModuleID)
    
    

  • dbo.HtmlText

    
    
    
    • ModuleID
    
    

  • dbo.ModulePermission

    
    
    
    • ModuleID
    
    

  • dbo.ModuleSettings

    
    
    
    • ModuleID
    
    

  • dbo.TabModules

    
    
    
    • ModuleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddModule

    
    
    
  • Procedure 

    dbo.Dashboard_GetInstalledModules

    
    
    
  • Procedure 

    dbo.DeleteModule

    
    
    
  • Procedure 

    dbo.DeleteModulePermissionsByUserID

    
    
    
  • Procedure 

    dbo.DeletePortalInfo

    
    
    
  • Procedure 

    dbo.DeleteTranslatedTabs

    
    
    
  • Procedure 

    dbo.GetAllHtmlText

    
    
    
  • Procedure 

    dbo.GetDefaultLanguageByModule

    
    
    
  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    
  • Procedure 

    dbo.GetHtmlText

    
    
    
  • Procedure 

    dbo.GetSearchResultModules

    
    
    
  • Procedure 

    dbo.GetSearchSettings

    
    
    
  • Procedure 

    dbo.GetTopHtmlText

    
    
    
  • Procedure 

    dbo.UpdateModule

    
    
    
  • Procedure 

    dbo.UpdateModuleLastContentModifiedOnDate

    
    
    
  • View 

    dbo.vw_Modules

    
    
    
  • View 

    dbo.vw_TabModules

    
    
    

• Table dbo.ModuleSettings (76 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ModuleID	int
  PK	SettingName	nvarchar(50)
  	SettingValue	nvarchar(max)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_ModuleSettings

    • (Primary Key)
    • (Clustered)
    
    
    
    • ModuleID
    • SettingName
  
  

  References:

  
  

  • dbo.Modules

    
    
    
    • ModuleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddModuleSetting

    
    
    
  • Procedure 

    dbo.DeleteModuleSetting

    
    
    
  • Procedure 

    dbo.DeleteModuleSettings

    
    
    
  • Procedure 

    dbo.GetModuleSetting

    
    
    
  • Procedure 

    dbo.GetModuleSettings

    
    
    
  • Procedure 

    dbo.GetModuleSettingsByTab

    
    
    
  • Procedure 

    dbo.UpdateModuleSetting

    
    
    

• Table dbo.PackageDependencies (3 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PackageDependencyID	int	X
  FK	PackageID	int
  	PackageName	nvarchar(128)
  	Version	nvarchar(50)

  
  

  Indexes:

  
  

  • PK_PackageDependencies

    • (Primary Key)
    • (Clustered)
    
    
    
    • PackageDependencyID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.GetPackageDependencies

    
    
    
  • Procedure 

    dbo.SavePackageDependency

    
    
    

• Table dbo.Packages (106 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PackageID	int	X
  UK	PortalID	int		X
  UK	Name	nvarchar(128)
  	FriendlyName	nvarchar(250)
  	Description	nvarchar(2000)		X
  UK , FK	PackageType	nvarchar(100)
  UK	Version	nvarchar(50)
  	License	ntext		X
  	Manifest	ntext		X
  UK	Owner	nvarchar(100)		X
  	Organization	nvarchar(100)		X
  	Url	nvarchar(250)		X
  	Email	nvarchar(100)		X
  	ReleaseNotes	ntext		X
  	IsSystemPackage	bit			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	FolderName	nvarchar(128)		X
  	IconFile	nvarchar(100)		X

  
  

  Indexes:

  
  

  • PK_Packages

    • (Primary Key)
    • (Clustered)
    
    
    
    • PackageID
  
  

  • IX_Packages

    • (Unique)
    
    
    
    • Owner
    • Name
    • PackageType
    • PortalID
    • Version
  
  

  References:

  
  

  • dbo.PackageTypes

    
    
    
    • PackageType
    
    

  Referenced by:

  
  

  • dbo.Authentication

    
    
    
    • PackageID
    
    

  • dbo.Dashboard_Controls

    
    
    
    • PackageID
    
    

  • dbo.DesktopModules

    
    
    
    • PackageID
    
    

  • dbo.JavaScriptLibraries

    
    
    
    • PackageID
    
    

  • dbo.LanguagePacks

    
    
    
    • PackageID
    
    

  • dbo.Assemblies

    
    
    
    • PackageID
    
    

  • dbo.PackageDependencies

    
    
    
    • PackageID
    
    

  • dbo.SkinControls

    
    
    
    • PackageID
    
    

  • dbo.SkinPackages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddPackage

    
    
    
  • Procedure 

    dbo.DeletePackage

    
    
    
  • Procedure 

    dbo.DeletePortalInfo

    
    
    
  • Procedure 

    dbo.GetModulePackagesInUse

    
    
    
  • Procedure 

    dbo.GetPackages

    
    
    
  • Procedure 

    dbo.UpdatePackage

    
    
    

• Table dbo.PackageTypes (12 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PackageType	nvarchar(100)
  	Description	nvarchar(500)
  	SecurityAccessLevel	int
  	EditorControlSrc	nvarchar(250)		X
  	SupportsSideBySideInstallation	bit			0

  
  

  Indexes:

  
  

  • PK_PackageTypes_1

    • (Primary Key)
    • (Clustered)
    
    
    
    • PackageType
  
  

  Referenced by:

  
  

  • dbo.Packages

    
    
    
    • PackageType
    
    

  Used by:

  
  

  • Procedure 

    dbo.GetPackageTypes

    
    
    

• Table dbo.PasswordHistory (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PasswordHistoryID	int	X
  FK	UserID	int
  	Password	nvarchar(128)
  	PasswordSalt	nvarchar(128)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_PasswordHistory

    • (Primary Key)
    • (Clustered)
    
    
    
    • PasswordHistoryID
  
  

  References:

  
  

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddPasswordHistory

    
    
    
  • Procedure 

    dbo.GetPasswordHistory

    
    
    

• Table dbo.Permission (14 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PermissionID	int	X
  UK	PermissionCode	varchar(50)
  UK	ModuleDefID	int
  UK	PermissionKey	varchar(50)
  	PermissionName	varchar(50)
  	ViewOrder	int			9999
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_Permission

    • (Primary Key)
    • (Clustered)
    
    
    
    • PermissionID
  
  

  • IX_Permission

    • (Unique)
    
    
    
    • PermissionCode
    • ModuleDefID
    • PermissionKey
  
  

  Referenced by:

  
  

  • dbo.ContentWorkflowStatePermission

    
    
    
    • PermissionID
    
    

  • dbo.DesktopModulePermission

    
    
    
    • PermissionID
    
    

  • dbo.FolderPermission

    
    
    
    • PermissionID
    
    

  • dbo.ModulePermission

    
    
    
    • PermissionID
    
    

  • dbo.TabPermission

    
    
    
    • PermissionID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddPermission

    
    
    
  • Procedure 

    dbo.DeleteDesktopModule

    
    
    
  • Procedure 

    dbo.DeleteModuleDefinition

    
    
    
  • Procedure 

    dbo.DeletePermission

    
    
    
  • Procedure 

    dbo.GetFoldersByPermissions

    
    
    
  • Procedure 

    dbo.GetPermissions

    
    
    
  • Procedure 

    dbo.UpdatePermission

    
    
    
  • View 

    dbo.vw_ContentWorkflowStatePermissions

    
    
    
  • View 

    dbo.vw_DesktopModulePermissions

    
    
    
  • View 

    dbo.vw_FolderPermissions

    
    
    
  • View 

    dbo.vw_ModulePermissions

    
    
    
  • View 

    dbo.vw_TabPermissions

    
    
    

• Table dbo.PortalAlias (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PortalAliasID	int	X
  FK	PortalID	int
  UK	HTTPAlias	nvarchar(200)		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	BrowserType	nvarchar(10)		X
  	Skin	nvarchar(100)		X
  	CultureCode	nvarchar(10)		X
  	IsPrimary	bit			0

  
  

  Indexes:

  
  

  • PK_PortalAlias

    • (Primary Key)
    • (Clustered)
    
    
    
    • PortalAliasID
  
  

  • IX_PortalAlias

    • (Unique)
    
    
    
    • HTTPAlias
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddPortalAlias

    
    
    
  • Procedure 

    dbo.DeletePortalAlias

    
    
    
  • Procedure 

    dbo.GetCustomAliasesForTabs

    
    
    
  • Procedure 

    dbo.GetPortalAliases

    
    
    
  • Procedure 

    dbo.GetPortalByPortalAliasID

    
    
    
  • Procedure 

    dbo.GetTabAliasSkins

    
    
    
  • Procedure 

    dbo.GetTabCustomAliases

    
    
    
  • Procedure 

    dbo.UpdatePortalAlias

    
    
    
  • Procedure 

    dbo.UpdatePortalAliasOnInstall

    
    
    

• Table dbo.PortalDesktopModules (34 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PortalDesktopModuleID	int	X
  UK , FK	PortalID	int
  UK , FK	DesktopModuleID	int
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_PortalDesktopModules

    • (Primary Key)
    • (Clustered)
    
    
    
    • PortalDesktopModuleID
  
  

  • IX_PortalDesktopModules

    • (Unique)
    
    
    
    • PortalID
    • DesktopModuleID
  
  

  References:

  
  

  • dbo.DesktopModules

    
    
    
    • DesktopModuleID
    
    

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Referenced by:

  
  

  • dbo.DesktopModulePermission

    
    
    
    • PortalDesktopModuleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddPortalDesktopModule

    
    
    
  • Procedure 

    dbo.DeleteDesktopModulePermissionsByUserID

    
    
    
  • Procedure 

    dbo.DeletePortalDesktopModules

    
    
    
  • Procedure 

    dbo.GetDesktopModulesByPortal

    
    
    
  • Procedure 

    dbo.GetPortalDesktopModules

    
    
    

• Table dbo.PortalGroups (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PortalGroupID	int	X
  	MasterPortalID	int		X
  	PortalGroupName	nvarchar(100)		X
  	PortalGroupDescription	nvarchar(2000)		X
  	AuthenticationDomain	nvarchar(200)		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_PortalGroup

    • (Primary Key)
    • (Clustered)
    
    
    
    • PortalGroupID
  
  

  Used by:

  
  

  • Procedure 

    dbo.AddPortalGroup

    
    
    
  • Procedure 

    dbo.DeletePortalGroup

    
    
    
  • Procedure 

    dbo.GetPortalGroups

    
    
    
  • Procedure 

    dbo.GetUsersByRolename

    
    
    
  • Procedure 

    dbo.UpdatePortalGroup

    
    
    

• Table dbo.PortalLanguages (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PortalLanguageID	int	X
  UK , FK	PortalID	int
  UK , FK	LanguageID	int
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	IsPublished	bit			0

  
  

  Indexes:

  
  

  • PK_PortalLanguages

    • (Primary Key)
    • (Clustered)
    
    
    
    • PortalLanguageID
  
  

  • IX_PortalLanguages

    • (Unique)
    
    
    
    • PortalID
    • LanguageID
  
  

  References:

  
  

  • dbo.Languages

    
    
    
    • LanguageID
    
    

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddPortalLanguage

    
    
    
  • Procedure 

    dbo.DeletePortalLanguages

    
    
    
  • Procedure 

    dbo.EnsureLocalizationExists

    
    
    
  • Procedure 

    dbo.GetLanguagesByPortal

    
    
    
  • Procedure 

    dbo.UpdatePortalLanguage

    
    
    

• Table dbo.PortalLocalization (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	PortalID	int
  PK	CultureCode	nvarchar(10)
  	PortalName	nvarchar(128)
  	LogoFile	nvarchar(50)		X
  	FooterText	nvarchar(100)		X
  	Description	nvarchar(500)		X
  	KeyWords	nvarchar(500)		X
  	BackgroundFile	nvarchar(50)		X
  	HomeTabId	int		X
  	LoginTabId	int		X
  	UserTabId	int		X
  	AdminTabId	int		X
  	SplashTabId	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	RegisterTabId	int		X
  	SearchTabId	int		X
  	Custom404TabId	int		X
  	Custom500TabId	int		X

  
  

  Indexes:

  
  

  • PK_PortalLocalization

    • (Primary Key)
    • (Clustered)
    
    
    
    • PortalID
    • CultureCode
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddPortalInfo

    
    
    
  • Procedure 

    dbo.EnsureLocalizationExists

    
    
    
  • Procedure 

    dbo.InsertPortalLocalization

    
    
    
  • Procedure 

    dbo.RemovePortalLocalization

    
    
    
  • Procedure 

    dbo.UpdatePortalInfo

    
    
    
  • Procedure 

    dbo.UpdatePortalSetup

    
    
    
  • View 

    dbo.vw_Portals

    
    
    

• Table dbo.Portals (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PortalID	int	X
  	ExpiryDate	datetime		X
  	UserRegistration	int			0
  	BannerAdvertising	int			0
  	AdministratorId	int		X
  	Currency	char(3)		X
  	HostFee	money			0
  	HostSpace	int			0
  	AdministratorRoleId	int		X
  	RegisteredRoleId	int		X
  	GUID	uniqueidentifier			newid()
  	PaymentProcessor	nvarchar(50)		X
  	ProcessorUserId	nvarchar(50)		X
  	ProcessorPassword	nvarchar(50)		X
  	SiteLogHistory	int		X
  	DefaultLanguage	nvarchar(10)			'en-US'
  	TimezoneOffset	int			-8
  	HomeDirectory	varchar(100)			''
  	PageQuota	int			0
  	UserQuota	int			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	PortalGroupID	int		X

  
  

  Indexes:

  
  

  • PK_Portals

    • (Primary Key)
    • (Clustered)
    
    
    
    • PortalID
  
  

  • IX_Portals_AdministratorId

    
    
    
    • AdministratorId
  
  

  • IX_Portals_DefaultLanguage

    
    
    
    • DefaultLanguage
  
  

  Referenced by:

  
  

  • dbo.AnonymousUsers

    
    
    
    • PortalID
    
    

  • dbo.CoreMessaging_Subscriptions

    
    
    
    • PortalId (PortalID)
    
    

  • dbo.Files

    
    
    
    • PortalId (PortalID)
    
    

  • dbo.FolderMappings

    
    
    
    • PortalID
    
    

  • dbo.Folders

    
    
    
    • PortalID
    
    

  • dbo.Mobile_PreviewProfiles

    
    
    
    • PortalId (PortalID)
    
    

  • dbo.Mobile_Redirections

    
    
    
    • PortalId (PortalID)
    
    

  • dbo.PortalAlias

    
    
    
    • PortalID
    
    

  • dbo.PortalDesktopModules

    
    
    
    • PortalID
    
    

  • dbo.PortalLanguages

    
    
    
    • PortalID
    
    

  • dbo.PortalLocalization

    
    
    
    • PortalID
    
    

  • dbo.PortalSettings

    
    
    
    • PortalID
    
    

  • dbo.Profile

    
    
    
    • PortalId (PortalID)
    
    

  • dbo.ProfilePropertyDefinition

    
    
    
    • PortalID
    
    

  • dbo.Relationships

    
    
    
    • PortalID
    
    

  • dbo.RoleGroups

    
    
    
    • PortalID
    
    

  • dbo.Roles

    
    
    
    • PortalID
    
    

  • dbo.SiteLog

    
    
    
    • PortalId (PortalID)
    
    

  • dbo.SystemMessages

    
    
    
    • PortalID
    
    

  • dbo.Tabs

    
    
    
    • PortalID
    
    

  • dbo.Urls

    
    
    
    • PortalID
    
    

  • dbo.UrlTracking

    
    
    
    • PortalID
    
    

  • dbo.UserPortals

    
    
    
    • PortalId (PortalID)
    
    

  • dbo.UsersOnline

    
    
    
    • PortalID
    
    

  • dbo.Vendors

    
    
    
    • PortalId (PortalID)
    
    

  Used by:

  
  

  • Function 

    dbo.AdministratorRoleId

    
    
    
  • Function 

    dbo.Journal_User_Permissions

    
    
    
  • Procedure 

    dbo.AddPortalInfo

    
    
    
  • Procedure 

    dbo.DeletePortalInfo

    
    
    
  • Procedure 

    dbo.EnsureLocalizationExists

    
    
    
  • Procedure 

    dbo.GetDefaultLanguageByModule

    
    
    
  • Procedure 

    dbo.GetPortalDefaultLanguage

    
    
    
  • Procedure 

    dbo.GetSearchSettings

    
    
    
  • Procedure 

    dbo.GetUsersByRolename

    
    
    
  • Procedure 

    dbo.UpdatePortalDefaultLanguage

    
    
    
  • Procedure 

    dbo.UpdatePortalInfo

    
    
    
  • Procedure 

    dbo.UpdatePortalSetup

    
    
    
  • View 

    dbo.vw_Portals

    
    
    

• Table dbo.PortalSettings (11 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	PortalID	int
  PK	SettingName	nvarchar(50)
  	SettingValue	nvarchar(2000)		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  PK	CultureCode	nvarchar(10)

  
  

  Indexes:

  
  

  • PK_PortalSettings

    • (Primary Key)
    • (Clustered)
    
    
    
    • PortalID
    • SettingName
    • CultureCode
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Used by:

  
  

  • Procedure 

    dbo.DeletePortalSetting

    
    
    
  • Procedure 

    dbo.DeletePortalSettings

    
    
    
  • Procedure 

    dbo.GetPortalSetting

    
    
    
  • Procedure 

    dbo.GetPortalSettings

    
    
    
  • Procedure 

    dbo.GetSearchSettings

    
    
    
  • Procedure 

    dbo.UpdatePortalSetting

    
    
    

• Table dbo.Profile (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProfileId	int	X
  UK , FK	UserId	int
  UK , FK	PortalId	int
  	ProfileData	ntext
  	CreatedDate	datetime

  
  

  Indexes:

  
  

  • PK_Profile

    • (Primary Key)
    • (Clustered)
    
    
    
    • ProfileId
  
  

  • IX_Profile

    • (Unique)
    
    
    
    • UserId
    • PortalId
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  • dbo.Users

    
    
    
    • UserID (UserId)
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddProfile

    
    
    
  • Procedure 

    dbo.GetAllProfiles

    
    
    
  • Procedure 

    dbo.GetProfile

    
    
    
  • Procedure 

    dbo.UpdateProfile

    
    
    

• Table dbo.ProfilePropertyDefinition (45 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PropertyDefinitionID	int	X
  UK , FK	PortalID	int		X
  UK	ModuleDefID	int		X
  	Deleted	bit
  	DataType	int
  	DefaultValue	ntext		X
  	PropertyCategory	nvarchar(50)
  UK	PropertyName	nvarchar(50)
  	Length	int			0
  	Required	bit
  	ValidationExpression	nvarchar(2000)		X
  	ViewOrder	int
  	Visible	bit
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	DefaultVisibility	int		X
  	ReadOnly	bit			0

  
  

  Indexes:

  
  

  • PK_ProfilePropertyDefinition

    • (Primary Key)
    • (Clustered)
    
    
    
    • PropertyDefinitionID
  
  

  • IX_ProfilePropertyDefinition

    • (Unique)
    
    
    
    • PortalID
    • ModuleDefID
    • PropertyName
  
  

  • IX_ProfilePropertyDefinition_PropertyName

    
    
    
    • PropertyName
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Referenced by:

  
  

  • dbo.UserProfile

    
    
    
    • PropertyDefinitionID
    
    

  Used by:

  
  

  • Function 

    dbo.GetProfileFieldSQL

    
    
    
  • Function 

    dbo.GetProfilePropertyDefinitionID

    
    
    
  • Procedure 

    dbo.AddPropertyDefinition

    
    
    
  • Procedure 

    dbo.DeletePropertyDefinition

    
    
    
  • Procedure 

    dbo.GetAvailableUsersForIndex

    
    
    
  • Procedure 

    dbo.GetPropertyDefinition

    
    
    
  • Procedure 

    dbo.GetPropertyDefinitionByName

    
    
    
  • Procedure 

    dbo.GetPropertyDefinitionsByCategory

    
    
    
  • Procedure 

    dbo.GetPropertyDefinitionsByPortal

    
    
    
  • Procedure 

    dbo.GetUsersAdvancedSearch

    
    
    
  • Procedure 

    dbo.UpdatePropertyDefinition

    
    
    
  • View 

    dbo.vw_Profile

    
    
    

• Table dbo.Relationships (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	RelationshipID	int	X
  FK	RelationshipTypeID	int
  	Name	nvarchar(50)
  	Description	nvarchar(500)		X
  FK	PortalID	int		X
  FK	UserID	int		X
  	DefaultResponse	int
  	CreatedByUserID	int
  	CreatedOnDate	datetime			getdate()
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_Relationships

    • (Primary Key)
    • (Clustered)
    
    
    
    • RelationshipID
  
  

  • IX_Relationships_UserID

    
    
    
    • UserID
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  • dbo.RelationshipTypes

    
    
    
    • RelationshipTypeID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Referenced by:

  
  

  • dbo.UserRelationshipPreferences

    
    
    
    • RelationshipID
    
    

  • dbo.UserRelationships

    
    
    
    • RelationshipID
    
    

  Used by:

  
  

  • Function 

    dbo.Journal_User_Permissions

    
    
    
  • Procedure 

    dbo.DeleteRelationship

    
    
    
  • Procedure 

    dbo.GetRelationship

    
    
    
  • Procedure 

    dbo.GetRelationshipsByPortalID

    
    
    
  • Procedure 

    dbo.GetRelationshipsByUserID

    
    
    
  • Procedure 

    dbo.SaveRelationship

    
    
    

• Table dbo.RelationshipTypes (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	RelationshipTypeID	int	X
  	Direction	int
  	Name	nvarchar(50)
  	Description	nvarchar(500)		X
  	CreatedByUserID	int
  	CreatedOnDate	datetime			getdate()
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_RelationshipTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • RelationshipTypeID
  
  

  Referenced by:

  
  

  • dbo.Relationships

    
    
    
    • RelationshipTypeID
    
    

  Used by:

  
  

  • Procedure 

    dbo.DeleteRelationshipType

    
    
    
  • Procedure 

    dbo.GetAllRelationshipTypes

    
    
    
  • Procedure 

    dbo.GetRelationshipType

    
    
    
  • Procedure 

    dbo.SaveRelationshipType

    
    
    

• Table dbo.RoleGroups (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	RoleGroupID	int	X
  UK , FK	PortalID	int
  UK	RoleGroupName	nvarchar(50)
  	Description	nvarchar(1000)		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_RoleGroups

    • (Primary Key)
    • (Clustered)
    
    
    
    • RoleGroupID
  
  

  • IX_RoleGroupName

    • (Unique)
    
    
    
    • PortalID
    • RoleGroupName
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Referenced by:

  
  

  • dbo.Roles

    
    
    
    • RoleGroupID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddRoleGroup

    
    
    
  • Procedure 

    dbo.DeleteRoleGroup

    
    
    
  • Procedure 

    dbo.GetRoleGroup

    
    
    
  • Procedure 

    dbo.GetRoleGroupByName

    
    
    
  • Procedure 

    dbo.GetRoleGroups

    
    
    
  • Procedure 

    dbo.UpdateRoleGroup

    
    
    

• 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:

  
  

  • PK_Roles

    • (Primary Key)
    • (Clustered)
    
    
    
    • RoleID
  
  

  • IX_RoleName

    • (Unique)
    
    
    
    • PortalID
    • RoleName
  
  

  • IX_Roles_RoleName

    • (Unique)
    
    
    
    • PortalID
    • RoleName
    • RoleID (Included)
  
  

  • IX_Roles

    
    
    
    • BillingFrequency
  
  

  • IX_Roles_RoleGroup

    
    
    
    • RoleGroupID
    • RoleName
    • RoleID (Included)
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  • dbo.RoleGroups

    
    
    
    • RoleGroupID
    
    

  Referenced by:

  
  

  • dbo.DesktopModulePermission

    
    
    
    • RoleID
    
    

  • dbo.FolderPermission

    
    
    
    • RoleID
    
    

  • dbo.ModulePermission

    
    
    
    • RoleID
    
    

  • dbo.TabPermission

    
    
    
    • RoleID
    
    

  • dbo.UserRoles

    
    
    
    • RoleID
    
    

  Used by:

  
  

  • Function 

    dbo.Journal_User_Permissions

    
    
    
  • Procedure 

    dbo.AddRole

    
    
    
  • Procedure 

    dbo.DeleteRole

    
    
    
  • Procedure 

    dbo.GetFoldersByPermissions

    
    
    
  • Procedure 

    dbo.GetPortalRoles

    
    
    
  • Procedure 

    dbo.GetRoles

    
    
    
  • Procedure 

    dbo.GetRolesBasicSearch

    
    
    
  • Procedure 

    dbo.GetServices

    
    
    
  • Procedure 

    dbo.GetUsersByRolename

    
    
    
  • Procedure 

    dbo.IsUserInRole

    
    
    
  • Procedure 

    dbo.Journal_ListForGroup

    
    
    
  • Procedure 

    dbo.UpdateRole

    
    
    
  • View 

    dbo.vw_ContentWorkflowStatePermissions

    
    
    
  • View 

    dbo.vw_DesktopModulePermissions

    
    
    
  • View 

    dbo.vw_FolderPermissions

    
    
    
  • View 

    dbo.vw_ModulePermissions

    
    
    
  • View 

    dbo.vw_TabPermissions

    
    
    
  • View 

    dbo.vw_UserRoles

    
    
    

• Table dbo.RoleSettings (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	RoleSettingID	int	X
  	RoleID	int
  	SettingName	nvarchar(50)
  	SettingValue	nvarchar(2000)
  	CreatedByUserID	int
  	CreatedOnDate	datetime			getdate()
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_RoleSettings

    • (Primary Key)
    • (Clustered)
    
    
    
    • RoleSettingID
  
  

  Used by:

  
  

  • Procedure 

    dbo.GetRoleSettings

    
    
    
  • Procedure 

    dbo.UpdateRoleSetting

    
    
    

• Table dbo.Schedule (10 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ScheduleID	int	X
  	TypeFullName	varchar(200)
  	TimeLapse	int
  	TimeLapseMeasurement	varchar(2)
  	RetryTimeLapse	int
  	RetryTimeLapseMeasurement	varchar(2)
  	RetainHistoryNum	int
  	AttachToEvent	varchar(50)
  	CatchUpEnabled	bit
  	Enabled	bit
  	ObjectDependencies	varchar(300)
  	Servers	nvarchar(2000)		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	FriendlyName	nvarchar(200)		X
  	ScheduleStartDate	datetime		X

  
  

  Indexes:

  
  

  • PK_Schedule

    • (Primary Key)
    • (Clustered)
    
    
    
    • ScheduleID
  
  

  Referenced by:

  
  

  • dbo.ScheduleHistory

    
    
    
    • ScheduleID
    
    

  • dbo.ScheduleItemSettings

    
    
    
    • ScheduleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddSchedule

    
    
    
  • Procedure 

    dbo.DeleteSchedule

    
    
    
  • Procedure 

    dbo.GetSchedule

    
    
    
  • Procedure 

    dbo.GetScheduleByEvent

    
    
    
  • Procedure 

    dbo.GetScheduleByScheduleID

    
    
    
  • Procedure 

    dbo.GetScheduleByTypeFullName

    
    
    
  • Procedure 

    dbo.GetScheduleHistory

    
    
    
  • Procedure 

    dbo.GetScheduleNextTask

    
    
    
  • Procedure 

    dbo.PurgeScheduleHistory

    
    
    
  • Procedure 

    dbo.UpdateSchedule

    
    
    

• Table dbo.ScheduleHistory (5 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ScheduleHistoryID	int	X
  FK	ScheduleID	int
  	StartDate	datetime
  	EndDate	datetime		X
  	Succeeded	bit		X
  	LogNotes	ntext		X
  	NextStart	datetime		X
  	Server	nvarchar(150)		X

  
  

  Indexes:

  
  

  • PK_ScheduleHistory

    • (Primary Key)
    • (Clustered)
    
    
    
    • ScheduleHistoryID
  
  

  • IX_ScheduleHistory_NextStart

    
    
    
    • ScheduleID
    • NextStart (Descending)
  
  

  • IX_ScheduleHistory_StartDate

    
    
    
    • ScheduleID
    • StartDate (Descending)
  
  

  References:

  
  

  • dbo.Schedule

    
    
    
    • ScheduleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddScheduleHistory

    
    
    
  • Procedure 

    dbo.GetSchedule

    
    
    
  • Procedure 

    dbo.GetScheduleHistory

    
    
    
  • Procedure 

    dbo.GetScheduleNextTask

    
    
    
  • Procedure 

    dbo.PurgeScheduleHistory

    
    
    
  • Procedure 

    dbo.UpdateScheduleHistory

    
    
    

• Table dbo.ScheduleItemSettings (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ScheduleID	int
  PK	SettingName	nvarchar(50)
  	SettingValue	nvarchar(max)

  
  

  Indexes:

  
  

  • PK_ScheduleItemSettings

    • (Primary Key)
    • (Clustered)
    
    
    
    • ScheduleID
    • SettingName
  
  

  References:

  
  

  • dbo.Schedule

    
    
    
    • ScheduleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddScheduleItemSetting

    
    
    
  • Procedure 

    dbo.GetScheduleItemSettings

    
    
    

• Table dbo.SearchCommonWords (369 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CommonWordID	int	X
  	CommonWord	nvarchar(255)
  	Locale	nvarchar(10)		X

  
  

  Indexes:

  
  

  • PK_SearchCommonWords

    • (Primary Key)
    • (Clustered)
    
    
    
    • CommonWordID
  
  

  Used by:

  
  

  • Procedure 

    dbo.AddSearchCommonWord

    
    
    
  • Procedure 

    dbo.DeleteSearchCommonWord

    
    
    
  • Procedure 

    dbo.GetSearchCommonWordByID

    
    
    
  • Procedure 

    dbo.GetSearchCommonWordsByLocale

    
    
    
  • Procedure 

    dbo.UpdateSearchCommonWord

    
    
    

• Table dbo.SearchIndexer (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SearchIndexerID	int	X
  	SearchIndexerAssemblyQualifiedName	char(200)

  
  

  Indexes:

  
  

  • PK_SearchIndexer

    • (Primary Key)
    • (Clustered)
    
    
    
    • SearchIndexerID
  
  

  Used by:

  
  

  • Procedure 

    dbo.GetSearchIndexers

    
    
    

• Table dbo.SearchStopWords (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	StopWordsID	int	X
  	StopWords	nvarchar(max)
  	CreatedByUserID	int
  	CreatedOnDate	datetime
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime
  	PortalID	int
  	CultureCode	nvarchar(50)

  
  

  Indexes:

  
  

  • PK_SearchStopWords

    • (Primary Key)
    • (Clustered)
    
    
    
    • StopWordsID
  
  

  Used by:

  
  

  • Procedure 

    dbo.DeleteSearchStopWords

    
    
    
  • Procedure 

    dbo.GetSearchStopWords

    
    
    
  • Procedure 

    dbo.InsertSearchStopWords

    
    
    
  • Procedure 

    dbo.UpdateSearchStopWords

    
    
    

• Table dbo.SearchTypes (3 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SearchTypeId	int	X
  	SearchTypeName	nvarchar(100)
  	SearchResultClass	nvarchar(256)
  	IsPrivate	bit		X	0

  
  

  Indexes:

  
  

  • PK_SearchTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • SearchTypeId
  
  

  Used by:

  
  

  • Procedure 

    dbo.SearchTypes_GetAll

    
    
    

• Table dbo.SiteLog (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SiteLogId	int	X
  	DateTime	smalldatetime
  FK	PortalId	int
  	UserId	int		X
  	Referrer	nvarchar(255)		X
  	Url	nvarchar(255)		X
  	UserAgent	nvarchar(255)		X
  	UserHostAddress	nvarchar(255)		X
  	UserHostName	nvarchar(255)		X
  	TabId	int		X
  	AffiliateId	int		X

  
  

  Indexes:

  
  

  • PK_SiteLog

    • (Primary Key)
    • (Clustered)
    
    
    
    • SiteLogId
  
  

  • IX_SiteLog

    
    
    
    • PortalId
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddSiteLog

    
    
    
  • Procedure 

    dbo.DeleteSiteLog

    
    
    
  • Procedure 

    dbo.GetSiteLog1

    
    
    
  • Procedure 

    dbo.GetSiteLog12

    
    
    
  • Procedure 

    dbo.GetSiteLog2

    
    
    
  • Procedure 

    dbo.GetSiteLog3

    
    
    
  • Procedure 

    dbo.GetSiteLog4

    
    
    
  • Procedure 

    dbo.GetSiteLog5

    
    
    
  • Procedure 

    dbo.GetSiteLog6

    
    
    
  • Procedure 

    dbo.GetSiteLog7

    
    
    
  • Procedure 

    dbo.GetSiteLog8

    
    
    
  • Procedure 

    dbo.GetSiteLog9

    
    
    

• Table dbo.SkinControls (37 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SkinControlID	int	X
  FK	PackageID	int			-1
  	ControlKey	nvarchar(50)		X
  	ControlSrc	nvarchar(256)		X
  	IconFile	nvarchar(100)		X
  	HelpUrl	nvarchar(200)		X
  	SupportsPartialRendering	bit			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_SkinControls

    • (Primary Key)
    • (Clustered)
    
    
    
    • SkinControlID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddSkinControl

    
    
    
  • Procedure 

    dbo.DeleteSkinControl

    
    
    
  • Procedure 

    dbo.GetSkinControl

    
    
    
  • Procedure 

    dbo.GetSkinControlByKey

    
    
    
  • Procedure 

    dbo.GetSkinControlByPackageID

    
    
    
  • Procedure 

    dbo.GetSkinControls

    
    
    
  • Procedure 

    dbo.UpdateSkinControl

    
    
    

• Table dbo.SkinPackages (10 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SkinPackageID	int	X
  FK	PackageID	int
  	PortalID	int		X
  	SkinName	nvarchar(50)
  	SkinType	nvarchar(20)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_SkinPackages

    • (Primary Key)
    • (Clustered)
    
    
    
    • SkinPackageID
  
  

  References:

  
  

  • dbo.Packages

    
    
    
    • PackageID
    
    

  Referenced by:

  
  

  • dbo.Skins

    
    
    
    • SkinPackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddSkinPackage

    
    
    
  • Procedure 

    dbo.DeleteSkinPackage

    
    
    
  • Procedure 

    dbo.GetSkinPackage

    
    
    
  • Procedure 

    dbo.GetSkinPackageByPackageID

    
    
    
  • Procedure 

    dbo.UpdateSkinPackage

    
    
    

• Table dbo.Skins (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SkinID	int	X
  FK	SkinPackageID	int
  	SkinSrc	nvarchar(250)

  
  

  Indexes:

  
  

  • PK_Skins

    • (Primary Key)
    • (Clustered)
    
    
    
    • SkinID
  
  

  References:

  
  

  • dbo.SkinPackages

    
    
    
    • SkinPackageID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddSkin

    
    
    
  • Procedure 

    dbo.DeleteSkin

    
    
    
  • Procedure 

    dbo.GetSkinPackageByPackageID

    
    
    
  • Procedure 

    dbo.UpdateSkin

    
    
    

• Table dbo.SQLQueries (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	QueryId	int	X
  	Name	nvarchar(200)
  	Query	nvarchar(max)
  	ConnectionStringName	nvarchar(50)
  	CreatedByUserId	int
  	CreatedOnDate	datetime
  	LastModifiedByUserId	int
  	LastModifiedOnDate	datetime

  
  

  Indexes:

  
  

  • PK_SavedQueries

    • (Primary Key)
    • (Clustered)
    
    
    
    • QueryId
  
  

• Table dbo.SynonymsGroups (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SynonymsGroupID	int	X
  	SynonymsTags	nvarchar(max)
  	PortalID	int
  	CultureCode	nvarchar(50)
  	CreatedByUserID	int
  	CreatedOnDate	datetime
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime

  
  

  Indexes:

  
  

  • PK_SynonymsGroups

    • (Primary Key)
    • (Clustered)
    
    
    
    • SynonymsGroupID
  
  

  Used by:

  
  

  • Procedure 

    dbo.AddSynonymsGroup

    
    
    
  • Procedure 

    dbo.DeleteSynonymsGroup

    
    
    
  • Procedure 

    dbo.GetAllSynonymsGroups

    
    
    
  • Procedure 

    dbo.UpdateSynonymsGroup

    
    
    

• Table dbo.SystemMessages (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	MessageID	int	X
  UK , FK	PortalID	int		X
  UK	MessageName	nvarchar(50)
  	MessageValue	ntext

  
  

  Indexes:

  
  

  • PK_SystemMessages

    • (Primary Key)
    • (Clustered)
    
    
    
    • MessageID
  
  

  • IX_SystemMessages

    • (Unique)
    
    
    
    • MessageName
    • PortalID
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddSystemMessage

    
    
    
  • Procedure 

    dbo.DeleteSystemMessage

    
    
    
  • Procedure 

    dbo.GetSystemMessage

    
    
    
  • Procedure 

    dbo.GetSystemMessages

    
    
    
  • Procedure 

    dbo.UpdateSystemMessage

    
    
    

• Table dbo.TabAliasSkins (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TabAliasSkinId	int	X
  	TabId	int
  	PortalAliasId	int
  	SkinSrc	nvarchar(200)
  	CreatedByUserId	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserId	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_TabAliasSkin

    • (Primary Key)
    • (Clustered)
    
    
    
    • TabAliasSkinId
  
  

  Used by:

  
  

  • Procedure 

    dbo.GetTabAliasSkins

    
    
    

• Table dbo.TabModules (62 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TabModuleID	int	X
  UK , FK	TabID	int
  UK , FK	ModuleID	int
  	PaneName	nvarchar(50)
  	ModuleOrder	int
  	CacheTime	int
  	Alignment	nvarchar(10)		X
  	Color	nvarchar(20)		X
  	Border	nvarchar(1)		X
  	IconFile	nvarchar(100)		X
  	Visibility	int
  	ContainerSrc	nvarchar(200)		X
  	DisplayTitle	bit			1
  	DisplayPrint	bit			1
  	DisplaySyndicate	bit			1
  	IsWebSlice	bit			0
  	WebSliceTitle	nvarchar(256)		X
  	WebSliceExpiryDate	datetime		X
  	WebSliceTTL	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X	getdate()
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X	getdate()
  	IsDeleted	bit			0
  	CacheMethod	varchar(50)		X
  	ModuleTitle	nvarchar(256)		X
  	Header	nvarchar(max)		X
  	Footer	nvarchar(max)		X
  	CultureCode	nvarchar(10)		X
  UK	UniqueId	uniqueidentifier			newid()
  	VersionGuid	uniqueidentifier			newid()
  	DefaultLanguageGuid	uniqueidentifier		X
  	LocalizedVersionGuid	uniqueidentifier			newid()

  
  

  Indexes:

  
  

  • PK_TabModules

    • (Primary Key)
    • (Clustered)
    
    
    
    • TabModuleID
  
  

  • IX_TabModules_TabID

    • (Unique)
    
    
    
    • TabID
    • ModuleID
    • IsDeleted (Included)
    • CultureCode (Included)
    • ModuleTitle (Included)
  
  

  • IX_TabModules_UniqueId

    • (Unique)
    
    
    
    • UniqueId
  
  

  • IX_TabModules_ModuleID

    
    
    
    • ModuleID
    • TabID
    • IsDeleted (Included)
    • CultureCode (Included)
    • ModuleTitle (Included)
  
  

  • IX_TabModules_ModuleOrder

    
    
    
    • TabID
    • PaneName
    • ModuleOrder
    • TabModuleID (Included)
    • ModuleID (Included)
    • CacheTime (Included)
    • Alignment (Included)
    • Color (Included)
    • Border (Included)
    • IconFile (Included)
    • Visibility (Included)
    • ContainerSrc (Included)
    • DisplayTitle (Included)
    • DisplayPrint (Included)
    • DisplaySyndicate (Included)
    • IsWebSlice (Included)
    • WebSliceTitle (Included)
    • WebSliceExpiryDate (Included)
    • WebSliceTTL (Included)
    • CreatedByUserID (Included)
    • CreatedOnDate (Included)
    • LastModifiedByUserID (Included)
    • LastModifiedOnDate (Included)
    • IsDeleted (Included)
    • CacheMethod (Included)
    • ModuleTitle (Included)
    • Header (Included)
    • Footer (Included)
    • CultureCode (Included)
    • UniqueId (Included)
    • VersionGuid (Included)
    • DefaultLanguageGuid (Included)
    • LocalizedVersionGuid (Included)
  
  

  References:

  
  

  • dbo.Modules

    
    
    
    • ModuleID
    
    

  • dbo.Tabs

    
    
    
    • TabID
    
    

  Referenced by:

  
  

  • dbo.TabModuleSettings

    
    
    
    • TabModuleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddTabModule

    
    
    
  • Procedure 

    dbo.CanDeleteSkin

    
    
    
  • Procedure 

    dbo.DeleteTabModule

    
    
    
  • Procedure 

    dbo.DeleteTranslatedTabs

    
    
    
  • Procedure 

    dbo.GetAllTabsModules

    
    
    
  • Procedure 

    dbo.GetExtensionUrlProviders

    
    
    
  • Procedure 

    dbo.GetModulePermissionsByTabID

    
    
    
  • Procedure 

    dbo.GetModuleSettingsByTab

    
    
    
  • Procedure 

    dbo.GetSearchResultModules

    
    
    
  • Procedure 

    dbo.GetTabModuleOrder

    
    
    
  • Procedure 

    dbo.GetTabModuleSettingsByTab

    
    
    
  • Procedure 

    dbo.GetTabPanes

    
    
    
  • Procedure 

    dbo.GetTabsByModuleID

    
    
    
  • Procedure 

    dbo.GetTabsByTabModuleID

    
    
    
  • Procedure 

    dbo.LocalizeTab

    
    
    
  • Procedure 

    dbo.MoveTabModule

    
    
    
  • Procedure 

    dbo.RestoreTabModule

    
    
    
  • Procedure 

    dbo.UpdateModuleOrder

    
    
    
  • Procedure 

    dbo.UpdateTabModule

    
    
    
  • Procedure 

    dbo.UpdateTabModuleTranslationStatus

    
    
    
  • Procedure 

    dbo.UpdateTabModuleVersion

    
    
    
  • Procedure 

    dbo.UpdateTabModuleVersionByModule

    
    
    
  • View 

    dbo.vw_Modules

    
    
    
  • View 

    dbo.vw_TabModules

    
    
    

• Table dbo.TabModuleSettings (114 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	TabModuleID	int
  PK	SettingName	nvarchar(50)
  	SettingValue	nvarchar(max)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_TabModuleSettings

    • (Primary Key)
    • (Clustered)
    
    
    
    • TabModuleID
    • SettingName
  
  

  References:

  
  

  • dbo.TabModules

    
    
    
    • TabModuleID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddTabModuleSetting

    
    
    
  • Procedure 

    dbo.DeleteTabModuleSetting

    
    
    
  • Procedure 

    dbo.DeleteTabModuleSettings

    
    
    
  • Procedure 

    dbo.GetTabModuleSetting

    
    
    
  • Procedure 

    dbo.GetTabModuleSettings

    
    
    
  • Procedure 

    dbo.GetTabModuleSettingsByTab

    
    
    
  • Procedure 

    dbo.UpdateTabModuleSetting

    
    
    

• Table dbo.TabPermission (67 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TabPermissionID	int	X
  UK , FK	TabID	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_TabPermission

    • (Primary Key)
    • (Clustered)
    
    
    
    • TabPermissionID
  
  

  • IX_TabPermission_Roles

    • (Unique)
    
    
    
    • RoleID
    • TabID
    • PermissionID
    • AllowAccess (Included)
  
  

  • IX_TabPermission_Tabs

    • (Unique)
    
    
    
    • TabID
    • PermissionID
    • RoleID
    • UserID
    • AllowAccess (Included)
  
  

  • IX_TabPermission_Users

    • (Unique)
    
    
    
    • UserID
    • TabID
    • PermissionID
    • AllowAccess (Included)
  
  

  • IX_TabPermission_Permission

    
    
    
    • PermissionID
  
  

  References:

  
  

  • dbo.Permission

    
    
    
    • PermissionID
    
    

  • dbo.Roles

    
    
    
    • RoleID
    
    

  • dbo.Tabs

    
    
    
    • TabID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddTabPermission

    
    
    
  • Procedure 

    dbo.DeleteRole

    
    
    
  • Procedure 

    dbo.DeleteTabPermission

    
    
    
  • Procedure 

    dbo.DeleteTabPermissionsByTabID

    
    
    
  • Procedure 

    dbo.DeleteTabPermissionsByUserID

    
    
    
  • Procedure 

    dbo.UpdateTabPermission

    
    
    
  • View 

    dbo.vw_TabPermissions

    
    
    

• Table dbo.Tabs (44 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TabID	int	X
  	TabOrder	int			0
  FK	PortalID	int		X
  	TabName	nvarchar(200)
  	IsVisible	bit			1
  FK	ParentId	int		X
  	IconFile	nvarchar(100)		X
  	DisableLink	bit			0
  	Title	nvarchar(200)		X
  	Description	nvarchar(500)		X
  	KeyWords	nvarchar(500)		X
  	IsDeleted	bit			0
  	Url	nvarchar(255)		X
  	SkinSrc	nvarchar(200)		X
  	ContainerSrc	nvarchar(200)		X
  	StartDate	datetime		X
  	EndDate	datetime		X
  	RefreshInterval	int		X
  	PageHeadText	nvarchar(max)		X
  	IsSecure	bit			0
  	PermanentRedirect	bit			0
  	SiteMapPriority	float			0.5
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	IconFileLarge	nvarchar(100)		X
  	CultureCode	nvarchar(10)		X
  FK	ContentItemID	int		X
  UK	UniqueId	uniqueidentifier			newid()
  	VersionGuid	uniqueidentifier			newid()
  	DefaultLanguageGuid	uniqueidentifier		X
  	LocalizedVersionGuid	uniqueidentifier			newid()
  	Level	int			0
  	TabPath	nvarchar(255)			''

  
  

  Indexes:

  
  

  • PK_Tabs

    • (Primary Key)
    • (Clustered)
    
    
    
    • TabID
  
  

  • IX_Tabs_UniqueId

    • (Unique)
    
    
    
    • UniqueId
  
  

  • IX_Tabs_ContentID

    
    
    
    • ContentItemID
    • TabID (Included)
    • TabName (Included)
    • Title (Included)
    • IsVisible (Included)
    • IsDeleted (Included)
    • UniqueId (Included)
    • CultureCode (Included)
  
  

  • IX_Tabs_ParentId_IsDeleted

    
    
    
    • ParentId
    • IsDeleted
    • CreatedOnDate (Included)
  
  

  • IX_Tabs_PortalLevelParentOrder

    
    
    
    • PortalID
    • Level
    • ParentId
    • TabOrder
    • IsDeleted
    • TabID (Included)
    • TabName (Included)
    • IsVisible (Included)
    • IconFile (Included)
    • DisableLink (Included)
    • Title (Included)
    • Description (Included)
    • KeyWords (Included)
    • Url (Included)
    • SkinSrc (Included)
    • ContainerSrc (Included)
    • StartDate (Included)
    • EndDate (Included)
    • RefreshInterval (Included)
    • PageHeadText (Included)
    • IsSecure (Included)
    • PermanentRedirect (Included)
    • SiteMapPriority (Included)
    • CreatedByUserID (Included)
    • CreatedOnDate (Included)
    • LastModifiedByUserID (Included)
    • LastModifiedOnDate (Included)
    • IconFileLarge (Included)
    • CultureCode (Included)
    • ContentItemID (Included)
    • UniqueId (Included)
    • VersionGuid (Included)
    • DefaultLanguageGuid (Included)
    • LocalizedVersionGuid (Included)
    • TabPath (Included)
  
  

  References:

  
  

  • dbo.ContentItems

    
    
    
    • ContentItemID
    
    

  • dbo.Portals

    
    
    
    • PortalID
    
    

  • dbo.Tabs

    
    
    
    • TabID (ParentId)
    
    

  Referenced by:

  
  

  • dbo.TabModules

    
    
    
    • TabID
    
    

  • dbo.TabPermission

    
    
    
    • TabID
    
    

  • dbo.Tabs

    
    
    
    • ParentId (TabID)
    
    

  • dbo.TabSettings

    
    
    
    • TabID
    
    

  • dbo.TabUrls

    
    
    
    • TabId (TabID)
    
    

  Used by:

  
  

  • Function 

    dbo.HasChildTab

    
    
    
  • Function 

    dbo.SuperUserTabID

    
    
    
  • Procedure 

    dbo.AddTab

    
    
    
  • Procedure 

    dbo.AddTabAfter

    
    
    
  • Procedure 

    dbo.AddTabBefore

    
    
    
  • Procedure 

    dbo.AddTabToEnd

    
    
    
  • Procedure 

    dbo.BuildTabLevelAndPath

    
    
    
  • Procedure 

    dbo.CanDeleteSkin

    
    
    
  • Procedure 

    dbo.ConvertTabToNeutralLanguage

    
    
    
  • Procedure 

    dbo.DeleteTab

    
    
    
  • Procedure 

    dbo.DeleteTabPermissionsByUserID

    
    
    
  • Procedure 

    dbo.DeleteTranslatedTabs

    
    
    
  • Procedure 

    dbo.EnsureNeutralLanguage

    
    
    
  • Procedure 

    dbo.GetModuleByDefinition

    
    
    
  • Procedure 

    dbo.GetModulePackagesInUse

    
    
    
  • Procedure 

    dbo.GetModulePermissionsByTabID

    
    
    
  • Procedure 

    dbo.GetSearchModules

    
    
    
  • Procedure 

    dbo.GetSearchResultModules

    
    
    
  • Procedure 

    dbo.GetSiteLog2

    
    
    
  • Procedure 

    dbo.GetSiteLog9

    
    
    
  • Procedure 

    dbo.GetTabCustomAliases

    
    
    
  • Procedure 

    dbo.GetTabSettings

    
    
    
  • Procedure 

    dbo.GetTabUrls

    
    
    
  • Procedure 

    dbo.LocalizeTab

    
    
    
  • Procedure 

    dbo.MoveTabAfter

    
    
    
  • Procedure 

    dbo.MoveTabBefore

    
    
    
  • Procedure 

    dbo.MoveTabToParent

    
    
    
  • Procedure 

    dbo.UpdateTab

    
    
    
  • Procedure 

    dbo.UpdateTabOrder

    
    
    
  • Procedure 

    dbo.UpdateTabTranslationStatus

    
    
    
  • Procedure 

    dbo.UpdateTabVersion

    
    
    
  • View 

    dbo.vw_Modules

    
    
    
  • View 

    dbo.vw_TabModules

    
    
    
  • View 

    dbo.vw_TabPermissions

    
    
    
  • View 

    dbo.vw_Tabs

    
    
    

• Table dbo.TabSettings (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, UK , FK	TabID	int
  PK, UK	SettingName	nvarchar(50)
  	SettingValue	nvarchar(2000)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_TabSettings

    • (Primary Key)
    
    
    
    • TabID
    • SettingName
  
  

  • IX_TabSettings_TabID_SettingName

    • (Unique)
    • (Clustered)
    
    
    
    • TabID
    • SettingName
  
  

  References:

  
  

  • dbo.Tabs

    
    
    
    • TabID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddTabSetting

    
    
    
  • Procedure 

    dbo.DeleteTabSetting

    
    
    
  • Procedure 

    dbo.DeleteTabSettings

    
    
    
  • Procedure 

    dbo.GetTabSetting

    
    
    
  • Procedure 

    dbo.GetTabSettings

    
    
    
  • Procedure 

    dbo.UpdateTabSetting

    
    
    

• Table dbo.TabUrls (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	TabId	int
  PK	SeqNum	int
  	Url	nvarchar(200)
  	QueryString	nvarchar(200)		X
  	HttpStatus	nvarchar(50)
  	CultureCode	nvarchar(50)		X
  	IsSystem	bit			0
  	PortalAliasId	int		X
  	PortalAliasUsage	int		X
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_TabRedirect

    • (Primary Key)
    • (Clustered)
    
    
    
    • TabId
    • SeqNum
  
  

  References:

  
  

  • dbo.Tabs

    
    
    
    • TabID (TabId)
    
    

  Used by:

  
  

  • Procedure 

    dbo.DeleteTabUrl

    
    
    
  • Procedure 

    dbo.GetCustomAliasesForTabs

    
    
    
  • Procedure 

    dbo.GetTabCustomAliases

    
    
    
  • Procedure 

    dbo.GetTabUrls

    
    
    
  • Procedure 

    dbo.SaveTabUrl

    
    
    

• Table dbo.Taxonomy_ScopeTypes (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ScopeTypeID	int	X
  	ScopeType	nvarchar(250)		X

  
  

  Indexes:

  
  

  • PK_ScopeTypes

    • (Primary Key)
    • (Clustered)
    
    
    
    • ScopeTypeID
  
  

  Referenced by:

  
  

  • dbo.Taxonomy_Vocabularies

    
    
    
    • ScopeTypeID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddScopeType

    
    
    
  • Procedure 

    dbo.DeleteScopeType

    
    
    
  • Procedure 

    dbo.GetScopeTypes

    
    
    
  • Procedure 

    dbo.UpdateScopeType

    
    
    

• Table dbo.Taxonomy_Terms (4 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TermID	int	X
  FK	VocabularyID	int
  FK	ParentTermID	int		X
  	Name	nvarchar(250)
  	Description	nvarchar(2500)		X
  	Weight	int			0
  	TermLeft	int			0
  	TermRight	int			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_Taxonomy_Terms

    • (Primary Key)
    • (Clustered)
    
    
    
    • TermID
  
  

  References:

  
  

  • dbo.Taxonomy_Terms

    
    
    
    • TermID (ParentTermID)
    
    

  • dbo.Taxonomy_Vocabularies

    
    
    
    • VocabularyID
    
    

  Referenced by:

  
  

  • dbo.ContentItems_Tags

    
    
    
    • TermID
    
    

  • dbo.Taxonomy_Terms

    
    
    
    • ParentTermID (TermID)
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddHeirarchicalTerm

    
    
    
  • Procedure 

    dbo.AddSimpleTerm

    
    
    
  • Procedure 

    dbo.DeleteHeirarchicalTerm

    
    
    
  • Procedure 

    dbo.DeleteSimpleTerm

    
    
    
  • Procedure 

    dbo.GetContentItemsByTerm

    
    
    
  • Procedure 

    dbo.GetContentItemsByVocabularyId

    
    
    
  • Procedure 

    dbo.GetTerm

    
    
    
  • Procedure 

    dbo.GetTermsByContent

    
    
    
  • Procedure 

    dbo.GetTermsByVocabulary

    
    
    
  • Procedure 

    dbo.GetTermUsage

    
    
    
  • Procedure 

    dbo.UpdateHeirarchicalTerm

    
    
    
  • Procedure 

    dbo.UpdateSimpleTerm

    
    
    

• Table dbo.Taxonomy_Vocabularies (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	VocabularyID	int	X
  FK	VocabularyTypeID	int
  	Name	nvarchar(250)
  	Description	nvarchar(2500)		X
  	Weight	int			0
  	ScopeID	int		X
  FK	ScopeTypeID	int
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	IsSystem	bit			0

  
  

  Indexes:

  
  

  • PK_Taxonomy_Vocabulary

    • (Primary Key)
    • (Clustered)
    
    
    
    • VocabularyID
  
  

  References:

  
  

  • dbo.Taxonomy_ScopeTypes

    
    
    
    • ScopeTypeID
    
    

  • dbo.Taxonomy_VocabularyTypes

    
    
    
    • VocabularyTypeID
    
    

  Referenced by:

  
  

  • dbo.Taxonomy_Terms

    
    
    
    • VocabularyID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddVocabulary

    
    
    
  • Procedure 

    dbo.DeleteVocabulary

    
    
    
  • Procedure 

    dbo.GetVocabularies

    
    
    
  • Procedure 

    dbo.UpdateVocabulary

    
    
    

• Table dbo.Taxonomy_VocabularyTypes (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	VocabularyTypeID	int	X
  	VocabularyType	nvarchar(50)

  
  

  Indexes:

  
  

  • PK_Taxonomy_VocabularyType

    • (Primary Key)
    • (Clustered)
    
    
    
    • VocabularyTypeID
  
  

  Referenced by:

  
  

  • dbo.Taxonomy_Vocabularies

    
    
    
    • VocabularyTypeID
    
    

• Table dbo.UrlLog (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UrlLogID	int	X
  FK	UrlTrackingID	int
  	ClickDate	datetime
  	UserID	int		X

  
  

  Indexes:

  
  

  • PK_UrlLog

    • (Primary Key)
    • (Clustered)
    
    
    
    • UrlLogID
  
  

  References:

  
  

  • dbo.UrlTracking

    
    
    
    • UrlTrackingID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddUrlLog

    
    
    

• Table dbo.Urls (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UrlID	int	X
  UK , FK	PortalID	int		X
  UK	Url	nvarchar(255)

  
  

  Indexes:

  
  

  • PK_Urls

    • (Primary Key)
    • (Clustered)
    
    
    
    • UrlID
  
  

  • IX_Urls

    • (Unique)
    
    
    
    • Url
    • PortalID
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddUrl

    
    
    
  • Procedure 

    dbo.DeleteUrl

    
    
    
  • Procedure 

    dbo.GetUrl

    
    
    
  • Procedure 

    dbo.GetUrls

    
    
    

• Table dbo.UrlTracking (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UrlTrackingID	int	X
  UK , FK	PortalID	int		X
  UK	Url	nvarchar(255)
  	UrlType	char(1)
  	Clicks	int
  	LastClick	datetime		X
  	CreatedDate	datetime
  	LogActivity	bit
  	TrackClicks	bit			1
  UK	ModuleId	int		X
  	NewWindow	bit			0

  
  

  Indexes:

  
  

  • PK_UrlTracking

    • (Primary Key)
    • (Clustered)
    
    
    
    • UrlTrackingID
  
  

  • IX_UrlTracking

    • (Unique)
    
    
    
    • PortalID
    • Url
    • ModuleId
  
  

  • IX_UrlTracking_ModuleId

    
    
    
    • ModuleId
  
  

  • IX_UrlTracking_Url_ModuleId

    
    
    
    • Url
    • ModuleId
    • TrackClicks (Included)
    • NewWindow (Included)
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  Referenced by:

  
  

  • dbo.UrlLog

    
    
    
    • UrlTrackingID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddUrlTracking

    
    
    
  • Procedure 

    dbo.DeleteUrlTracking

    
    
    
  • Procedure 

    dbo.GetUrlTracking

    
    
    
  • Procedure 

    dbo.UpdateUrlTracking

    
    
    
  • Procedure 

    dbo.UpdateUrlTrackingStats

    
    
    

• Table dbo.UserAuthentication (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UserAuthenticationID	int	X
  UK , FK	UserID	int
  UK	AuthenticationType	nvarchar(100)
  	AuthenticationToken	nvarchar(1000)
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X

  
  

  Indexes:

  
  

  • PK_UserAuthentication

    • (Primary Key)
    • (Clustered)
    
    
    
    • UserAuthenticationID
  
  

  • IX_UserAuthentication

    • (Unique)
    
    
    
    • UserID
    • AuthenticationType
  
  

  References:

  
  

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddUserAuthentication

    
    
    
  • Procedure 

    dbo.DeleteAuthentication

    
    
    
  • Procedure 

    dbo.GetUserAuthentication

    
    
    
  • Procedure 

    dbo.GetUserByAuthToken

    
    
    

• Table dbo.UserPortals (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	UserId	int
  PK, FK	PortalId	int
  	UserPortalId	int	X
  	CreatedDate	datetime			getdate()
  	Authorised	bit			1
  	IsDeleted	bit			0
  	RefreshRoles	bit			0
  	VanityUrl	nvarchar(100)		X

  
  

  Indexes:

  
  

  • PK_UserPortals

    • (Primary Key)
    • (Clustered)
    
    
    
    • UserId
    • PortalId
  
  

  • IX_UserPortals

    
    
    
    • PortalId
  
  

  • IX_UserPortals_PortalId_IsDeleted

    
    
    
    • PortalId
    • IsDeleted
  
  

  • IX_UserPortals_VanityUrl

    
    
    
    • VanityUrl
    • UserId (Included)
    • PortalId (Included)
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  • dbo.Users

    
    
    
    • UserID (UserId)
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddUser

    
    
    
  • Procedure 

    dbo.AddUserPortal

    
    
    
  • Procedure 

    dbo.DeleteUserPortal

    
    
    
  • Procedure 

    dbo.GetOnlineUsers

    
    
    
  • Procedure 

    dbo.GetPortalsByUser

    
    
    
  • Procedure 

    dbo.GetUserCountByPortal

    
    
    
  • Procedure 

    dbo.GetUsersByRolename

    
    
    
  • Procedure 

    dbo.RemoveUser

    
    
    
  • Procedure 

    dbo.RestoreUser

    
    
    
  • Procedure 

    dbo.UpdateUser

    
    
    
  • View 

    dbo.vw_Users

    
    
    

• Table dbo.UserProfile (6 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProfileID	int	X
  FK	UserID	int
  FK	PropertyDefinitionID	int
  	PropertyValue	nvarchar(3750)		X
  	PropertyText	nvarchar(max)		X
  	Visibility	int			0
  	LastUpdatedDate	datetime
  	ExtendedVisibility	varchar(400)		X

  
  

  Indexes:

  
  

  • PK_UserProfile

    • (Primary Key)
    • (Clustered)
    
    
    
    • ProfileID
  
  

  • IX_UserProfile

    
    
    
    • UserID
  
  

  • IX_UserProfile_LastUpdatedDate

    
    
    
    • LastUpdatedDate (Descending)
    • UserID (Included)
  
  

  • IX_UserProfile_PropertyDefinitionID

    
    
    
    • PropertyDefinitionID
    • ProfileID (Included)
    • UserID (Included)
    • PropertyValue (Included)
  
  

  • IX_UserProfile_UserID_PropertyDefinitionID

    
    
    
    • UserID
    • PropertyDefinitionID
  
  

  • IX_UserProfile_Visibility

    
    
    
    • UserID
    • ProfileID
    • PropertyDefinitionID (Included)
    • PropertyValue (Included)
    • PropertyText (Included)
    • Visibility (Included)
    • LastUpdatedDate (Included)
    • ExtendedVisibility (Included)
  
  

  References:

  
  

  • dbo.ProfilePropertyDefinition

    
    
    
    • PropertyDefinitionID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.GetUserProfile

    
    
    
  • Procedure 

    dbo.UpdateUserProfileProperty

    
    
    
  • View 

    dbo.vw_Profile

    
    
    

• Table dbo.UserRelationshipPreferences (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PreferenceID	int	X
  FK	UserID	int
  PK, FK	RelationshipID	int
  	DefaultResponse	int
  	CreatedByUserID	int
  	CreatedOnDate	datetime			getdate()
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_UserRelationshipPreferences

    • (Primary Key)
    • (Clustered)
    
    
    
    • PreferenceID
    • RelationshipID
  
  

  References:

  
  

  • dbo.Relationships

    
    
    
    • RelationshipID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.DeleteUserRelationshipPreference

    
    
    
  • Procedure 

    dbo.GetUserRelationshipPreference

    
    
    
  • Procedure 

    dbo.GetUserRelationshipPreferenceByID

    
    
    
  • Procedure 

    dbo.SaveUserRelationshipPreference

    
    
    

• Table dbo.UserRelationships (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UserRelationshipID	int	X
  UK , FK	UserID	int
  UK , FK	RelatedUserID	int
  UK , FK	RelationshipID	int
  	Status	int
  	CreatedByUserID	int
  	CreatedOnDate	datetime			getdate()
  	LastModifiedByUserID	int
  	LastModifiedOnDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_UserRelationships

    • (Primary Key)
    • (Clustered)
    
    
    
    • UserRelationshipID
  
  

  • IX_UserRelationships_UserID_RelatedUserID_RelationshipID

    • (Unique)
    
    
    
    • UserID
    • RelatedUserID
    • RelationshipID
  
  

  • IX_UserRelationships_RelatedUserID

    
    
    
    • RelatedUserID
  
  

  • IX_UserRelationships_UserID

    
    
    
    • UserID
  
  

  References:

  
  

  • dbo.Relationships

    
    
    
    • RelationshipID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  • dbo.Users

    
    
    
    • UserID (RelatedUserID)
    
    

  Used by:

  
  

  • Function 

    dbo.Journal_User_Permissions

    
    
    
  • Procedure 

    dbo.DeleteUserRelationship

    
    
    
  • Procedure 

    dbo.GetUserRelationship

    
    
    
  • Procedure 

    dbo.GetUserRelationships

    
    
    
  • Procedure 

    dbo.GetUserRelationshipsByMultipleIDs

    
    
    
  • Procedure 

    dbo.SaveUserRelationship

    
    
    

• 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

    
    
    

• Table dbo.Users (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UserID	int	X
  UK	Username	nvarchar(100)
  	FirstName	nvarchar(50)
  	LastName	nvarchar(50)
  	IsSuperUser	bit			0
  	AffiliateId	int		X
  	Email	nvarchar(256)		X
  	DisplayName	nvarchar(128)			''
  	UpdatePassword	bit			0
  	LastIPAddress	nvarchar(50)		X
  	IsDeleted	bit			0
  	CreatedByUserID	int		X
  	CreatedOnDate	datetime		X
  	LastModifiedByUserID	int		X
  	LastModifiedOnDate	datetime		X
  	PasswordResetToken	uniqueidentifier		X
  	PasswordResetExpiration	datetime		X
  	LowerEmail	nvarchar(256)		X

  
  

  Indexes:

  
  

  • PK_Users

    • (Primary Key)
    • (Clustered)
    
    
    
    • UserID
  
  

  • IX_Users

    • (Unique)
    
    
    
    • Username
  
  

  • IX_Users_Email

    
    
    
    • Email
  
  

  • IX_Users_IsDeleted_DisplayName

    
    
    
    • IsDeleted
    • DisplayName
    • UserID (Included)
    • IsSuperUser (Included)
    • Email (Included)
  
  

  • IX_Users_LastModifiedOnDate

    
    
    
    • LastModifiedOnDate (Descending)
    • UserID (Included)
    • IsSuperUser (Included)
  
  

  • IX_Users_LowerEmail

    
    
    
    • Email
  
  

  Referenced by:

  
  

  • dbo.ContentWorkflowStatePermission

    
    
    
    • UserID
    
    

  • dbo.CoreMessaging_Subscriptions

    
    
    
    • UserId (UserID)
    
    

  • dbo.DesktopModulePermission

    
    
    
    • UserID
    
    

  • dbo.FolderPermission

    
    
    
    • UserID
    
    

  • dbo.ModulePermission

    
    
    
    • UserID
    
    

  • dbo.PasswordHistory

    
    
    
    • UserID
    
    

  • dbo.Profile

    
    
    
    • UserId (UserID)
    
    

  • dbo.Relationships

    
    
    
    • UserID
    
    

  • dbo.TabPermission

    
    
    
    • UserID
    
    

  • dbo.UserAuthentication

    
    
    
    • UserID
    
    

  • dbo.UserPortals

    
    
    
    • UserId (UserID)
    
    

  • dbo.UserProfile

    
    
    
    • UserID
    
    

  • dbo.UserRelationshipPreferences

    
    
    
    • UserID
    
    

  • dbo.UserRelationships

    
    
    
    • UserID
    
    

  • dbo.UserRelationships

    
    
    
    • RelatedUserID (UserID)
    
    

  • dbo.UserRoles

    
    
    
    • UserID
    
    

  • dbo.UsersOnline

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Function 

    dbo.Journal_User_Permissions

    
    
    
  • Function 

    dbo.UserDisplayName

    
    
    
  • Procedure 

    dbo.AddUser

    
    
    
  • Procedure 

    dbo.ChangeUsername

    
    
    
  • Procedure 

    dbo.DeleteUserPortal

    
    
    
  • Procedure 

    dbo.GetAllHtmlText

    
    
    
  • Procedure 

    dbo.GetBanner

    
    
    
  • Procedure 

    dbo.GetFoldersByPermissions

    
    
    
  • Procedure 

    dbo.GetHtmlText

    
    
    
  • Procedure 

    dbo.GetHtmlTextLog

    
    
    
  • Procedure 

    dbo.GetOnlineUser

    
    
    
  • Procedure 

    dbo.GetServices

    
    
    
  • Procedure 

    dbo.GetSiteLog2

    
    
    
  • Procedure 

    dbo.GetSiteLog3

    
    
    
  • Procedure 

    dbo.GetTopHtmlText

    
    
    
  • Procedure 

    dbo.GetUsersByRolename

    
    
    
  • Procedure 

    dbo.GetVendor

    
    
    
  • Procedure 

    dbo.Journal_Comment_Get

    
    
    
  • Procedure 

    dbo.Journal_Comment_List

    
    
    
  • Procedure 

    dbo.Journal_Comment_ListByJournalIds

    
    
    
  • Procedure 

    dbo.Journal_Get

    
    
    
  • Procedure 

    dbo.Journal_GetByKey

    
    
    
  • Procedure 

    dbo.Journal_GetSearchItems

    
    
    
  • Procedure 

    dbo.Journal_LikeList

    
    
    
  • Procedure 

    dbo.Journal_ListForGroup

    
    
    
  • Procedure 

    dbo.Journal_ListForProfile

    
    
    
  • Procedure 

    dbo.Journal_ListForSummary

    
    
    
  • Procedure 

    dbo.Messaging_Save_Message

    
    
    
  • Procedure 

    dbo.RemoveUser

    
    
    
  • Procedure 

    dbo.RestoreUser

    
    
    
  • Procedure 

    dbo.UpdateOnlineUser

    
    
    
  • Procedure 

    dbo.UpdateUser

    
    
    
  • View 

    dbo.vw_ContentWorkflowStatePermissions

    
    
    
  • View 

    dbo.vw_DesktopModulePermissions

    
    
    
  • View 

    dbo.vw_FolderPermissions

    
    
    
  • View 

    dbo.vw_ModulePermissions

    
    
    
  • View 

    dbo.vw_Portals

    
    
    
  • View 

    dbo.vw_TabPermissions

    
    
    
  • View 

    dbo.vw_UserRoles

    
    
    
  • View 

    dbo.vw_Users

    
    
    

• Table dbo.UsersOnline (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	UserID	int
  PK, FK	PortalID	int
  	TabID	int
  	CreationDate	datetime			getdate()
  	LastActiveDate	datetime			getdate()

  
  

  Indexes:

  
  

  • PK_UsersOnline

    • (Primary Key)
    • (Clustered)
    
    
    
    • UserID
    • PortalID
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID
    
    

  • dbo.Users

    
    
    
    • UserID
    
    

  Used by:

  
  

  • Procedure 

    dbo.DeleteUsersOnline

    
    
    
  • Procedure 

    dbo.GetOnlineUser

    
    
    
  • Procedure 

    dbo.GetOnlineUsers

    
    
    
  • Procedure 

    dbo.UpdateOnlineUser

    
    
    

• Table dbo.VendorClassification (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	VendorClassificationId	int	X
  UK , FK	VendorId	int
  UK , FK	ClassificationId	int

  
  

  Indexes:

  
  

  • PK_VendorClassification

    • (Primary Key)
    • (Clustered)
    
    
    
    • VendorClassificationId
  
  

  • IX_VendorClassification

    • (Unique)
    
    
    
    • VendorId
    • ClassificationId
  
  

  • IX_VendorClassification_1

    
    
    
    • ClassificationId
  
  

  References:

  
  

  • dbo.Classification

    
    
    
    • ClassificationId
    
    

  • dbo.Vendors

    
    
    
    • VendorId
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddVendorClassification

    
    
    
  • Procedure 

    dbo.DeleteVendorClassifications

    
    
    
  • Procedure 

    dbo.GetVendorClassifications

    
    
    

• Table dbo.Vendors (0 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	VendorId	int	X
  UK	VendorName	nvarchar(50)
  	Street	nvarchar(50)		X
  	City	nvarchar(50)		X
  	Region	nvarchar(50)		X
  	Country	nvarchar(50)		X
  	PostalCode	nvarchar(50)		X
  	Telephone	nvarchar(50)		X
  UK , FK	PortalId	int		X
  	Fax	nvarchar(50)		X
  	Email	nvarchar(50)		X
  	Website	nvarchar(100)		X
  	ClickThroughs	int			0
  	Views	int			0
  	CreatedByUser	nvarchar(100)		X
  	CreatedDate	datetime		X
  	LogoFile	nvarchar(100)		X
  	KeyWords	ntext		X
  	Unit	nvarchar(50)		X
  	Authorized	bit			1
  	FirstName	nvarchar(50)		X
  	LastName	nvarchar(50)		X
  	Cell	varchar(50)		X

  
  

  Indexes:

  
  

  • PK_Vendor

    • (Primary Key)
    • (Clustered)
    
    
    
    • VendorId
  
  

  • IX_Vendors

    • (Unique)
    
    
    
    • PortalId
    • VendorName
  
  

  References:

  
  

  • dbo.Portals

    
    
    
    • PortalID (PortalId)
    
    

  Referenced by:

  
  

  • dbo.Affiliates

    
    
    
    • VendorId
    
    

  • dbo.Banners

    
    
    
    • VendorId
    
    

  • dbo.VendorClassification

    
    
    
    • VendorId
    
    

  Used by:

  
  

  • Procedure 

    dbo.AddVendor

    
    
    
  • Procedure 

    dbo.DeleteVendor

    
    
    
  • Procedure 

    dbo.FindBanners

    
    
    
  • Procedure 

    dbo.GetBanner

    
    
    
  • Procedure 

    dbo.GetBannerGroups

    
    
    
  • Procedure 

    dbo.GetVendor

    
    
    
  • Procedure 

    dbo.UpdateVendor

    
    
    

• Table dbo.Version (16 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	VersionId	int	X
  UK	Major	int
  UK	Minor	int
  UK	Build	int
  	Name	nvarchar(50)		X
  	CreatedDate	datetime

  
  

  Indexes:

  
  

  • PK_Version

    • (Primary Key)
    • (Clustered)
    
    
    
    • VersionId
  
  

  • IX_Version

    • (Unique)
    
    
    
    • Major
    • Minor
    • Build
  
  

  Used by:

  
  

  • Function 

    dbo.fn_GetVersion

    
    
    
  • Procedure 

    dbo.FindDatabaseVersion

    
    
    
  • Procedure 

    dbo.GetDatabaseInstallVersion

    
    
    
  • Procedure 

    dbo.GetDatabaseVersion

    
    
    
  • Procedure 

    dbo.UpdateDatabaseVersion

    
    
    
  • Procedure 

    dbo.UpdateDatabaseVersionAndName

    
    
    

• Table dbo.WebServers (1 row)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ServerID	int	X
  UK	ServerName	nvarchar(50)
  	CreatedDate	datetime
  	LastActivityDate	datetime
  	URL	nvarchar(255)		X
  UK	IISAppName	nvarchar(200)			''
  	Enabled	bit			1
  	ServerGroup	nvarchar(200)		X
  	UniqueId	nvarchar(200)		X
  	PingFailureCount	int			0

  
  

  Indexes:

  
  

  • PK_WebServers

    • (Primary Key)
    • (Clustered)
    
    
    
    • ServerID
  
  

  • IX_WebServers_ServerName

    • (Unique)
    
    
    
    • ServerName
    • IISAppName
  
  

  Used by:

  
  

  • Procedure 

    dbo.DeleteServer

    
    
    
  • Procedure 

    dbo.GetServers

    
    
    
  • Procedure 

    dbo.UpdateServer

    
    
    
  • Procedure 

    dbo.UpdateServerActivity

    
    
    

• Table dbo.Workflow (2 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	WorkflowID	int	X
  UK	PortalID	int		X
  UK	WorkflowName	nvarchar(50)
  	Description	nvarchar(2000)		X
  	IsDeleted	bit

  
  

  Indexes:

  
  

  • PK_Workflow

    • (Primary Key)
    • (Clustered)
    
    
    
    • WorkflowID
  
  

  • IX_Workflow

    • (Unique)
    
    
    
    • PortalID
    • WorkflowName
  
  

  Referenced by:

  
  

  • dbo.WorkflowStates

    
    
    
    • WorkflowID
    
    

  Used by:

  
  

  • Procedure 

    dbo.GetAllHtmlText

    
    
    
  • Procedure 

    dbo.GetHtmlText

    
    
    
  • Procedure 

    dbo.GetTopHtmlText

    
    
    
  • Procedure 

    dbo.GetWorkflows

    
    
    
  • Procedure 

    dbo.GetWorkflowStates

    
    
    

• Table dbo.WorkflowStates (3 rows)

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	StateID	int	X
  UK , FK	WorkflowID	int
  UK	StateName	nvarchar(50)
  	Order	int
  	IsActive	bit
  	Notify	bit

  
  

  Indexes:

  
  

  • PK_WorkflowStates

    • (Primary Key)
    • (Clustered)
    
    
    
    • StateID
  
  

  • IX_WorkflowStates

    • (Unique)
    
    
    
    • WorkflowID
    • StateName
  
  

  References:

  
  

  • dbo.Workflow

    
    
    
    • WorkflowID
    
    

  Referenced by:

  
  

  • dbo.HtmlText

    
    
    
    • StateID
    
    

  • dbo.HtmlTextLog

    
    
    
    • StateID
    
    

  Used by:

  
  

  • Procedure 

    dbo.GetAllHtmlText

    
    
    
  • Procedure 

    dbo.GetHtmlText

    
    
    
  • Procedure 

    dbo.GetHtmlTextLog

    
    
    
  • Procedure 

    dbo.GetHtmlTextUser

    
    
    
  • Procedure 

    dbo.GetTopHtmlText

    
    
    
  • Procedure 

    dbo.GetWorkflowStates