Platform-generated schema changes
The schema for the Pega Platform database can grow and evolve through a variety of tools and automatic changes. Automatic changes are possible only if the primary account or the administrative account on the Database data instance that defines the connection to the Pega Platform database has the ALTER TABLE and CREATE TABLE capabilities.
Often these capabilities are on development systems but are not on production systems (as determined by the production level value in the System data instance.) In addition, certain capabilities require that you have specific privileges.
Automatic schema changes
In a development system, the Pega Platform automatically creates a new table each time you indirectly create a new concrete class by using App Studio, the Connector and Metadata wizard, and similar tools. You must have the SchemaTableCreation privilege to create these tables. The following types of tables are created:- Work- — When you define a concrete class derived from
Work- that is a class group, the Pega Platform
creates a database table that is a copy of the
pc_work
table. The table is named pc_zzzzz_work, where ZZZZZ is the class group name in all lowercase. Data- — Optionally, you can save the rows of a data table in a dedicated table by using the Data Table wizard. The table is named pr_zzzzz, where zzzzz is the class name of the table.
- History — The new table is named pc_history_zzzzz_work, where ZZZZZ is the class group name in all lowercase.
Property optimization schema changes
To support reporting, you can expose a property value to make it a separate database column by using the Property Optimization or Modify Schema wizards. These tools can add or update a column in an existing database table.
Schema changes from an archive
You can import and apply schema changes from an archive by using the Import wizard page. This approach is useful when you want to keep the schemas of two systems synchronized. See Importing rules and data by using the Import wizard for more information.
Viewing generated schema changes
You can view consolidated information about changes applied to the database schema on this system. Information is drawn from three concrete classes derived from Log-System-Schema-.
- Click .
- Click the Schema Change Tracking tab.
- Select the schema changes that you want to view from the list at the top of the
screen.
- All – View all schema changes made to this system since it was installed or last upgraded.
- PRPC Shipped – View schema changes created by the initial creation of the Pega Platform schema when the system was installed or upgraded.
- PRPC Generated – View schema changes made by automated operations in Pega Platform, for example, the Import wizard, property optimization or database schema optimization.
- Manual – View schema changes made directly by the Pega Platform developers.
Previous topic Initial database schema Next topic Viewing database schema using Schema Tools