WebSphere Commerce database table: CATGRPDESC

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

Column Descriptions
Column Name Column Type Description
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 catalog group this language-specific information relates.
NAME VARCHAR(254) NOT NULL The language-dependent name of this catalog group.
SHORTDESCRIPTION VARCHAR(254) A short description of this catalog group.
LONGDESCRIPTION VARCHAR(4000) A long description of this catalog group.
THUMBNAIL VARCHAR(254) The thumbnail image path of this catalog group.
FULLIMAGE VARCHAR(254) The full image path of this catalog group.
PUBLISHED INTEGER NOT NULL Indicates whether this catalog group 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 catalog group.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235139080 CATGROUP_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_219 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_220 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade