Tables for standard features
Decision Center comprises a number of database tables for standard features.
The tables are arranged alphabetically as a data dictionary.
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.
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.
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.
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.
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 |
The container of a definition is a rule artifact.
The following table summarizes the Event class properties data stored in the EVENT table.
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.
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 |
LFT and RGT are internal data used to improve query performance.
The following table summarizes the parameters information stored in the PARAMETER table.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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