Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATGRPREL
This tables relates catalog groups(or categories) to child catalog group (or child categories). You can use this table to dictate the navigational flow from catalog groups to child catalog groups. Each relationship is also qualified by a Catalog ID.
Column Name Column Type Description CATGROUP_ID_PARENT BIGINT NOT NULL The source catalog group of this relationship. CATGROUP_ID_CHILD BIGINT NOT NULL The target catalog group 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 catalog group. 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030312790 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference
_vcc_freeselect_bottom_