WebSphere Commerce database table: CATGRPDESC

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


Column Description(s):
Column NameColumn TypeDescription
LANGUAGE_ID INTEGER NOT NULL The identifier of the language. For a list of language components, see the LANGUAGE table.
CATGROUP_ID BIGINT NOT NULL The internal reference number that indicates to which CatalogGroup this language-specific information relates.
NAME VARCHAR(254) NOT NULL The language-dependent name of this CatalogGroup.
SHORTDESCRIPTION VARCHAR(254) A short description of this CatalogGroup.
LONGDESCRIPTION VARCHAR(4000) A long description of this CatalogGroup.
THUMBNAIL VARCHAR(254) The thumbnail image path of this CatalogGroup.
FULLIMAGE VARCHAR(254) The full image path of this CatalogGroup.
PUBLISHED INTEGER NOT NULL Indicates whether this CatalogGroup should be displayed for the language indicated by LANGUAGE_ID: 0=no, 1=yes.
DISPLAY VARCHAR(254) Reserved for IBM internal use.
KEYWORD VARCHAR(254) A keyword used for searching.
NOTE VARCHAR(4000) The footnotes or extended long description for this CatalogGroup.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031210100 CATGROUP_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_219 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_220 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback