CATENTDESC

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


Column Descriptions:

Name 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 (1000000) 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 (1000000) 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.
UP_NAME CHAR (128) The equivalent value of the NAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> CATENTRY_ID+LANGUAGE_ID Primary Key
I0000304 LANGUAGE_ID+CATENTRY_ID+NAME+PUBLISHED Non-Unique Index
I0001196 NAME+LANGUAGE_ID+PUBLISHED Non-Unique Index
I0001248 CATENTRY_ID Non-Unique Index
IPF00002 UP_NAME Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_196 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_197 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference
Catalog entry data model