Qorus Integration Engine®  4.0.3_git
Data Model

The following table gives an overview of the Qorus table structure.

Workflow Metadata

Name Description
ERROR_SEVERITY Gives valid severity levels for errors
FUNCTIONS Gives the type of functions that can be in the database
GLOBAL_WORKFLOW_ERRORS Holds global workflow error definition information
QUEUES Queue description table
QUEUE_DATA_STATUS Reference table for queue data dataus
QUEUE_TAGS Holds key-value pair information associated to queues
SEGMENT_ASYNC_LINK Defines the links between asynchronous segments
SEGMENT_DEPENDENCIES Defines dependencies between segments
SEGMENT_STEPS Defines the relationship between steps and segments
STEP_ARRAYTYPE Gives valid array types for array steps
STEP_CONFIG_ITEMS Defines step configuration items
STEP_STATUS Gives valid statues for step instances
STEP_TAGS Holds key-value pair information associated to steps
STEP_TYPE Reference table for step types
STEPS Top-level step definition (id, name, version, etc)
WORKFLOW_DEPENDENCIES Defines inter-workflow dependencies
WORKFLOW_ERRORS Holds workflow-specific error definition information
WORKFLOW_EVENT_TYPE_TAGS Holds key-value pair information associated to workflow event types
WORKFLOW_EVENT_TYPES Defines the possible workflow event types
WORKFLOW_GLOBAL_CONFIG_ITEMS Defines global configuration items with workflow-specific values
WORKFLOW_LIB Links workflows to code objects (classes, constants, and functions)
WORKFLOW_MAPPERS Links workflows to data mapper objects
WORKFLOW_OPTIONS Defines valid options per workflow and stores persistent workflow option values
WORKFLOW_STATUS Gives valid statuses for workflow order data instances
WORKFLOW_STEPS Defines the m:n relationship between workflows and steps
WORKFLOW_TAGS Holds key-value pair information associated to workflows
WORKFLOW_VMAPS Links workflows to value map objects
WORKFLOWS Top-level workflow definition (id, name, version, etc)

Workflow Order Data

Name Description
ERROR_INSTANCE Stores errors raised
ORDER_INSTANCE Stores the static and dynamic data for workflow order data instances, 1:1 relationship with WORKFLOW_INSTANCE as joined by the workflow_instanceid primary key
ORDER_INSTANCE_KEYS Stores user-defined keys for workflow order data instances
ORDER_INSTANCE_NOTES Stores user or system generated notes
QUEUE_DATA Stores asynchronous messages
SEGMENT_INSTANCE Per workflow instance, tracks state of segments
SENSITIVE_ORDER_DATA Encrypted sensitive order data
SENSITIVE_ORDER_DATA_KEYS Encrypted sensitive order data aliases
STEP_INSTANCE Per workflow and per segment instance, tracks the state of each step executed
STEP_INSTANCE_EVENTS Connects a step in a given workflow order data instance to a workflow event
SUBWORKFLOW_INSTANCE Matches subworkflow steps with their subworkflows
WORKFLOW_EVENTS Stores workflow synchronization event information, including the event type ID, the key name, and the posted status.
Note
Data in this table is not necessarily associated to only one workflow order, but may be shared across any number of workflow orders of different workflow types
WORKFLOW_FEEDBACK Used to store feedback from child workflows
WORKFLOW_INSTANCE Top-level workflow order data instance state table

Library Object Tables

Name Description
FUNCTION_INSTANCE Contains the definition of a function (id, name, version, logic, etc)
FUNCTION_INSTANCE_TAGS Holds key-value pair information associated to function instances
CLASSES Contains versioned user class definitions
CLASS_DEPENDENCIES Lists dependencies for classes that depend on other classes
CLASS_TAGS Holds key-value pair information associated to classes
CONSTANT_TAGS Holds key-value pair information associated to constants
CONSTANTS Contains versioned constant definitions
LIBRARY_TYPE Valid types of library objects

Service Tables

Name Description
SERVICE_AUTH_LABELS Defines authorization labels for HTTP handlers in services
SERVICE_CONFIG_ITEMS Defines service configuration items
SERVICE_GLOBAL_CONFIG_ITEMS Defines global configuration items with per-service values
SERVICE_LIB Links services to code objects (classes, constants, and functions)
SERVICE_MAPPERS Links services to data mapper objects
SERVICE_METHOD_TAGS Holds key-value pair information associated to service methods
SERVICE_METHODS Service method definitions (name, description, code, etc)
SERVICE_STATE_DATA Stores service state data for service recovery logic
SERVICE_TAGS Holds key-value pair information associated to services
SERVICE_TYPE Type of services possible (currently only system and user)
SERVICE_VMAPS Links services to value map objects
SERVICES Top-level service definition (type, name, description)L

Job Tables

Name Description
JOB_CONFIG_ITEMS Defines job configuration items
JOB_ERRORS Holds information about errors raised when jobs are executed
JOB_GLOBAL_CONFIG_ITEMS Defines global configuration items with per-job values
JOB_INSTANCE Tracks the status of processing jobs
JOB_LIB Lists code objects (classes, constants, and functions) that will be included in each job's Program object
JOB_MAPPERS Links jobs to data mapper objects
JOB_STATE_DATA Stores job state data for job recovery logic
JOB_STATUS Static reference table giving valid statuses for job instance records
JOB_TAGS Holds key-value pair information associated to jobs
JOB_VMAPS Links jobs to value map objects
JOBS Job definition

Mapper Tables

Name Description
MAPPERS Defines data mapper objects
MAPPER_TAGS Holds key-value pair tag information associated to data mappers objects

Value Map Tables

Name Description
VALUE_MAPS Defines value map objects
VALUE_MAP_VALUES Holds key-value information associated to value map objects

SLA Tracking Tables

Name Description
SLA Defines SLAs
SLA_EVENTS Stores SLA events

User Connection Table

Name Description
CONNECTIONS Holds information about user connections

Cluster Table

Name Description
CLUSTER_PROCESSES Holds information about cluster processes

RBAC Tables

Name Description
EXTERNAL_USER_STORAGE Used to store server-side key/value storage associated with external RBAC users
GROUP_JOBS Defines the job members of interface groups
GROUP_MAPPERS Defines the mapper members of interface groups
GROUP_SERVICES Defines the service members of interface groups
GROUP_VMAPS Defines the value set members of interface groups
GROUP_WORKFLOWS Defines the workflow members of interface groups
GROUPS Defines Interface Groups
PERMISSION_TYPE Static reference table for SYSTEM and USER permission types
PERMISSIONS Defines valid RBAC Permissions
ROLE_PERMISSIONS Defines the n:m relationship between RBAC Roles and RBAC Permissions
ROLE_GROUP_ACCESS Defines the Interface Groups for RBAC Roles
ROLES Defines valid RBAC Roles
USER_ROLES Defines the n:m relationship between users and roles
USER_STORAGE Used to store the server-side key/value storage associated with each user
USERS Defines valid RBAC Users with username, name, and password

System Tables

Name Description
SESSIONS Stores session information
SYSTEM_PROPERTIES Stores system property information

Audit Tables

Name Description
AUDIT_EVENT_CODES Lists possible audit event codes (see Audit Event Codes for the list of values in this reference table)
AUDIT_EVENTS Contains auditing events (see also Audit Events)