Discussion

3
Replies
7297
Views
 Saikat Chakrabortty (Saikat_Chakrabortty)
Capgemini
Pega Developer
Capgemini
IN
Saikat_Chakrabortty Member since 2013 34 posts
Capgemini
Posted: April 7, 2016
Last activity: April 25, 2016
Posted: 7 Apr 2016 11:19 EDT
Last activity: 25 Apr 2016 2:54 EDT
Closed

Difference between pr_ and pc_ table naming convention

Hi,

 

This question might be little silly. I was wondering what is the difference between the naming convention of database table when it is created from Data type. As per my assumption when we create work class try to map to table it is pc_, and when data class it is pr_.  Can any one guide me the basic algo for generating the data table name.

 

 

-Saikat
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 5 years ago
Updated: 5 years ago
Posted: 9 Apr 2016 10:33 EDT
Updated: 9 Apr 2016 10:32 EDT
Phani Sahukaru (sahup1)
PEGA
Architect - Financial Services
Pegasystems Inc.
IN
pc_ identifies tables containing instances corresponding to Pega-ProCom RuleSet capabilities, such as flows, work objects, and assignments. 

pr_ and pr4_ identify tables for activities, properties, requestors, and other features of the rules engine, corresponding to Pega-RULES RuleSet capabilities. 


 
Posted: 5 years ago
Posted: 25 Apr 2016 2:54 EDT
Hitesh Jain (Hitesh Jain)
Aaseya IT Services Pvt Ltd

Aaseya IT Services Pvt Ltd
GB

a) Starting with pr4_  : All core rules of pega (flows,properties etc) are stored in tables with pr4_ as prefix.Similarly all analytical data about the rules are also stored in pr4_ tables. ex: PR4_LOG_RULE_USAGE.


b) Starting with pr_ : These tables are generally cache tables, data rules tables,queues etc.


c) Starting with pc_ : These are the traditional data tables (pega terminology) . Work tables, work history tables, attachments,links etc