DocumentExportMessages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
ReferralId int 4 null
Referrals.Id FK_dbo.DocumentExportMessages_dbo.Referrals_ReferralIdC
LibraryFileId int 4 null
LibraryFiles.Id FK_dbo.DocumentExportMessages_dbo.LibraryFiles_LibraryFileIdC
StatusTypeId int 4 null
DocumentExportMessageStatusTypes.Id FK_dbo.DocumentExportMessages_dbo.DocumentExportMessageStatusTypes_StatusTypeIdC
Content nvarchar 1073741823 √ null
DateSent datetime 16,3 null
DateProcessed datetime 16,3 √ null
ErrorDetails nvarchar 1073741823 √ null
DocumentId uniqueidentifier 16 null
UserId nvarchar 256 √ null
AspNetUsers.Id FK_dbo.DocumentExportMessages_dbo.AspNetUsers_UserIdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.DocumentExportMessages Primary key Asc Id
IX_LibraryFileId Performance Asc LibraryFileId
IX_ReferralId Performance Asc ReferralId
IX_StatusTypeId Performance Asc StatusTypeId
IX_UserId Performance Asc UserId

Relationships

Close relationships within degrees of separation