Explanation of Flux Database Tables

The following is a complete list of the database tables Flux uses to store information about workflows, historical executions, and other data required for engine operation. For complete instructions on configuring Flux to run with your database, see Configuring Flux to run with Databases.

Logging

Table Name	Description
FLUX_AUDIT_TRAIL	Contains audit trail events logged when methods are invoked on an engine and when an engine runs workflows. You can control the amount of information that Flux stores in this table, as well as the total length of time that information is stored, by setting the AUDIT_TRAIL_EXPIRATION and AUDIT_TRAIL_FILTER engine configuration properties.
FLUX_LOGGING	Contains error messages logged by workflows and engines. You can control the amount of information that Flux stores in this table, as well as the total length of time that information is stored, by setting the LOG_EXPIRATION and LOGGER_TYPES engine configuration properties.
FLUX_RUN_AVERAGE	Contains the average length of time actions and workflows take to execute. You can control the amount of information that Flux stores in this table, as well as the total length of time that information is stored, by setting the RUN_HISTORY_ENABLED and AUDIT_TRAIL_EXPIRATION engine configuration properties.
FLUX_FLOW_CHART_RUN	Contains the length of time workflows take to execute by setting the RUN_HISTORY_ENABLED and AUDIT_TRAIL_EXPIRATION engine configuration properties.
FLUX_ACTION_RUN	Contains the length of time actions take to execute by setting the RUN_HISTORY_ENABLED and AUDIT_TRAIL_EXPIRATION engine configuration properties.

Error Details

Table Name	Description
FLUX_ERROR_RESULT	Contains details about workflow errors that are made available to error handler workflows.

Workflows and Actions

Table Name	Description
FLUX_READY	Contains information on workflow execution contexts (workflows executing or waiting to run).
FLUX_CALLSTACK	Contains information used with READY table for workflows.
FLUX_JOINING	Used with READY table to coordinate workflow execution.
FLUX_FLOW_CONTEXT	Contains information about active or waiting execution flow contexts.
FLUX_FLOW_CHART	Contains the attributes of a workflow.
FLUX_ACTION	Contains the actions and triggers of a workflow.
FLUX_TIMER_TRIGGER	Contains attributes specific to Timer Triggers.
FLUX_AUDIT_TRL_TGR	Contains attributes specific to Audit Trail Triggers.
FLUX_FLOW_CHART_TGR	Contains attributes specific to Flow Chart Triggers.
FLUX_FLOW	Contains attributes of flows that connect triggers and actions in a workflow.
FLUX_SIGNAL	Contains details about flows with signal conditions.
FLUX_DATA_MAP	Contains run time data map details for flows.
FLUX_REPOSITORY	Contains repository elements such as workflows that are not eligible to execute until exported to an engine.

Variables

Table Name	Description
FLUX_VARIABLE	Contains attributes of flow chart, action, and flow context variables.

Engines

Table Name	Description
FLUX_CLUSTER	Contains engine details for all engines in the cluster.

Security

Table Name	Description
FLUX_PERMISSION	Contains information about permission assignments for Flux roles.
FLUX_ROLE	Contains information about roles configured within Flux.
FLUX_USER	Contains information about Flux users.
FLUX_USER_ROLE_REL	Contains mappings of users to roles for permission assignment.

Internal

Table Name	Description
FLUX_PK	Contains one row for generating unique sequences across multiple Flux engines in a cluster.