Database Table: CATGROUP

This table hold the information related to a CatalogGroup. Think of a CatalogGroup as a generic Category that can contain both other CatalogGroups and also CatalogEntries.

Column Name Column Type Column Description
CATGROUP_ID BIGINT
NOT NULL
The internal reference number of the CatalogGroup.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
IDENTIFIER VARCHAR (254)
NULL
The external name that is used to identify the CatalogGroup. Along with MEMBER_ID, these columns are a unique index.
LASTUPDATE TIMESTAMP
NULL
Indicates the last time that this CatalogGroup was updated.
MARKFORDELETE INTEGER
NOT NULL
Indicates if this CatalogGroup has been marked for deletion:
0 = No.
1 = Yes.
MEMBER_ID BIGINT
NOT NULL
The internal reference number that identifies the owner of the CatalogGroup. Along with IDENTIFIER, these columns are a unique index.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000067 IDENTIFIER, MEMBER_ID Unique Index
SQL030416034903590 CATGROUP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_216 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint 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_376 CATGROUP_ID ICROOTCAT 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_937 CATGROUP_ID USRTRAFFIC CATGROUP_ID Cascade
F_948 CATGROUP_ID ICROOTCAT ROOTCATEGORYID Cascade
F_977 CATGROUP_ID CPPMNCAT CATGROUP_ID Cascade