Explanation of Flux Database Tables

The following is a complete list of the database tables Flux uses to store information about flow charts, 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 flow charts. 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 flow charts 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 flow charts 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 flow charts 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 flow chart errors which are made available to error handler flow charts.

Flow Charts and Actions

Table Name

Description

FLUX_READY

Contains information of flow chart contexts (flows executing or waiting to run).

FLUX_CALLSTACK

Contains information used with READY table for flow charts.

FLUX_JOINING

Used with READY table to coordinate flow chart execution.

FLUX_FLOW_CONTEXT

Contains information about active or waiting flows.

FLUX_FLOW_CHART

Contains the attributes of a flow chart.

FLUX_ACTION

Contains the actions and triggers of a flow chart.

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 flow chart.

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 flow charts which 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_USR_SUPR_REL

Contains mappings of users to roles for permission assignment (this table is only used for the deprecated Flux BPM feature which will be removed in Flux 8.0).

FLUX_USER

Contains information about Flux users.

FLUX_USER_ROLE_REL

Contains mappings of users to roles for permission assignment.

Flux BPM

Flux BPM is deprecated and will be removed in Flux 8.0. Table information is included here only for completeness.

Table Name

Description

FLUX_BIZ_PROCESS

Contains attributes for business processes.

FLUX_BIZ_PROCESS_T

Contains attributes for business process reminder generation.

FLUX_BIZ_PROC_CONF

Contains details about confirmed Business Process Triggers.

FLUX_BIZ_PROC_OWNR

Contains attributes about owners of business processes.

Internal

Table Name

Description

FLUX_PK

Contains one row for generating unique sequences across multiple Flux engines in a cluster.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.