Working with the PegaRULES database
Link tables

This topic describes PegaRULES database tables with names that start with one of these values:

pc_link

pr_link

Instances of concrete classes derived from the Index- base class support reporting and rapid data access. These instances are created and deleted by Declare Index rules.

Eight standard database tables can store index instances.

The pzInsKey value for rows of these tables is formed from the properties pxInsIndexedKey, pxIndexCount, and pxIndexPurpose, in that order. The pxIndexCount property makes each row unique. This property is zero-based; the first (oldest) index instance has a pxIndexCount of 0. The pxIndexPurpose key part identifies the Declare Index rule that created the index

Don't confuse these tables — which contain rows automatically created and deleted by Process Commander rules of type Rule-Declare-Index — with database indexes, defined by SQL that is maintained within the database by Oracle or other database software. Both support alternate key access to other instances (rows), but the two indexing facilities are independent and unrelated.

Four tables can hold instances of concrete classes derived from the Link- base class:

Table	Description
pr_link_attachment	Supports the association of a work object attachment with a work object, as instances of the Link-Attachment class. Contains one row for each attachment.
pc_link_folder	Supports the association of a work object with a folder, as instances of the Link-Folder class. This can be a many-to-many relation.
pc_link_topcase	xxxxxxxxxx Link-TopCase class. xxxxxxxxxxxxx
pr_link_usecase	Supports the association of a use case rule with an activity, flow, or other rules that support the use case. Also supports the association of an Application Requirement rule with an application rule. Corresponds to the Link-Requirement and Link-UseCase classes. 5.4 See About Application Use Case rules and About Application Requirement rules.
pr_link	Not used by any standard class. Default table for instances of other Link- classes.