Database Table: CATGRPDESC

This table hold the language-dependent information related to a CatalogGroup.

Column Name Column Type Column Description
CATGROUP_ID BIGINT
NOT NULL
The internal reference number that indicates the CatalogGroup that this language specific information relates to.
DISPLAY VARCHAR (254)
NULL
Reserved for IBM internal use.
FULLIMAGE VARCHAR (254)
NULL
The full image path of this CatalogGroup.
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 CatalogGroup.
NAME VARCHAR (254)
NOT NULL
The language-dependent name of this CatalogGroup.
NOTE LONG VARCHAR
NULL
The footnotes or extended long description for this CatalogGroup.
PUBLISHED INTEGER
NOT NULL
Indicates whether this CatalogGroup should be displayed for the language indicated by LANGUAGE_ID: 0=no, 1=yes.
SHORTDESCRIPTION VARCHAR (254)
NULL
A short description of this CatalogGroup.
THUMBNAIL VARCHAR (254)
NULL
The thumbnail image path of this CatalogGroup.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034904260 CATGROUP_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_219 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_220 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

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