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 Description(s):
Column Name | Column Type | Description |
CATENTRY_ID_PARENT |
BIGINT NOT NULL |
The reference number of the source CatalogEntry in this relationship. |
CATRELTYPE_ID |
CHAR(32) NOT NULL |
The type of relationship: PRODUCT_ITEM, PACKAGE_COMPONENT or BUNDLE_COMPONENT. Foreign key to the CATRELTYPE table. |
CATENTRY_ID_CHILD |
BIGINT NOT NULL |
The reference number of the target CatalogEntry in this relationship. |
SEQUENCE |
DOUBLE NOT NULL DEFAULT 0 |
The sequence number used to determine the display order. |
QUANTITY |
DOUBLE |
The number of children associated with this parent. |
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031208940 |
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 |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.