WebSphere Commerce database table: CATGRPREL

This tables relates CatalogGroups (or Categories) to SubCatalogGroups (or SubCategories). You can use this table to dictate the navigational flow from CatalogGroups to SubCatalogGroups. Each relationship is also qualified by a Catalog ID.


Column Description(s):
Column NameColumn TypeDescription
CATGROUP_ID_PARENT BIGINT NOT NULL The source CatalogGroup of this relationship.
CATGROUP_ID_CHILD BIGINT NOT NULL The target CatalogGroup of this relationship.
CATALOG_ID BIGINT NOT NULL The Catalog in which this relationship is found.
RULE VARCHAR(254) Reserved for IBM internal use.
SEQUENCE DOUBLE NOT NULL DEFAULT 0 The sequence number that determines the display order of the contents of the CatalogGroup.
LASTUPDATE TIMESTAMP Indicates the last time that this relationship was updated.
CATALOG_ID_LINK BIGINT Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031210420 CATGROUP_ID_CHILD+CATGROUP_ID_PARENT+CATALOG_ID Primary Key
I0000294 CATALOG_ID_LINK Non-Unique Index
I0000527 CATALOG_ID Non-Unique Index
I0000528 CATGROUP_ID_PARENT Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_226 CATALOG_ID CATALOG CATALOG_ID Cascade
F_983 CATALOG_ID_LINK CATALOG CATALOG_ID Cascade
F_224 CATGROUP_ID_CHILD CATGROUP CATGROUP_ID Cascade
F_225 CATGROUP_ID_PARENT CATGROUP CATGROUP_ID Cascade

Feedback