WebSphere Commerce database table: CATGPENREL

This table relates CatalogGroups (or Categories) to the CatalogEntries that are inside them. You can also use this table to dictate the navigational flow from CatalogGroups to CatalogEntries. Each relationship is also qualified by a Catalog ID.


Column Description(s):
Column NameColumn TypeDescription
CATGROUP_ID BIGINT NOT NULL The source CatalogGroup of this relationship.
CATALOG_ID BIGINT NOT NULL The Catalog inside of which this relationship is found.
CATENTRY_ID BIGINT NOT NULL The target CatalogEntry 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 CatalogGroup.
LASTUPDATE TIMESTAMP Indicates the last time that this relationship was updated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031209640 CATGROUP_ID+CATENTRY_ID+CATALOG_ID Primary Key
I0000523 CATALOG_ID Non-Unique Index
I0000524 CATENTRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback