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.
In a development system, the Pega Platform automatically creates a new table each time you indirectly create a new concrete class by using Application Express, 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:
pc_work table. The table is named pc_zzzzz_work, where ZZZZZ is the class group name in all lowercase.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.
You can import and apply schema changes from an archive by using the Import landing page. This approach is useful when you want to keep the schemas of two systems synchronized.