Database Table: CATENTREL

This table holds containment relationships between CatalogEntries. 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 Name Column Type Column Description
CATENTRY_ID_CHILD BIGINT
NOT NULL
The reference number of the target CatalogEntry in this relationship.
CATENTRY_ID_PARENT BIGINT
NOT NULL
The reference number of the source CatalogEntry in this relationship.
CATRELTYPE_ID CHARACTER (32)
NOT NULL
The type of relationship: PRODUCT_ITEM, PACKAGE_COMPONENT or BUNDLE_COMPONENT. Foreign key to the CATRELTYPE table.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 INTEGER
NULL
Customizable.
FIELD3 DECIMAL (20,5)
NULL
Customizable.
GROUPNAME VARCHAR (254)
NULL
Reserved for IBM internal use.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
QUANTITY DOUBLE
NULL
A quantity that can be associated with the relationship.
SEQUENCE DOUBLE
NOT NULL, DEFAULT 0
The sequence number used to determine the display order.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034900150 CATRELTYPE_ID, CATENTRY_ID_PARENT, CATENTRY_ID_CHILD Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_198 CATRELTYPE_ID CATRELTYPE CATRELTYPE_ID Cascade
F_199 CATENTRY_ID_PARENT CATENTRY CATENTRY_ID Cascade
F_200 CATENTRY_ID_CHILD CATENTRY CATENTRY_ID Cascade

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