Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATALOGDSC
This table holds language-dependent information related to a catalog.
Column Name Column Type Description CATALOG_ID BIGINT NOT NULL The internal reference number relating this language specific information to a catalog. LANGUAGE_ID INTEGER NOT NULL The identifier of the language. For a list of language identifiers, see the LANGUAGE table. NAME VARCHAR(254) NOT NULL The language-dependent name of this catalog. SHORTDESCRIPTION VARCHAR(254) A short description of this catalog. LONGDESCRIPTION VARCHAR(4000) A long description of this catalog. THUMBNAIL VARCHAR(254) The thumbnail image path of this catalog. FULLIMAGE VARCHAR(254) The image path of this catalog. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030309700 LANGUAGE_ID+CATALOG_ID Primary Key I0000512 CATALOG_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_185 CATALOG_ID CATALOG CATALOG_ID Cascade F_184 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference
_vcc_freeselect_bottom_