Database Table: CATRELTYPE

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

Column Name Column Type Column Description
CATRELTYPE_ID CHARACTER (32)
NOT NULL
The identifier of this CatalogEntry relationship type: PRODUCT_ITEM, PACKAGE_COMPONENT or BUNDLE_COMPONENT.
DESCRIPTION VARCHAR (254)
NULL
A description for this CatalogEntry Relationship type.
FIELD1 INTEGER
NULL
Customizable.
FIELD2 DECIMAL (20,5)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034905650 CATRELTYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_198 CATRELTYPE_ID CATENTREL CATRELTYPE_ID Cascade