CATGRPDESC

This table holds the language-dependent information related to a catalog group.

Column Descriptions:

NameTypeDescription
LANGUAGE_IDINTEGER NOT NULLThe identifier of the language. For a list of language components, see the LANGUAGE table.
CATGROUP_IDBIGINT NOT NULLThe internal reference number that indicates to which catalog group this language-specific information relates.
NAMEVARCHAR (254) NOT NULLThe language-dependent name of this catalog group. The name field corresponds to the Name field of each category in the Management Center's Catalogs tool. This field can contain a comma separated list of nouns representing products within a category. This can then be used for the product-category mapping of the category-based search relevancy feature.
SHORTDESCRIPTIONVARCHAR (254)A short description of this catalog group. The shortDescription field corresponds to the ShortDescription field of each category in the Management Center's Catalogs tool. This field can contain a comma separated list of nouns representing products within a category. This can then be used for the product-category mapping of the category-based search relevancy feature.
LONGDESCRIPTIONVARCHAR (4000)A long description of this catalog group. The longDescription field corresponds to the LongDescription field of each category in the Management Center's Catalogs tool. This field can contain a comma separated list of nouns representing products within a category. This can then be used for the product-category mapping of the category-based search relevancy feature.
THUMBNAILVARCHAR (254)The thumbnail image path of this catalog group.
FULLIMAGEVARCHAR (254)The full image path of this catalog group.
PUBLISHEDINTEGER NOT NULLIndicates whether this catalog group should be displayed for the language indicated by LANGUAGE_ID: 0=no, 1=yes.
DISPLAYVARCHAR (254)Reserved for HCL internal use.
KEYWORDVARCHAR (4000)A keyword used for searching. The keyword field corresponds to the Keyword field of each category in the Management Center's Catalogs tool. This field can contain a comma separated list of nouns representing products within a category. This can then be used for the product-category mapping of the category-based search relevancy feature.
NOTEVARCHAR (4000)The footnotes or extended long description for this catalog group.
UP_NAMECHAR (254)The equivalent value of the NAME 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.
UP_SHORTDESCCHAR (254)The equivalent value of the SHORTDESC 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.
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_ID+LANGUAGE_IDPrimary Key
IPF00022UP_NAMENon-Unique Index
IPF00023UP_SHORTDESCNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_219CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_220LANGUAGE_IDLANGUAGELANGUAGE_IDCascade