Database Table: PKGITEMREL

This table holds the relationship between Packages, and the Items they contain. This table is deprecated and is provided for backward compatibility only.

Column Name Column Type Column Description
CATENTRY_ID_ITEM BIGINT
NOT NULL
The reference number of an Item that is contained within a Package.
CATENTRY_ID_PARENT BIGINT
NOT NULL
The reference number of the unresolved Package.
CATENTRY_ID_PKG BIGINT
NOT NULL
The reference number of the fully resolved Package.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035033170 CATENTRY_ID_ITEM, CATENTRY_ID_PKG, CATENTRY_ID_PARENT Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_594 CATENTRY_ID_ITEM CATENTRY CATENTRY_ID Cascade
F_595 CATENTRY_ID_PKG CATENTRY CATENTRY_ID Cascade
F_596 CATENTRY_ID_PARENT CATENTRY CATENTRY_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable