Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ImageID | varchar(50) | 50 | NOT NULL | | Key to Doc_Detail table |
 ![Foreign Keys FK_DOC_DETAIL_DocumentID: [dbo].[DOC_HEADER].DocumentID Foreign Keys FK_DOC_DETAIL_DocumentID: [dbo].[DOC_HEADER].DocumentID](../../../../Images/fk.png) | DocumentID | int | 4 | NOT NULL | | FK to Doc_Header.DocumentID |
| FileName | varchar(50) | 50 | NOT NULL | | Name of Image file. Typically a ImageID.tif or ImageID.pdf filename |
| Path | varchar(100) | 100 | NOT NULL | | Folder in Warehouse where Image is located |
| Page | smallint | 2 | NOT NULL | | Page Number |
| Orientation | tinyint | 1 | NOT NULL | ((0)) | Can be 0 for untouched or 1,2,3,4 depending on image has been rotated in 90 degree |
| ArchiveFileName | varchar(20) | 20 | NULL allowed | | NOT USED - NULL for all entries |
| Volume | varchar(3) | 3 | NULL allowed | | NOT USED - NULL for all entries |
 | Archive | tinyint | 1 | NOT NULL | ((0)) | NOT USED - 0 for all entries |
| ArchiveDate | datetime | 8 | NULL allowed | | NOT USED - NULL for all entries |
| LastChange | datetime | 8 | NOT NULL | | Last Edit Date |
| LastAccess | datetime | 8 | NOT NULL | | Date Image was last viewed. |
| AcquireDate | datetime | 8 | NOT NULL | | Date Image was acquired |
| RemoteScan | tinyint | 1 | NOT NULL | ((0)) | 0 = Image is present, 1 = awaiting image from RDQHost for Citrix Remote Scan |
| Brightness | tinyint | 1 | NOT NULL | ((128)) | 0-255 number to adjust brightness via slider in app |
| Contrast | tinyint | 1 | NOT NULL | ((128)) | 0-255 number to adjust contrast via slider in app |
| UserName | varchar(30) | 30 | NULL allowed | | NOT USED - NULL for all entries |
| MachineName | varchar(16) | 16 | NULL allowed | | NOT USED - NULL for all entries |