# SQLite

-   N 27 total items
-   C 27 classes
-   I 0 interfaces
-   E 0 enums
-   S 0 structs
-   M 239 methods
-   P 23 properties

## OptimaJet.Workflow.SQLite

### Classes

[ColumnInfo](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/ColumnInfo/)

Describes a column in a SQLite database table.

[DbObject<TEntity>](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/DbObject-TEntity/)

Base class for SQLite database entity operations providing CRUD, query execution, and data mapping.

[Extensions](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/Extensions/)

Extension methods for SQLite exception handling.

[FileSchemePersistenceSqliteProvider](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/FileSchemePersistenceSqliteProvider/)

SQLite-based workflow provider that stores workflow schemes in files instead of the database. Inherits all persistence and runtime functionality from [SqliteProvider](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/SqliteProvider/).

[ProcessInstanceTree](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/ProcessInstanceTree/)

Database object for querying the process instance tree hierarchy.

[SqliteProvider](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/SqliteProvider/)

SQLite-based implementation of IWorkflowProvider and IMigratable that provides persistence for workflow processes, schemes, timers, approval history, and forms.

[WorkflowApprovalHistory](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowApprovalHistory/)

Database object for workflow approval history operations.

[WorkflowGlobalParameter](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowGlobalParameter/)

Database object for workflow global parameter operations.

[WorkflowInbox](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowInbox/)

Database object for workflow inbox operations.

[WorkflowProcessInstance](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowProcessInstance/)

Database object for workflow process instance operations.

[WorkflowProcessInstancePersistence](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowProcessInstancePersistence/)

Database object for workflow process instance persistence parameter operations.

[WorkflowProcessInstanceStatus](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowProcessInstanceStatus/)

Database object for workflow process instance status operations.

[WorkflowProcessScheme](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowProcessScheme/)

Database object for workflow process scheme operations.

[WorkflowProcessTimer](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowProcessTimer/)

Database object for workflow process timer operations.

[WorkflowProcessTransitionHistory](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowProcessTransitionHistory/)

Database object for workflow process transition history operations.

[WorkflowScheme](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/WorkflowScheme/)

Database object for workflow scheme storage, querying, and tag management operations.

## OptimaJet.Workflow.SQLite.Migrations

### Classes

[Migration10Initial](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Migrations/Migration10Initial/)

Initial migration that creates the core workflow engine database schema.

[Migration15CreateCalendarNameColumn](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Migrations/Migration15CreateCalendarNameColumn/)

Migration that adds the calendar name column to the workflow process instance table.

[Migration20CreateUniqueIndexes](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Migrations/Migration20CreateUniqueIndexes/)

Migration that creates unique indexes for the workflow engine tables.

[Migration30CreateUniqueIndexes](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Migrations/Migration30CreateUniqueIndexes/)

Migration that creates the workflow forms table.

[Migration40RemoveDeterminingParametersColumns](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Migrations/Migration40RemoveDeterminingParametersColumns/)

Migration that removes the determining parameters columns from the workflow schema table.

[Migration50WorkflowTenantIdAndSchemeId](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Migrations/Migration50WorkflowTenantIdAndSchemeId/)

Migration that adds tenant identifier and scheme identifier columns to workflow tables.

[Migration60RemoveAssignmentCheckDeadlinesSystemProcess](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Migrations/Migration60RemoveAssignmentCheckDeadlinesSystemProcess/)

Migration that removes the assignment check deadlines system process.

## OptimaJet.Workflow.SQLite.Models

### Classes

[QueryDefinition](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Models/QueryDefinition/)

Represents a parameterized SQL query consisting of the command text and its associated parameters.

[WorkflowForm](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Models/WorkflowForm/)

Database object for workflow form storage and versioning operations.

[WorkflowRuntime](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Models/WorkflowRuntime/)

Database object for workflow runtime status and multi-server coordination operations.

[WorkflowSync](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite.Models/WorkflowSync/)

Database object for workflow synchronization lock operations.