CATRELTYPE

This table describes the types of containment relationships between catalog entries, such as types for ProductItems and PackageComponents.

Column Descriptions:

NameTypeDescription
CATRELTYPE_IDCHAR (32) NOT NULLThe identifier of this catalog entry relationship type:
  • PRODUCT_ITEM
  • PACKAGE_COMPONENT
  • BUNDLE_COMPONENT
  • DYNAMIC_KIT_COMPONENT
  • DK_PDK
  • PDK_COMPONENT</>
  • PRODUCT_VARIANT
  • VARIANT_ITEM
DESCRIPTIONVARCHAR (254)A description for this catalog entry relationship type.
FIELD1INTEGERCustomizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
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_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_198CATRELTYPE_IDCATENTRELCATRELTYPE_IDCascade