Database naming conventions

When the Pega Platform database is initially installed, object names follow specific naming conventions. Tables and view that you add to not have to follow these conventions.

The initial naming conventions use the following prefixes for object names:

  • pc_ identifies tables that contain instances that correspond to Pega-ProCom ruleset capabilities, such as flows, work items, and assignments.
  • pr_ and pr4_ identify tables for activities, properties, requestors, and other features of the rules engine, corresponding to Pega-RULES ruleset capabilities.
  • pvbv4_ identifies views that speed queries and reporting.
  • sppc_ and sppr_ identify stored procedures.
  • trpr4_ identifies database triggers.