WebSphere Commerce database table: CATENTREL

This table holds containment relationships between catalog entries. Examples of these relationships are Product-Item, Bundle, and Package relationships. This table should not be used for peer-to-peer catalog relationships, such as cross-sells.

Column Descriptions
Column Name Column Type Description
CATENTRY_ID_PARENT BIGINT NOT NULL The reference number of the source catalog entry in this relationship.
CATRELTYPE_ID CHAR(32) NOT NULL The type of relationship:

  • PRODUCT_ITEM

  • PACKAGE_COMPONENT

  • BUNDLE_COMPONENT

  • DYNAMIC_KIT_COMPONENT

Foreign key to the CATRELTYPE table.

CATENTRY_ID_CHILD BIGINT NOT NULL The reference number of the target catalog entry in this relationship.
SEQUENCE DOUBLE NOT NULL DEFAULT 0 The sequence number used to determine the display order.
QUANTITY DOUBLE A quantity that can be associated with the relationship.
GROUPNAME VARCHAR(254) Reserved for IBM internal use.
FIELD1 VARCHAR(254) Customizable.
FIELD2 INTEGER Customizable.
FIELD3 DECIMAL (20,5) Customizable.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
MANDATORY CHAR(3) Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235137900 CATRELTYPE_ID+CATENTRY_ID_PARENT+CATENTRY_ID_CHILD Primary Key
I0000365 CATENTRY_ID_CHILD+CATRELTYPE_ID Non-Unique Index
I0000517 CATENTRY_ID_PARENT Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_199 CATENTRY_ID_PARENT CATENTRY CATENTRY_ID Cascade
F_200 CATENTRY_ID_CHILD CATENTRY CATENTRY_ID Cascade
F_198 CATRELTYPE_ID CATRELTYPE CATRELTYPE_ID Cascade
Related reference