Database Schema

nflow_workflow

Table nflow_workflow contains one row for each workflow instance.

Field	Description
id	Primary key
type	Type of workflow
business_key	Business key
external_id	Unique id for workflow instance
state	Current state
state_text	Reason why current state was set
next_activation	Time when next processing is scheduled. If null, no processing is scheduled
executor_id	Executor that is currently processing the workflow
retries	Number of retries in current state
created	Time when this row was created
modified	Time when this row was last modified
executor_group	Executor group

nflow_workflow_action

Table nflow_workflow contains one row for each state transition that has happened.

Field	Description
id	Primary key
workflow_id	Reference to workflow instance
executor_id	Executor that processed the workflow state
state	Name of the state
state_text	Description of action taken in this state
retry_no	Retry count
execution_start	Time when state processing started
execution_end	Time when state processing finished

nflow_workflow_state

Table nflow_workflow_state contains state information. State variables are stored here.

Field	Description
workflow_id	Reference to workflow instance
action_id	Reference to action
state_key	Name of state variable
state_value	Value of state variable

nflow_executor

Table nflow_executor is used to keep track which nflow executors are currently operational. If a nflow executor instance is detected to be non operational, any workflows under processing by that executor may be claimed by other, functional executors.

Field	Description
id	Primary key
host	Name of host where executor is running.
pid	Process id (PID) for executor.
executor_group	Executor group for executor.
started	Time when executor was starter.
active	Time when executor last marked itself active.
expires	Time when executor can be considered to be non-operational.