WebSphere Commerce database table: CATALOGDSC

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

Column Descriptions
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
SQL060903235136740 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