LinkedIn
Copied!

Table of Contents

Required columns for tables

Version:

Only available versions of this content are shown in the dropdown

Every database table that you add to the Pega Platform database must contain these five columns.

  • pxObjClass — The Pega Platform class name, typically VARCHAR2(96 ).
  • pxCreateDateTime — The date, typically DATE. This column has a different name in a few tables.
  • pyLabel — A short description, VARCHAR2(64)
  • pzInsKey — Primary key, always includes the pxObjClass value or a class group name, VARCHAR2 (255) NOT NULL. The pzInskey column is identified as the unique key to the table by using a constraint.
  • pzPVStream — The storage stream ( BLOB).

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.