WebSphere Commerce database table: CATTOGRP

This table identifies the root CatalogGroups (or root Categories) contained within a Catalog.


Column Description(s):
Column NameColumn TypeDescription
CATALOG_ID BIGINT NOT NULL The reference number of the Catalog.
CATGROUP_ID BIGINT NOT NULL The reference number of the CatalogGroup.
LASTUPDATE TIMESTAMP The last time that this relationship was updated.
SEQUENCE DOUBLE The sequence number used to determine display order.
CATALOG_ID_LINK BIGINT Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031210840 CATALOG_ID+CATGROUP_ID Primary Key
I0000373 CATALOG_ID_LINK Non-Unique Index
I0000532 CATGROUP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1033 CATALOG_ID_LINK CATALOG CATALOG_ID Cascade
F_230 CATALOG_ID CATALOG CATALOG_ID Cascade
F_231 CATGROUP_ID CATGROUP CATGROUP_ID Cascade

Feedback