Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATENTREL
This table holds containment relationships between catalog entries. 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 Name Column Type Description CATENTRY_ID_PARENT BIGINT NOT NULL The reference number of the source catalog entry in this relationship. CATRELTYPE_ID CHAR(32) NOT NULL The type of relationship:
- PRODUCT_ITEM
- PACKAGE_COMPONENT
- BUNDLE_COMPONENT
- DYNAMIC_KIT_COMPONENT
Foreign key to the CATRELTYPE table.
CATENTRY_ID_CHILD BIGINT NOT NULL The reference number of the target catalog entry in this relationship. SEQUENCE DOUBLE NOT NULL DEFAULT 0 The sequence number used to determine the display order. QUANTITY DOUBLE A quantity that can be associated with the relationship. 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030310840 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference
_vcc_freeselect_bottom_