CATENTDESC

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

Column Descriptions:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe internal reference number that indicates to which catalog entry this language-specific information relates.
LANGUAGE_IDINTEGER NOT NULLThe identifier of the language. For a list of language components, see the LANGUAGE table.
NAMECHAR (128)The language-dependent name of this catalog entry.
SHORTDESCRIPTIONVARCHAR (254)A short description of this catalog entry.
LONGDESCRIPTIONCLOB (1000000)A long description of this catalog entry.
THUMBNAILVARCHAR (254)The thumbnail image path of this catalog entry.
AUXDESCRIPTION1VARCHAR (4000)Additional description for this catalog entry.
FULLIMAGEVARCHAR (254)The full image path of this catalog entry.
AUXDESCRIPTION2VARCHAR (4000)Additional description for this catalog entry.
XMLDETAILCLOB (1000000)Reserved for HCL internal use.
AVAILABLEINTEGER NOT NULLIndicates the length of time to availability of this catalog entry. Do not use this column to indicate inventory levels.
PUBLISHEDINTEGER NOT NULLIndicates 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
AVAILABILITYDATETIMESTAMPDate this catalog entry becomes available.
KEYWORDVARCHAR (254)A keyword used for searching.
UP_NAMECHAR (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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATENTRY_ID+LANGUAGE_IDPrimary Key
I0000304LANGUAGE_ID+CATENTRY_ID+NAME+PUBLISHEDNon-Unique Index
I0001196NAME+LANGUAGE_ID+PUBLISHEDNon-Unique Index
I0001248CATENTRY_IDNon-Unique Index
IPF00002UP_NAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_196CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_197LANGUAGE_IDLANGUAGELANGUAGE_IDCascade