WebSphere Commerce database table: CATENTDESC

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


Column Description(s):
Column NameColumn TypeDescription
CATENTRY_ID BIGINT NOT NULL The internal reference number that indicates to which CatalogEntry this language-specific information relates.
LANGUAGE_ID INTEGER NOT NULL The Identifier of the language. For a list of language components, see the LANGUAGE table.
NAME CHAR(128) The language-dependent name of this CatalogEntry.
SHORTDESCRIPTION VARCHAR(254) A short description of this CatalogEntry.
LONGDESCRIPTION CLOB A long description of this CatalogEntry.
THUMBNAIL VARCHAR(254) The thumbnail image path of this CatalogEntry.
AUXDESCRIPTION1 VARCHAR(4000) Additional description for this CatalogEntry.
FULLIMAGE VARCHAR(254) The full image path of this CatalogEntry.
AUXDESCRIPTION2 VARCHAR(4000) Additional description for this CatalogEntry.
XMLDETAIL CLOB Reserved for IBM internal use.
AVAILABLE INTEGER NOT NULL Indicates the length of time to availability of this CatalogEntry. Do not use this column to indicate inventory levels.
PUBLISHED INTEGER NOT NULL Indicates whether this CatalogEntry should be displayed for the language indicated by LANGUAGE_ID: 0= CatalogEntry should not be displayed, 1= CatalogEntry should be displayed.
AVAILABILITYDATE TIMESTAMP Date this CatalogEntry becomes available.
KEYWORD VARCHAR(254) A keyword used for searching.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031208790 CATENTRY_ID+LANGUAGE_ID Primary Key
I0000304 LANGUAGE_ID+CATENTRY_ID+NAME+PUBLISHED Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_196 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_197 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback