.

Generated using SQL Data Dictionary demo version.

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