This table holds language-dependent information related to a catalog entry.
Column Descriptions
Column Name
| Column Type
| Description |
CATENTRY_ID
| BIGINT NOT NULL
| The internal reference number that indicates to which catalog entry 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 catalog entry.
|
SHORTDESCRIPTION
| VARCHAR(254)
| A short description of this catalog entry.
|
LONGDESCRIPTION
| CLOB
| A long description of this catalog entry.
|
THUMBNAIL
| VARCHAR(254)
| The thumbnail image path of this catalog entry.
|
AUXDESCRIPTION1
| VARCHAR(4000)
| Additional description for this catalog entry.
|
FULLIMAGE
| VARCHAR(254)
| The full image path of this catalog entry.
|
AUXDESCRIPTION2
| VARCHAR(4000)
| Additional description for this catalog entry.
|
XMLDETAIL
| CLOB
| Reserved for IBM internal use.
|
AVAILABLE
| INTEGER NOT NULL
| Indicates the length of time to availability of this catalog entry. Do not use this column to indicate inventory levels.
|
PUBLISHED
| INTEGER NOT NULL
| Indicates whether this catalog entry should be displayed for the language indicated by LANGUAGE_ID: 0= catalog entry should not be displayed, 1= catalog entry should be displayed.
|
AVAILABILITYDATE
| TIMESTAMP
| Date this catalog entry becomes available.
|
KEYWORD
| VARCHAR(254)
| A keyword used for searching.
|
OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|