LibraryFiles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
DocumentActions.LibraryFileId FK_dbo.DocumentActions_dbo.LibraryFiles_LibraryFileIdR
DocumentExportMessages.LibraryFileId FK_dbo.DocumentExportMessages_dbo.LibraryFiles_LibraryFileIdC
LibraryResource.Id FK_dbo.LibraryResource_dbo.LibraryFiles_IdR
LibraryTemplate.Id FK_dbo.LibraryLetterTemplate_dbo.LibraryFiles_IdR
FileName nvarchar 1073741823 null
Description nvarchar 1073741823 null
DateUploaded datetime 16,3 null
Content varbinary 2147483647 null
DateDeleted datetime 16,3 √ null
CancerSiteId int 4 ((0))
CancerSites.Id FK_dbo.LibraryFiles_dbo.CancerSites_CancerSiteIdC

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.LibraryFiles Primary key Asc Id
IX_CancerSiteId Performance Asc CancerSiteId

Relationships

Close relationships within degrees of separation