Tables [dbo].[Referral_Document]
Referral documents from both requests and responses
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Referral_Document_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Referral_Document table.
DocumentChunkvarbinary(max)maxNULL allowedDocument text received from external source or from internal source while sending to recipients.
DocumentBinaryChunkvarbinary(max)maxNULL allowedThis is used to store binary data for the PDF documents.
Foreign Keys FK_Referral_Document_DocumentTypeDE: [dbo].[Document_Type_de].DocumentTypeDEDocumentTypeDE[dbo].[dict_id]5NOT NULL((0))Document Type. Key to the document_type_de table
Foreign Keys FK_Referral_Document_PhysicalManifestationDE: [dbo].[PhysicalManifestation_DE].PhysicalManifestationDEPhysicalManifestationDE[dbo].[dict_id]5NOT NULL((0))Format of document. Key to the PhysicalManifestation_DE table.
EditableDocumentChunkvarbinary(max)maxNULL allowedStore converted RTF documents received from external/internal system.