Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | QID | int | 4 | NOT NULL | 1 - 1 | | Key to the OCR_Contents table |
| InsertTime | datetime | 8 | NULL allowed | | (getdate()) | Date OCR conversion started. |
 | ImageID | varchar(50) | 50 | NOT NULL | | | Image. Link to doc_detail.imageid, batch_detail.imageid, or file cabinet (ie FCD0000001.imageid) |
| FileType | int | 4 | NOT NULL | | | ID of filetype. (1 = .tif, 501 = .pdf, 505 = .tiff etc) |
| Content | text | max | NULL allowed | | | The interpreted text from the image |
| TimeStamp | timestamp | 8 | NULL allowed | | | A timestamp of when the interpretation finished |
| OCRElapsedTime | int | 4 | NULL allowed | | | How long the interpretation took |