How database tables are identified at run time

When saving or reading an object as a row in the database, the system uses pattern inheritance based on the class name of the object to find a database table.

Pattern inheritance processing is based on hyphens in the class name. For example, for the Rule-Obj-Property-Qualifier class, the four patterns are:

  • Rule-Obj-Property-Qualifier
  • Rule-Obj-Property-
  • Rule-Obj-
  • Rule-

To fetch an instance of the class Rule-Obj-Property-Qualifier, the system looks for database table instances (Data-Admin-DB-Table class) matching these class names in the above sequence. When a matching database table instance is found, information in that instance identifies the Pega database table that contains the object as a row.

If the system does not find a table by this search, it uses the pr_other table.