WebSphere Commerce database table: CATENTREL

This table holds containment relationships between CatalogEntries. Examples of these relationships are Product-Item, Bundle, and Package relationships. This table should not be used for peer-to-peer catalog relationships, such as cross-sells.


Column Description(s):
Column NameColumn TypeDescription
CATENTRY_ID_PARENT BIGINT NOT NULL The reference number of the source CatalogEntry in this relationship.
CATRELTYPE_ID CHAR(32) NOT NULL The type of relationship: PRODUCT_ITEM, PACKAGE_COMPONENT or BUNDLE_COMPONENT. Foreign key to the CATRELTYPE table.
CATENTRY_ID_CHILD BIGINT NOT NULL The reference number of the target CatalogEntry in this relationship.
SEQUENCE DOUBLE NOT NULL DEFAULT 0 The sequence number used to determine the display order.
QUANTITY DOUBLE The number of children associated with this parent.
GROUPNAME VARCHAR(254) Reserved for IBM internal use.
FIELD1 VARCHAR(254) Customizable.
FIELD2 INTEGER Customizable.
FIELD3 DECIMAL (20,5) Customizable.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
MANDATORY CHAR(3) Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031208940 CATRELTYPE_ID+CATENTRY_ID_PARENT+CATENTRY_ID_CHILD Primary Key
I0000365 CATENTRY_ID_CHILD+CATRELTYPE_ID Non-Unique Index
I0000517 CATENTRY_ID_PARENT Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_199 CATENTRY_ID_PARENT CATENTRY CATENTRY_ID Cascade
F_200 CATENTRY_ID_CHILD CATENTRY CATENTRY_ID Cascade
F_198 CATRELTYPE_ID CATRELTYPE CATRELTYPE_ID Cascade

Feedback