Database structure - ABBYY Documentation

The ABBYY FlexiCapture database groups its tables as follows.

Objects for processing

Table	Purpose
Batch	Contains a list of batches.
BatchItem	Stores all objects that constitute a batch.
BatchParameter	Contains registration parameters of batches and documents.
BatchType	Contains a list of batch types.
BatchTypeParameter	Registration parameters of batch types.
BatchTypeTemplate	Contains information about relationships between batch types and Document Definitions.
DocumentSourceImage	Shortcuts to image file that are attached to documents.
Project	Contains a list of Recognition Server projects.
Template	Contains a list of Document Definitions.
TemplateVersion	Contains information about Document Definition versions.

Locks

Table	Purpose
EditSession	Stores all batch object editing sessions.
Lock	Contains information about locked objects.
Session	Contains information about current work sessions of users. Also used for managing resources allocated for sessions and locks.
TemplateLock	Contains information about editable Document Definitions.

Workflow

Table	Purpose
ProcessingStage	Contains a list of processing stages.
Task	Contains a list of tasks.

Access control

Table	Purpose
Principal	Contains information about users and user groups.
PrincipalLink	Contains information about relationships between entries of the Principal table.
PrincipalPermission	Contains permissions for users or user groups. Allows connections with certain role types. Access blocks are not used in this version.
Tenant	Stores a list of all tenants.

Statistics

Table	Purpose
StatisticBatchArchive	Contains information about packets for which statistic data was gathered.
StatisticBatchDayActivity	Contains hourly statistics for batch processing during specific stages.
StatisticBatchDocumentTypeArchive	Contains a list for every batch of document types for which statistics were gathered. A document type is all document to which the same Document Definition is applied and has the same name as the definition.
StatisticBatchParameterArchive	Contains information about parameters of batches for which statistics were gathered.
StatisticConnections	Stores FlexiCapture user connection statistics. Performance indicators are recorded every 10 minutes.
StatisticDocuments	Contains entries about documents of a specific type that were edited by a user.
StatisticExceptionTask	Contains detailed data about tasks processed in the Exceptions stage.
StatisticProductivity	Stores performance statistics. Performance indicators are recorded every 10 minutes. Performance is determined using summary indicators for a period of time.
StatisticTasks	Contains statistics related to a specific batch for one day.

Event log

Table	Purpose
EventLog	Contains information about system events.
DocumentEditingStatistic	Contains statistics of changes in a document made by a user.

Dictionaries

Table	Purpose
Role	Contains information about user roles.
RoleProcessingStage	Table of relationships between roles and processing stages.
RoleWorkstationType	Contains information about relationships between roles and station types.
WorkstationType	Contains a list of available station types.

Enumerations

Table	Purpose
Priority	Describes possible priority values.
Task status	Describes possible document processing task statuses.
Types of image sources	Describes the types of possible sources of document images.
Object types	Lists possible types of objects.
User role types	Describes possible user roles.
Station types	Describes predefined station types.
Processing stage types	Describes possible processing stage types.
Event types	Describes possible event types.