Please enable JavaScript to view this site.

Administration manual

Navigation: Tech Doc > Description of the JobRouter database > Database structure

JobRouter instance data

Scroll Prev Top Next More

The configuration files of the JobRouter instances can be found in the JRINSTANCES table. Every instance is added as a row. Entries can be done directly in the table to automatically create instances.

The following table shows the structure of the JRINSTANCES table:

Column name

Data type

Description

id

INTEGER

Unique ID of the instance

service_id

INTEGER

ID of the service processing the instance

instance_group

INTEGER

Group the instance belongs to

instance_name

(N)VARCHAR(100)

Name of the instance

instance_description

(N)VARCHAR(255)

Description of the instance

settings

(N)VARCHAR(MAX)

XML structure containing the configuration of the instance

jobflow_pool_size

INTEGER

Maximum amount of processing pools for the JobFlow modules

instance_key

(N)VARCHAR(1000)

Encrypted instance.key of the instance

active

INTEGER

Active flag:

1 = active

0 = inactive

create_date

DATETIME

Creation date

created_by

(N)VARCHAR(50)

User who created the entry

modify_date

DATETIME

Date of last modification

modified_by

(N)VARCHAR(50)

User who made the last modification