Tables Tables
NameDescription
dbo.ANNOTATIONSAnnotations. These are .ANN files that get overlayed on images. Filepath to .ANN files.
dbo.DOC_DETAILStores Page information about a given document. A 5 page document will have 5 rows in this table
dbo.DOC_FLAGSFlagged Documents
dbo.DOC_HEADERStores images on the patients chart. Works in conjunction with doc_detail where we store page information.
dbo.DOC_RESERVATIONSForms printed that contain barcodes.
dbo.DOCNOTESHolds "Doc Notes" and "Task Notes" for an image.
dbo.FOLDER_TEMPLATEFolders can be created to organize scanned images in a patients chart.
dbo.FORMS_ANNOTATIONSAnnotation for a form. This appears on the form.
dbo.FORMS_BACKGROUNDSBackground to the form.
dbo.FORMS_DDWhen "Database fields" are added to a form, the list of available fields comes from this table.
dbo.FORMS_DETAILThis contains all the elements that appear in the form. 1 row per element.
dbo.FORMS_HEADERForm information. The individual elements on the form are in Form_Detail.
dbo.Forms_XMLForms data
dbo.OCR_CONTENTSOptical Character Recognition table. Contains the recognized text on a docuemnt.
dbo.PATIENT_NOTESNotes about the patient.
dbo.PATIENTS_EDITPatient Demographics
dbo.SEC_GROUPSSecurity Groups.
dbo.SEC_USERSUsers
dbo.SIGNOFFSDocuments that has been signed off.
dbo.TB_BASKETSTask basket for a single user or a shared task basket (either with and without an owner) for multiple users all being able to see all the tasks in the shared basket.  
dbo.TB_MAINTasks
dbo.WAREHOUSESWarehouses