PX_TPLTGRP

This table records details about relationships between entries in the PX_TEMPLATE and PX_GROUP tables.

Column Descriptions:

NameTypeDescription
PX_TEMPLATE_IDINTEGER NOT NULLForeign key to the PX_TEMPLATE table.
PX_GROUP_IDINTEGER NOT NULLForeign key to the PX_GROUP table.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
I0000423PX_TEMPLATE_IDNon-Unique Index
I0000424PX_GROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1082PX_TEMPLATE_IDPX_TEMPLATEPX_TEMPLATE_IDCascade
F_1083PX_GROUP_IDPX_GROUPPX_GROUP_IDCascade