Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CATRELTYPE

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

Column Name Column Type Description
CATRELTYPE_ID CHAR(32) NOT NULL The identifier of this catalog entry relationship type:

  • PRODUCT_ITEM

  • PACKAGE_COMPONENT

  • BUNDLE_COMPONENT

  • DYNAMIC_KIT_COMPONENT

DESCRIPTION VARCHAR(254) A description for this catalog entry relationship type.
FIELD1 INTEGER Customizable.
FIELD2 DECIMAL (20,5) Customizable.
FIELD3 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030313180 CATRELTYPE_ID Primary Key

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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search