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