WebSphere Commerce database table: CATRELTYPE
This table describes the types of containment relationships between catalog entries, such as types for ProductItems and PackageComponents.
Column Descriptions
| 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 |
| SQL060903235139700
| CATRELTYPE_ID
| Primary Key
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_198
| CATRELTYPE_ID
| CATENTREL
| CATRELTYPE_ID
| Cascade
|
Related reference