Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Referral_Document
Touchworks 25.2
[dbo].[Referral_Document]
MS_Description
Referral documents from both requests and responses
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Referral_Document table.
DocumentChunk
varbinary(max)
max
NULL allowed
Document text received from external source or from internal source while sending to recipients.
DocumentBinaryChunk
varbinary(max)
max
NULL allowed
This is used to store binary data for the PDF documents.
DocumentTypeDE
[dbo].[dict_id]
5
NOT NULL
((0))
Document Type. Key to the document_type_de table
PhysicalManifestationDE
[dbo].[dict_id]
5
NOT NULL
((0))
Format of document. Key to the PhysicalManifestation_DE table.
EditableDocumentChunk
varbinary(max)
max
NULL allowed
Store converted RTF documents received from external/internal system.