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:
| Name | 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 HCL internal use. |
| FIELD1 | VARCHAR (254) | Customizable. |
| FIELD2 | INTEGER | Customizable. |
| FIELD3 | DECIMAL (20,5) | Customizable. |
| OID | VARCHAR (64) | Reserved for HCL internal use. |
| MANDATORY | CHAR (3) | Reserved for HCL internal use. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> |
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 |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |