CATALOGDSC

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

Column Descriptions:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLThe internal reference number relating this language specific information to a catalog.
LANGUAGE_IDINTEGER NOT NULLThe identifier of the language. For a list of language identifiers, see the LANGUAGE table.
NAMEVARCHAR (254) NOT NULLThe language-dependent name of this catalog.
SHORTDESCRIPTIONVARCHAR (254)A short description of this catalog.
LONGDESCRIPTIONVARCHAR (4000)A long description of this catalog.
THUMBNAILVARCHAR (254)The thumbnail image path of this catalog.
FULLIMAGEVARCHAR (254)The image path of this catalog.
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>LANGUAGE_ID+CATALOG_IDPrimary Key
I0000512CATALOG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_184LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_185CATALOG_IDCATALOGCATALOG_IDCascade