CATALOGDSC

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

Column Descriptions:

Name	Type	Description
CATALOG_ID	BIGINT NOT NULL	The internal reference number relating this language specific information to a catalog.
LANGUAGE_ID	INTEGER NOT NULL	The identifier of the language. For a list of language identifiers, see the LANGUAGE table.
NAME	VARCHAR (254) NOT NULL	The language-dependent name of this catalog.
SHORTDESCRIPTION	VARCHAR (254)	A short description of this catalog.
LONGDESCRIPTION	VARCHAR (4000)	A long description of this catalog.
THUMBNAIL	VARCHAR (254)	The thumbnail image path of this catalog.
FULLIMAGE	VARCHAR (254)	The image path of this catalog.
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>	LANGUAGE_ID+CATALOG_ID	Primary Key
I0000512	CATALOG_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_184	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_185	CATALOG_ID	CATALOG	CATALOG_ID	Cascade

Related reference
Catalog data model