<model name>_PREDICATES table

This table contains all predicates that are associated to the nodes of the model.

The predicate of a node indicates which condition must be true so that it can be reached from its parent node. The predicate of the root node is true.

The following table shows the table columns:

Table 1. Columns of the <model name>_PREDICATES table
Column Data type Description
NODEID BIGINT Index value of the node in the tree model that contains the predicate

The root node has the NODEID 1.
COLUMNNAME VARCHAR(128) Name of the column that is referenced by the predicate

If the predicate is 'true', the value is NULL.
OPERATOR VARCHAR(16) Operator that is used by the predicate

Possible operators are as follows.

  • 'true'
  • 'equal'
  • 'notEqual'
  • 'lessOrEqual'
  • 'greaterThan'
VALUE VARCHAR(512) Column value that is referenced by the predicate

If the COLUMNNAME is NULL, the value is NULL.