Child pages
  • Explanation of Flux Database Tables
Skip to end of metadata
Go to start of metadata

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 of 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 which 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.

  • No labels