Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATTOGRP
This table identifies the root catalog groups (or root categories) contained within a catalog.
Column Name Column Type Description CATALOG_ID BIGINT NOT NULL The reference number of the catalog. CATGROUP_ID BIGINT NOT NULL The reference number of the catalog group. 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030313320 CATALOG_ID+CATGROUP_ID Primary Key I0000373 CATALOG_ID_LINK Non-Unique Index I0000532 CATGROUP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference
_vcc_freeselect_bottom_