This table holds language-dependent information related to a CatalogEntry.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index Type |
SQL050212031208790 |
CATENTRY_ID+LANGUAGE_ID |
Primary Key |
I0000304 |
LANGUAGE_ID+CATENTRY_ID+NAME+PUBLISHED |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_196 |
CATENTRY_ID |
CATENTRY |
CATENTRY_ID |
Cascade |
F_197 |
LANGUAGE_ID |
LANGUAGE |
LANGUAGE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.