The initial Pega 7 Platform database schema has database tables that contain rows corresponding to instances of concrete Data- classes.
These tables are:
pr_operators — Operator IDspi_data_connect — Listenerspr_data_admin — Administrative data not stored elsewherepr_data_file — Contains image content data instances (Data-Content-Image class) pr_data_tag — Contains all of the unique tags defined in the system pr_data_products — Supports display of installed hotfixes pr_data_restore — Stores metadata required to rollback hotfixes pr_data_sample_uidetails — Supports data for the UI Gallerypc_data_uniqueid — Work item ID trackingpc_data_workattach — Work item attachmentspr4_base — Foundation objectspr_data_autotest — Test results from use of the Automated Testing featurepr_data — Sent correspondence and data objects not stored elsewherepr_class_ancestors — Supports high-performance rule resolutionpr_data_reportcategory — not usedpr_data_reportshortcut — not usedpr_data_registry — not usedpr_data_repository — not usedThe pr_operators table contains rows that correspond to instances of the Data-Admin-Operator-ID class. The key to this table consists of the class name and Operator ID, for example:
DATA-ADMIN-OPERATOR-ID [email protected].
As a best practice, retain Operator ID records permanently. Do not delete rows that correspond to former operators. You can change the operator password to prevent anyone from logging on, and can mark the operator as unavailable for work.
Caution: The Storage Stream column (pzPVStream) of this table contains user passwords in hashed form. For maximum security of your system, do not alter the schema for this table to expose this property as a column.
The pi_data_connect table is associated with the Data-Admin-Connect- class. Instances of the classes derived from this class support service listeners and related interface data.
For example, JMS listeners are instances of the Data-Admin-Connect-JMSListener class.
The pr_data_admin table holds instances of classes derived from the Data-Admin- class, excluding those explicitly mapped to other tables:
For example instances of the Data-Admin-System-Settings class are mapped to the pr_data_admin table.
The pc_data_uniqueid table corresponds to the Data-UniqueID class, and contains a single row for each work item ID format in use. This row records the most recently assigned work item ID of that format, usually computed by a stored procedure.
For example, if the most recent purchase order is PO-4253, then when the next purchase order is entered, the value of the pyLastReservedID property increments to 4254.
Attachments to work items are instances of concrete classes derived from the Data-WorkAttach- class. In the initial Pega 7 Platform database schema, this class is linked to the pc_data_workattach table. (However, the attachment itself is included for content or Enterprise Content Managment (ECM) attachments, which are saved in an external document repository and are accessed using Connect CMIS rules.)
The pzInsKey value for a work item attachment consists of values of these properties, concatenated into a single string:
DATA-ADMIN-WORKATTACH-FILEFor example, a note attached to work item W-15 on November 10, 2009 may have the following pzInsKey value:
DATA-WORKATTACH-NOTE PEGASAMPLE W-15!20091110T195841.692 GMT
Instances of the Data-WorkAttach-File class may contain an uploaded file of any type, up to 1 Gigabyte in initial size, which is converted to text, if necessary, using Base64 encoding. Instances of the Data-WorkAttach-ScanDocument and Data-WorkAttach-ScreenShot classes both contain images, which are also converted using Base64 encoding.
Instances of these three Data- classes are associated with the pr4_base table:
These are known as foundation classes.
Instances of two Data- classes that support the use of features of Automated Unit Testing are associated with the pr_data_autotest table:
See About Automated Unit Testing.
Instances of the Data-Content-Image class are associated with the pr_data_file table. See About Image Content data instances.
When you create a data table by using the Data Table wizard, you can optionally cause instances of the data table class to be stored in a new database table. This choice simplifies future migration of the contents of the database table if necessary, and can improve performance and facilitate reporting on data table contents. Typically, the data table class is derived from the Data- base class and the new table is named pr_zzzzz, where zzzzz is the class name.
Note: In Pega 7.1.7 and later, local data storage replaced data tables.
The pr_data table holds instances of any concrete class derived from the Data- base class not covered by the tables listed in this topic. For example, (as initially configured during installation) the Data-Party-Com, Data-Party-Person and Data-Corr-Email classes map to this table.
The pr_data table has only a few exposed columns. As a best practice for good performance, configure your Pega 7 Platform database so that classes with a high volume of saved instances or activities are not mapped to this table.
A few Data- classes (for example Data-RuleSearch and Data-Work-Summary) are mapped to the pr_data table but do not correspond to any rows of that table. These classes are the Applies To class of specialized reports that access various database tables using custom getContent activities. Running the reports does not access the pr_data table.