WebSphere Commerce database table: CATRELTYPE

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


Column Description(s):
Column NameColumn TypeDescription
CATRELTYPE_ID CHAR(32) NOT NULL The identifier of this CatalogEntry relationship type: PRODUCT_ITEM, PACKAGE_COMPONENT or BUNDLE_COMPONENT.
DESCRIPTION VARCHAR(254) A description for this CatalogEntry Relationship type.
FIELD1 INTEGER Customizable.
FIELD2 DECIMAL (20,5) Customizable.
FIELD3 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031210670 CATRELTYPE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_198 CATRELTYPE_ID CATENTREL CATRELTYPE_ID Cascade

Feedback