Tables [dbo].[Inbound_Document]
Inbound documents coming from an external source. Currently, this will only hold referrals coming from non-Allscripts sources.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Inbound_Document_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Inbound_Document table.
Foreign Keys FK_Inbound_Document_DoumentID_Document_ID: [dbo].[Document].DocumentIDDocumentID[dbo].[uniqueid]9NULL allowedDocument. Link to Document.DocumentID
Cluster Key cix_inbound_document_submissionsetid: SubmissionSetIdForeign Keys FK_Inbound_Document_SubmissionSetID_Inbound_SubmissionSet_ID: [dbo].[Inbound_SubmissionSet].SubmissionSetIdSubmissionSetId[dbo].[uniqueid]9NOT NULLSubmission Set. Link to Inbound_SubmissionSet.ID.
Foreign Keys FK_Inbound_Document_DocumentTypeDE_Document_Type_DE_ID: [dbo].[Document_Type_de].DocumentTypeDEDocumentTypeDE[dbo].[dict_id]5NOT NULLDocument Type. Link to Document_Type_DE.ID.
IsSavedbit1NOT NULL((0))Filed?
SavedDTTMdatetime8NULL allowedSaved time
DocumentXMLCompressedvarbinary(max)maxNULL allowedCompressed Document
DocumentBinaryChunkvarbinary(max)maxNULL allowedCompressed Binary Document
DocumentHTMLCompressedvarbinary(max)maxNULL allowedCompressed HTML Document.
RootDocumentIDvarchar(255)255NULL allowedRoot document identifier passed in the direct message