CATGROUP
This table hold the information related to a catalog group. A catalog group is similar to a generic category that can contain both other catalog groups and also catalog entries.
Column Descriptions:
Name Type Description CATGROUP_ID BIGINT NOT NULL The internal reference number of the catalog group. MEMBER_ID BIGINT NOT NULL The internal reference number that identifies the owner of the catalog group. Along with IDENTIFIER, these columns are a unique index. IDENTIFIER VARCHAR (254) The external name used to identify the catalog group. Along with MEMBER_ID, these columns are a unique index. MARKFORDELETE INTEGER NOT NULL Indicates if this catalog group has been marked for deletion:
0 = No.
1 = Yes.LASTUPDATE TIMESTAMP Indicates the last time that this catalog group was updated. FIELD1 VARCHAR (254) Customizable. FIELD2 VARCHAR (254) Customizable. OID VARCHAR (64) Reserved for IBM internal use. RANK DOUBLE Reserved for IBM internal use. UP_IDENTIFIER VARCHAR (254) The equivalent value of the IDENTIFIER column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center. DYNAMIC INTEGER DEFAULT 0 This column indicates the type of dynamic category.
0 = Non-Dynamic Category
1 = Rule Based CategoryOPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> CATGROUP_ID Primary Key I0000067 IDENTIFIER+MEMBER_ID Unique Index I0000376 RANK Non-Unique Index I0000525 MEMBER_ID Non-Unique Index IPF00001 UP_IDENTIFIER Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_216 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_210 CATGROUP_ID CATGPCALCD CATGROUP_ID Cascade F_213 CATGROUP_ID CATGPENREL CATGROUP_ID Cascade F_217 CATGROUP_ID CATGRPATTR CATGROUP_ID Cascade F_219 CATGROUP_ID CATGRPDESC CATGROUP_ID Cascade F_222 CATGROUP_ID CATGRPPS CATGROUP_ID Cascade F_224 CATGROUP_ID CATGRPREL CATGROUP_ID_CHILD Cascade F_225 CATGROUP_ID CATGRPREL CATGROUP_ID_PARENT Cascade F_229 CATGROUP_ID CATGRPTPC CATGROUP_ID Cascade F_231 CATGROUP_ID CATTOGRP CATGROUP_ID Cascade F_298 CATGROUP_ID DISPCGPREL CATGROUP_ID Cascade F_361 CATGROUP_ID ICEXPLFEAT CATGROUP_ID Cascade F_3620 CATGROUP_ID INSRULECATGRP CATGROUP_ID Cascade F_3674 CATGROUP_ID CFCATGROUP CATGROUP_ID Cascade F_3735 CATGROUP_ID FACETCATGRP CATGROUP_ID Cascade F_376 CATGROUP_ID ICROOTCAT CATGROUP_ID Cascade F_3764 CATGROUP_ID SRCHPROPRELV CATGROUP_ID Cascade F_3770 CATGROUP_ID CATGRPRULE CATGROUP_ID Cascade F_3775 CATGROUP_ID CEDISPCTX CATGROUP_ID Cascade F_3779 CATGROUP_ID CEDYNDISPCTX CATGROUP_ID Cascade F_3788 CATGROUP_ID CATGROUP_EXTERNAL_CONTENT_REL CATGROUP_ID Cascade F_435 CATGROUP_ID MASSOCGPGP CATGROUP_ID_TO Cascade F_436 CATGROUP_ID MASSOCGPGP CATGROUP_ID_FROM Cascade F_783 CATGROUP_ID STORECGRP CATGROUP_ID Cascade F_948 CATGROUP_ID ICROOTCAT ROOTCATEGORYID Cascade F_977 CATGROUP_ID CPPMNCAT CATGROUP_ID Cascade
Related reference
Calculation code - indirect attachment data model
Catalog data model
Catalog entry data model
Catalog group data model
Merchandising association data model
Product set data model
User traffic data model