Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATGRPDESC
This table holds the language-dependent information related to a catalog group.
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 SQL100520030312420 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
Related reference
_vcc_freeselect_bottom_