Tables [dbo].[ANNOTATIONS]
Annotations. These are .ANN files that get overlayed on images. Filepath to .ANN files.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_ANNOTATIONS: ImageIDImageIDvarchar(50)50NOT NULLKey to the Annotations table
Pathvarchar(100)100NOT NULLFolder name .ANN file is stored in
FileNamevarchar(50)50NOT NULLfilename of .ANN file
AcquireDatesmalldatetime4NULL allowedDate Annotation was added
LastChangesmalldatetime4NULL allowedLast Edited Date
ArchiveDatesmalldatetime4NULL allowedNOT USED - NULL for all entries
Archivetinyint1NOT NULL((0))NOT USED - 0 for all entries
ArchiveFileNamevarchar(20)20NULL allowedNOT USED - NULL for all entries
Volumevarchar(3)3NULL allowedVolume of annotations