Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATGPENREL
This table relates catalog groups (or categories) to the catalog entries that are inside them. You can also use this table to dictate the navigational flow from catalog groups to catalog entries. Each relationship is also qualified by a Catalog ID.
Column Name Column Type Description CATGROUP_ID BIGINT NOT NULL The source catalog group of this relationship. CATALOG_ID BIGINT NOT NULL The catalog inside of which this relationship is found. CATENTRY_ID BIGINT NOT NULL The target catalog entry of this relationship. 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. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030311850 CATGROUP_ID+CATENTRY_ID+CATALOG_ID Primary Key I0000523 CATALOG_ID Non-Unique Index I0000524 CATENTRY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_215 CATALOG_ID CATALOG CATALOG_ID Cascade F_214 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_213 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
Related reference
_vcc_freeselect_bottom_