Tables [dbo].[DOC_DETAIL]
Stores Page information about a given document. A 5 page document will have 5 rows in this table
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_DOC_DETAIL: ImageIDImageIDvarchar(50)50NOT NULLKey to Doc_Detail table
Indexes IX_DOC_DETAIL_DOCUMENTIDForeign Keys FK_DOC_DETAIL_DocumentID: [dbo].[DOC_HEADER].DocumentIDDocumentIDint4NOT NULLFK to Doc_Header.DocumentID
FileNamevarchar(50)50NOT NULLName of Image file. Typically a ImageID.tif or ImageID.pdf filename
Pathvarchar(100)100NOT NULLFolder in Warehouse where Image is located
Pagesmallint2NOT NULLPage Number
Orientationtinyint1NOT NULL((0))Can be 0 for untouched or 1,2,3,4 depending on image has been rotated in 90 degree
ArchiveFileNamevarchar(20)20NULL allowedNOT USED - NULL for all entries
Volumevarchar(3)3NULL allowedNOT USED - NULL for all entries
Indexes IX_DOC_DETAIL_ARCHIVEArchivetinyint1NOT NULL((0))NOT USED - 0 for all entries
ArchiveDatedatetime8NULL allowedNOT USED - NULL for all entries
LastChangedatetime8NOT NULLLast Edit Date
LastAccessdatetime8NOT NULLDate Image was last viewed.
AcquireDatedatetime8NOT NULLDate Image was acquired
RemoteScantinyint1NOT NULL((0))0 = Image is present, 1 = awaiting image from RDQHost for Citrix Remote Scan
Brightnesstinyint1NOT NULL((128))0-255 number to adjust brightness via slider in app
Contrasttinyint1NOT NULL((128))0-255 number to adjust contrast via slider in app
UserNamevarchar(30)30NULL allowedNOT USED - NULL for all entries
MachineNamevarchar(16)16NULL allowedNOT USED - NULL for all entries