Tables [dbo].[FORMS_ANNOTATIONS]
Annotation for a form. This appears on the form.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Indexes IX_FORMS_ANNOTATIONS_DOCUMENTIDDocumentIDint4NOT NULLDocument. Link to Doc_Header.DocumentID or potentially a File Cabinet as well.
ObjectIDint4NULL allowedKey to the FORMS_ANNOTATIONS table. Auto incremented from System.NextObjectID
AnnotationImagevarchar(250)250NULL allowedIf doodling is used as an annotation, it is saved as a .bmp file. This is the path + filename separated by a semi-colon. (ie 00000003\;000000080001.BMP)
AnnotationTextvarchar(250)250NULL allowedIf text is added as an annotation, the text is added here. All the color/bold/font columns will apply to it.
Xint4NOT NULLX Axis location of where annotation begins
Yint4NOT NULLY Axis location of where annotation begins
Heightint4NOT NULLheight
Widthint4NOT NULLwidth
Colorint4NULL allowed0 = default color, otherwise its the decimal number of color code. Green would be 65280
Boldbit1NULL allowed0 = No, 1 = Yes
Italicbit1NULL allowed0 = No, 1 = Yes
Underlinebit1NULL allowed0 = No, 1 = Yes
Fontvarchar(50)50NULL allowedName of font, ie MS Sans Serif
FontSizefloat8NULL allowedsize of font