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. |
Comments
Please sign in to leave a comment.