Tables for standard features

Decision Center comprises a number of database tables for standard features.

The tables are arranged alphabetically as a data dictionary.

Table 1. List of tables for standard features
Database Table Description
ABSTRACTQUERY Stores the views information.
ACTIVITYCOMMENT Stores the comment from the activity stream.
ACTIVITYCOMMENTACCESS Used to manage private postings in the activity stream.
ACTIVITYCOMMENTATTACHMENT Stores the attachment from the activity stream.
ACTIVITYCOMMENTLINK Stores the URLs placed in the activity stream.
ACTIVITYLOCK Used to lock elements updated in change activities to ensure that they are not updated concurrently in another change activity.
ACTIVITYSUBSCRIPTION Used to manage subscriptions in the activity stream.
ALGORITHMKIND Contains the algorithm kind enumeration values.
ARGUMENT Contains the function arguments.
BASELINE Stores the baseline information.
BASELINECONTENT Stores the content of a baseline.
BASELINEDEPENDENCY Stores dependencies between baselines. A baseline can depend on another baseline, which means that the dependent baseline can use artifacts from the other baseline.
BASELINEKIND Enumeration that lists the different types of baselines handled by Decision Center (STANDARD, DEPLOYMENT).
BOM

Stores BOM artifacts. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

BOMPATHENTRY

Stores BOM path entry artifacts. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

BOM2XOMMAPPING

Stores the BOM to XOM mapping artifacts. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

BRSTUDIO Used for integration with Rule Designer.
CONNECTIONENTRY Contains the connectionEntry class properties. This data is used for the synchronization with Rule Designer and Rule Solutions for Office.
DEFINITION

Stores rule artifact definitions. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

DEPENDENCY Stores the dependencies between baselines.
DIRECTIONKIND Stores the status kind enumeration values.
EVENT

Stores the main properties of the Event class. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

EVENTSIBLING Contains extended features of the Event class. The Primary Key is ID.
EXITCRITERIAKIND Stores the values from the exitCriteriaKind enumeration.
EXTRACTOR Stores extractor artifacts.
HIERARCHY

Stores hierarchical properties values. A hierarchical property is an artifact similar to an enumeration, except that it is hierarchical. The same field DEPRECATED is used to mark values that are no longer used. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

ILRGROUP Stores the roles Decision Center can check for. It is initialized using the upload-roles Ant task.
INITIALVALUE Stores the initial value of templates.
LOCKTBL Stores the locking information.
MERGEREPORT Contains reports obtained when merging branches.
MESSAGEMAP Store messages in Decision Center. It is initialized using the upload-messages ant task.
METAMODEL Stores the list of elements of the rule model used by Decision Center.
NAMEDCONSTANTTYPE Contains named constants.
ORDERINGKIND Stores the ordering kind enumeration values.
OVERRIDDENRULE Stores the rules that override the current one.
PACKAGEKIND Enumeration that lists the different types of packages.
PARAMETER

Stores the parameters information. The container of a parameter is the projectInfo class. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

PERMISSION Stores data regarding permission management.
PRJRESOURCE Contains project resource files.
PROJECTINFO Contains tag information related to rule projects. This data is used in Rule Designer.
PROJECTINFOTAG Stores the Decision Center project information.
PROXY Used internally for synchronization with Rule Designer.
RTSRESOURCE Stores the various resources for Decision Center. For example, the modelInfo description is stored here.
RTSSCHEMA Contains the schema class properties.
RULEARTIFACTTAG Stores rule artifact tags. Tags are aggregated elements of rule artifacts.
RULEAPP Stores the RuleApp descriptions.
RULEAPPPROPERTY Stores the properties of RuleApps.
RULEARTIFACT

Stores the main properties of the ruleArtifact class. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

RULEARTIFACTSIBLING Contains extended features of the ruleartifact class. The Primary Key is ID.
RULEFLOW

Contains the ruleflow properties. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

RULEFLOWSIBLING Contains extended features of the ruleflow class. By default, this class has no extension.
RULEFLOWTAG Contains any tags put on ruleflows.
RULEPACKAGE

Stores rule package information. Rule packages are used to organize the rules. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

RULEPACKAGESIBLING Contains extended features of the rulePackage class. By default, this class has no extension.
RULEPROJECT Contains the rule project features.
RULEPROJECTTAG Contains any tags put on rule projects.
RULESET Stores the ruleSet class features.
RULESETPROPERTY Contains the properties used by the ruleset.
SCENARIOSUITE Contains the properties for test suites and simulations.
SCENARIOSUITEKPIREPORT Contains KPI results generated by test suite and simulation executions.
SCENARIOSUITEREPORT Contains test suite and simulation results generated by their executions.
SCENARIOSUITERESOURCE Contains the resources for test suites and simulations, for example Excel scenario files.
SCENARIOTESTREPORT Contains scenario results generated by test suite and simulation executions.
SCHEMAVERSION Stores the version of Decision Center.
SCOPEELEMENT Stores the scopeElement class features.
SERVER Contains the server class properties. This information is used to store remote server information.
SERVERKIND Enumeration that lists the different types of remote servers handled by Decision Center (RES, RSO).
STATUSKIND Stores the statusKind enumeration values.
TASK

Stores the task properties. It is an aggregated element of the ruleFlow class. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

TEMPLATE

Stores the template class features. It is a project element. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

TESTREPORT Contains test results generated by test suite and simulation executions.
USERSETTING Stores specific user settings. It is updated through the set-config-param Ant task.
VARIABLE

Stores the variable class features. It is an aggregated element of the variableSet class. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

VARIABLESET

Stores the variableSet class features. It is a project element. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

VERSION Used to retrieve the version information. For a detailed description, see The VERSION database table.
VOCABULARY

Stores the vocabulary information. The Primary Key is ID.

For details about the data stored in the table, see Standard features tables metadata.

Standard features tables metadata

This section describes the data stored in the following database tables:

  • BOM

  • BOMPATHENTRY

  • BOM2XOMMAPPING

  • DEFINITION

  • EVENT

  • HIERARCHY

  • PARAMETER

  • RULEARTIFACT

  • RULEARTIFACTSIBLING

  • RULEFLOW

  • RULEPACKAGE

  • TASK

  • TEMPLATE

  • VARIABLE

  • VARIABLESET

  • VOCABULARY

The following table summarizes the BOM artifacts stored in the BOM database table.

Table 2. BOM table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
GRP VARCHAR2(100) NULL
UUID VARCHAR2(46) NOT NULL
BODY CLOB NULL
PROJECT INT NULL
RULEPACKAGE INT NULL
DOCUMENTATION CLOB NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the BOM path entry artifacts stored in the BOMPATHENTRY database table.

Table 3. BOMPATHENTRY table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
URL CLOB NULL
BOM INT NULL
ILRORDER INT NOT NULL
CONTAINER INT NOT NULL
PROJECTNAME VARCHAR2(255) NULL

The following table summarizes the BOM to XOM mapping artifacts stored in the BOM2XOMMAPPING table.

Table 4. BOM2XOMMAPPING table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
PLATFORM VARCHAR2(30) NULL
BODY CLOB NULL
GRP VARCHAR2(100) NULL
UUID VARCHAR2(46) NOT NULL
PROJECT INT NULL
RULEPACKAGE INT NULL
DOCUMENTATION CLOB NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the definitions of rule artifacts contained in the DEFINITION table.

Table 5. DEFINITION table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
BODY CLOB NULL
INFO CLOB NULL
CONTAINER INT NOT NULL
Note:

The container of a definition is a rule artifact.

The following table summarizes the Event class properties data stored in the EVENT table.

Table 6. EVENT table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
RULEPACKAGE INT NULL
GRP VARCHAR2(100) NULL
BODY CLOB NULL
UUID VARCHAR2(46) NOT NULL
VALUE VARCHAR2(30) NULL
VALUETYPE VARCHAR2(30) NULL
PROJECT INT NULL
DOCUMENTATION CLOB NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the hierarchical properties values stored in the HIERARCHY table.

Table 7. HIERARCHY table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
LFT INT NOT NULL
RGT INT NOT NULL
DEPRECATED boolean NOT NULL
CREATEDON DATE NULL
PARENT INT NULL
LASTCHANGEDBY VARCHAR2(100) NULL
UUID VARCHAR2(46) NOT NULL
CREATEDBY VARCHAR2(100) NULL
LASTCHANGEDON DATE NULL
NAME VARCHAR2(255) NOT NULL
Note:

LFT and RGT are internal data used to improve query performance.

The following table summarizes the parameters information stored in the PARAMETER table.

Table 8. PARAMETER table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
BOMTYPE CLOB NOT NULL
VERBALIZATION CLOB NULL
INITIALVALUE CLOB NULL
ILRORDER INT NOT NULL
DIRECTION VARCHAR2(30) NOT NULL
CONTAINER INT NOT NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the ruleArtifact class properties data stored in the RULEARTIFACT table.

Table 9. RULEARTIFACT table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
RULEPACKAGE INT NULL
TEMPLATE INT NULL
GRP VARCHAR2(100) NULL
ACTIVE boolean NULL
IMPORTS CLOB NULL
RETURNTYPE CLOB NULL
UUID VARCHAR2(46) NOT NULL
LOCALE VARCHAR2(30) NULL
CATEGORIES CLOB NULL
PROJECT INT NULL
DOCUMENTATION CLOB NULL
PRIORITY VARCHAR2(15) NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the ruleartifact class extended features stored in the RULEARTIFACTSIBLING table.

Table 10. RULEARTIFACTSIBLING table metadata
Column Name Data Type Null Value
ID INT NOT NULL
STATUS VARCHAR2(50) NOT NULL
ALTERNATE VARCHAR2(30) NULL
ILRKEYS CLOB` NULL
EFFECTIVEDATE DATE NULL
GEOGRAPHY INT NULL
EXPIRATIONDATE DATE NULL

The following table summarizes the ruleflow properties stored in the RULEFLOW table.

Table 11. RULEFLOW table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
DIAGRAM CLOB NULL
RULEPACKAGE INT NULL
MAINFLOWTASK boolean NULL
GRP VARCHAR2(100) NULL
LOCALE VARCHAR2(30) NULL
UUID VARCHAR2(46) NOT NULL
INITIALACTIONS CLOB NULL
FINALACTIONS CLOB NULL
PROJECT INT NULL
BODY CLOB NULL
DOCUMENTATION CLOB NULL
NAME VARCHAR2(255) NOT NULL
IMPORTS CLOB NULL

The following table summarizes the rule package information stored in the RULEPACKAGE table.

Table 12. RULEPACKAGE table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
GRP VARCHAR2(100) NULL
UUID VARCHAR2(46) NOT NULL
PROJECT INT NULL
RULEORDER CLOB NULL
PACKAGEKIND VARCHAR2(30) NOT NULL
DOCUMENTATION CLOB NULL
PARENT INT NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the task properties stored in the TASK table.

Table 13. TASK table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
ORDERING VARCHAR2(30) NULL
ALGORITHM VARCHAR2(30) NULL
NAME VARCHAR2(255) NOT NULL
CONTAINER INT NOT NULL
DYNAMIC boolean NULL
ADVANCEDPROPERTIES CLOB NULL
INITIALACTIONS CLOB NULL
ILRSELECT CLOB NULL
EXITCRITERIA VARCHAR2(30) NULL
DOCUMENTATION CLOB NULL
FINALACTIONS CLOB NULL
DEFINITION CLOB NULL

The following table summarizes the template class features stored in the TEMPLATE table.

Table 14. TEMPLATE table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
RULETYPE VARCHAR2(255) NULL
LOCALE VARCHAR2(30) NULL
GRP VARCHAR2(100) NULL
UUID VARCHAR2(46) NOT NULL
PROJECT INT NULL
RULEPACKAGE INT NULL
DOCUMENTATION CLOB NULL
DEFINITIONINFO CLOB NULL
DEFINITION CLOB NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the variable class features stored in the VARIABLE table.

Table 15. VARIABLE table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
BOMTYPE CLOB NOT NULL
VERBALIZATION CLOB NULL
INITIALVALUE CLOB NULL
CONTAINER INT NOT NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the variableSet class features stored in the VARIABLESET table.

Table 16. VARIABLESET table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
RULEPACKAGE INT NULL
GRP VARCHAR2(100) NULL
UUID VARCHAR2(46) NOT NULL
PROJECT INT NULL
DOCUMENTATION CLOB NULL
NAME VARCHAR2(255) NOT NULL

The following table summarizes the vocabulary information stored in the VOCABULARY table.

Table 17. VOCABULARY table metadata
Column Name Data Type Null Value
ID INT NOT NULL
TYPE INT NOT NULL
STARTID INT NOT NULL
ENDID INT NOT NULL
ORIGINALID INT NOT NULL
BASELINE INT NOT NULL
GRP VARCHAR2(100) NULL
UUID VARCHAR2(46) NOT NULL
LOCALE VARCHAR2(30) NULL
PROJECT INT NULL
RULE PACKAGE INT NULL
BODY CLOB NULL
DOCUMENTATION CLOB NULL
NAME VARCHAR2(255) NOT NULL

The VERSION database table

This table is used to retrieve the version information.

The rule model classes that are versioned (those that are project elements) are stored in the database with the additional fields STARTID and ENDID. These fields are foreign key references to the VERSION table. The STARTID column contains the ID of the VERSION record created with this version of the class instance, whereas the ENDID column contains the ID of the VERSION record created when this version of the class instance is modified.

For instance, when you create a new rule, a new record is stored in the RULEARTIFACT table. A new record (V1) is also created in the VERSION table, which gives the date on which the rule is created, and the person who created it. The ID of this new version is stored in the STARTID column of the RULEARTIFACT record. For now, the ENDID column of the new rule is set to a big value (BIG_VALUE) and indicates that this record is the current version of the rule.

To retrieve the current version of a rule, the system runs a query with the condition ENDID = BIG_VALUE.

When you update this rule, the following actions take place:

  • A new record (V2) is created within the VERSION table to store the following information about this new version: creator and date of creation.

  • The ENDID column of the previous version of the rule is updated to the ID of this new version (V2.ID). Note that it was previously set to BIG_VALUE.

  • The new record for the new version of the rule is built with STARTID = V2.ID and ENDID = BIG_VALUE.

Consequently, to retrieve version V1 of the rule, the system runs a query with the condition STARTID >= V1.ID AND ENDID < V1.ID.

Here is the list of rule model classes that are project elements, and therefore have versions stored in the VERSION table:

  • ABSTRACTQUERY

  • BOM

  • BOM2XOMMAPPING

  • DEFINITION

  • EVENT

  • INITIALVALUE

  • OVERRIDDENRULE

  • PRJRESOURCE

  • RULEARTIFACTTAG

  • RULEARTIFACT

  • RULEFLOW

  • RULEFLOWTAG

  • RULEPACKAGE

  • SCENARIOSUITE

  • SCENARIOSUITERESOURCE

  • SCOPEELEMENT

  • TASK

  • TEMPLATE

  • VARIABLE

  • VARIABLESET

  • VOCABULARY