This table holds language-dependent information related to a CatalogEntry.
Column Name | Column Type | Column Description |
---|---|---|
AUXDESCRIPTION1 | VARCHAR (4000) NULL |
Additional description for this CatalogEntry. |
AUXDESCRIPTION2 | VARCHAR (4000) NULL |
Additional description for this CatalogEntry. |
AVAILABILITYDATE | TIMESTAMP NULL |
Date this CatalogEntry becomes available. |
AVAILABLE | INTEGER NOT NULL |
Indicates the length of time to availability of this CatalogEntry. Do not use this column to indicate inventory levels. |
CATENTRY_ID | BIGINT NOT NULL |
The internal reference number that indicates the CatalogEntry that this language specific information relates to. |
FULLIMAGE | VARCHAR (254) NULL |
The full image path of this CatalogEntry. |
KEYWORD | VARCHAR (254) NULL |
A keyword used for searching. |
LANGUAGE_ID | INTEGER NOT NULL |
The Identifier of the language. For a list of language components, see the LANGUAGE table. |
LONGDESCRIPTION | VARCHAR (4000) NULL |
A long description of this CatalogEntry. |
NAME | CHARACTER (128) NULL |
The language-dependent name of this CatalogEntry. |
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. |
SHORTDESCRIPTION | VARCHAR (254) NULL |
A short description of this CatalogEntry. |
THUMBNAIL | VARCHAR (254) NULL |
The thumbnail image path of this CatalogEntry. |
XMLDETAIL | LONG VARCHAR NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000304 | LANGUAGE_ID, PUBLISHED, CATENTRY_ID, SHORTDESCRIPTION, NAME | Non-Unique Index |
SQL030416034859480 | CATENTRY_ID, LANGUAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_196 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_197 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|