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:

NameTypeDescription
CATGROUP_IDBIGINT NOT NULLThe internal reference number of the catalog group.
MEMBER_IDBIGINT NOT NULLThe internal reference number that identifies the owner of the catalog group. Along with IDENTIFIER, these columns are a unique index.
IDENTIFIERVARCHAR (254)The external name that is used to identify the catalog group. Along with MEMBER_ID, these columns are a unique index.
MARKFORDELETEINTEGER NOT NULLIndicates if this catalog group has been marked for deletion: 0 = No. 1 = Yes.
LASTUPDATETIMESTAMPIndicates the last time that this catalog group was updated.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
OIDVARCHAR (64)Reserved for HCL internal use.
RANKDOUBLEReserved for HCL internal use.
UP_IDENTIFIERVARCHAR (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.
DYNAMICINTEGER DEFAULT 0This column indicates the type of dynamic category. 0 = Non-Dynamic Category 1 = Rule Based Category
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATGROUP_IDPrimary Key
I0000067IDENTIFIER+MEMBER_IDUnique Index
I0000376RANKNon-Unique Index
I0000525MEMBER_IDNon-Unique Index
IPF00001UP_IDENTIFIERNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_216MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_210CATGROUP_IDCATGPCALCDCATGROUP_IDCascade
F_213CATGROUP_IDCATGPENRELCATGROUP_IDCascade
F_217CATGROUP_IDCATGRPATTRCATGROUP_IDCascade
F_219CATGROUP_IDCATGRPDESCCATGROUP_IDCascade
F_222CATGROUP_IDCATGRPPSCATGROUP_IDCascade
F_224CATGROUP_IDCATGRPRELCATGROUP_ID_CHILDCascade
F_225CATGROUP_IDCATGRPRELCATGROUP_ID_PARENTCascade
F_229CATGROUP_IDCATGRPTPCCATGROUP_IDCascade
F_231CATGROUP_IDCATTOGRPCATGROUP_IDCascade
F_298CATGROUP_IDDISPCGPRELCATGROUP_IDCascade
F_361CATGROUP_IDICEXPLFEATCATGROUP_IDCascade
F_3620CATGROUP_IDINSRULECATGRPCATGROUP_IDCascade
F_3674CATGROUP_IDCFCATGROUPCATGROUP_IDCascade
F_3735CATGROUP_IDFACETCATGRPCATGROUP_IDCascade
F_376CATGROUP_IDICROOTCATCATGROUP_IDCascade
F_3764CATGROUP_IDSRCHPROPRELVCATGROUP_IDCascade
F_3770CATGROUP_IDCATGRPRULECATGROUP_IDCascade
F_3775CATGROUP_IDCEDISPCTXCATGROUP_IDCascade
F_3779CATGROUP_IDCEDYNDISPCTXCATGROUP_IDCascade
F_3788CATGROUP_IDCATGROUP_EXTERNAL_CONTENT_RELCATGROUP_IDCascade
F_435CATGROUP_IDMASSOCGPGPCATGROUP_ID_TOCascade
F_436CATGROUP_IDMASSOCGPGPCATGROUP_ID_FROMCascade
F_783CATGROUP_IDSTORECGRPCATGROUP_IDCascade
F_948CATGROUP_IDICROOTCATROOTCATEGORYIDCascade
F_977CATGROUP_IDCPPMNCATCATGROUP_IDCascade