Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce 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 Description 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. CATENTRY_ID_ITEM BIGINT NOT NULL The reference number of an item that is contained within a package. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030409760 CATENTRY_ID_ITEM+CATENTRY_ID_PKG+CATENTRY_ID_PARENT Primary Key I0000693 CATENTRY_ID_PARENT Non-Unique Index I0000694 CATENTRY_ID_PKG Non-Unique Index
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 _vcc_freeselect_bottom_