Required columns for tables
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).