Workflow Framework: Database Tables

As part of the Workflow framework, the system saves all workflow data in a database and follows this information model for workflow data:

The system stores workflows and tasks in specific tables, and you can query these tables and display them on screen to display tasks. The workflow and task tables include the following:

• generic_task: The system stores all instances of tasks from all workflows in the generic_task table and provides each instance of a task a unique identifier. The system stores this id in the workflow_instance column of the generic_task table. With this ID you can retrieve all tasks associated with a particular workflow.
• generic_task_storage: The system stores persistent workflow task data as a single BLOB in the generic_task_storage table. All tasks from the same workflow share the same data container, so you can pass this data between tasks in the same workflow.
• generic_task_tags: The system stores tags associated with each task in the generic_task_tags table. Each task tag is linked to a task by its id.
• generic_workflow: The system stores all instances workflows in the generic_workflow table stores all the instances of workflows. Each instance of a workflow is uniquely identified by its id, this id will be used throughout the other tables for linking to the workflow.
• generic_checker_workflow: The system stores the link between parent and child workflows in the generic_checker_workflow table. This allows the system to execute parallel workflows and step a parent workflow forward whenever a task in a child workflow is completed.