Database Table: CATENTDESC

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.
Indexes:
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
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable