.

Generated using SQL Data Dictionary demo version.

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