Generated using SQL Data Dictionary demo version.


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:


References:


Referenced by:


Used by: