Tables [dbo].[Document_Annotation]
Stores annotations (text comments) made to Documents
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Document_Annotation: OriginatingDocumentID\DocumentID\DTTM\UserIDForeign Keys FK_Document_Annotation_Document1: [dbo].[Document].OriginatingDocumentIDOriginatingDocumentID[dbo].[uniqueid]9NOT NULLPoints to the originating Document (ancestor version) Document.DocumentID - denormalized here and part of the composite primary key.
Cluster Primary Key PK_Document_Annotation: OriginatingDocumentID\DocumentID\DTTM\UserIDIndexes TWstat_Document_Annotation_DocumentIDForeign Keys FK_Document_Annotation_Document2: [dbo].[Document].DocumentIDDocumentID[dbo].[uniqueid]9NOT NULLPoints to the Document version that this annotation applies to Document.DocumentID (part of the composite primary key)
AnnotationTextvarchar(8000)8000NULL allowedThe text of the annotation (or comment)
Cluster Primary Key PK_Document_Annotation: OriginatingDocumentID\DocumentID\DTTM\UserIDDTTMdatetime8NOT NULLWhen the row was inserted
Cluster Primary Key PK_Document_Annotation: OriginatingDocumentID\DocumentID\DTTM\UserIDForeign Keys FK_Document_Annotation_IDX_User: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLPoints to IDX_User.ID, the author of the annotation