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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031255190 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback