WebSphere Commerce database table: PKGITEMREL

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 Descriptions
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

SQL060903235230130 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

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.

Index Name	Indexed Column Names	Index Type
SQL060903235230130	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 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