Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Document_Annotation
Touchworks 25.2
[dbo].[Document_Annotation]
MS_Description
Stores annotations (text comments) made to Documents
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
OriginatingDocumentID
[dbo].[uniqueid]
9
NOT NULL
Points to the originating Document (ancestor version) Document.DocumentID - denormalized here and part of the composite primary key.
DocumentID
[dbo].[uniqueid]
9
NOT NULL
Points to the Document version that this annotation applies to Document.DocumentID (part of the composite primary key)
AnnotationText
varchar(8000)
8000
NULL allowed
The text of the annotation (or comment)
DTTM
datetime
8
NOT NULL
When the row was inserted
UserID
[dbo].[uniqueid]
9
NOT NULL
Points to IDX_User.ID, the author of the annotation