Skip to main content
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).
Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us