.

Generated using SQL Data Dictionary demo version.

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