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:

NameTypeDescription
CATENTRY_ID_PARENTBIGINT NOT NULLThe reference number of the source catalog entry in this relationship.
CATRELTYPE_IDCHAR (32) NOT NULLThe type of relationship:
  • PRODUCT_ITEM
  • PACKAGE_COMPONENT
  • BUNDLE_COMPONENT
  • DYNAMIC_KIT_COMPONENT
Foreign key to the CATRELTYPE table.
CATENTRY_ID_CHILDBIGINT NOT NULLThe reference number of the target catalog entry in this relationship.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence number used to determine the display order.
QUANTITYDOUBLEA quantity that can be associated with the relationship.
GROUPNAMEVARCHAR (254)Reserved for HCL internal use.
FIELD1VARCHAR (254)Customizable.
FIELD2INTEGERCustomizable.
FIELD3DECIMAL (20,5)Customizable.
OIDVARCHAR (64)Reserved for HCL internal use.
MANDATORYCHAR (3)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED> CATRELTYPE_ID+CATENTRY_ID_PARENT+CATENTRY_ID_CHILDPrimary Key
I0000365CATENTRY_ID_CHILD+CATRELTYPE_IDNon-Unique Index
I0000517CATENTRY_ID_PARENTNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_198CATRELTYPE_IDCATRELTYPECATRELTYPE_IDCascade
F_199CATENTRY_ID_PARENTCATENTRYCATENTRY_IDCascade
F_200CATENTRY_ID_CHILDCATENTRYCATENTRY_IDCascade