CATENTDESCOVR

Store information about catalog entry description override. When a field of a record in this table contains the null value, this means that there is no override for this field and the product displayed on the store front should use the field from the asset store.

Column Descriptions:

Name	Type	Description
CATENTDESCOVR_ID	BIGINT NOT NULL	The internal reference number of the catalog entry description override.
CATENTRY_ID	BIGINT NOT NULL	The internal reference number that indicates to which catalog entry this override information relates.
LANGUAGE_ID	INTEGER NOT NULL	The identifier of the language. For a list of language components, see the LANGUAGE table.
CATOVRGRP_ID	BIGINT NOT NULL	The internal reference number of the catalog override group this description belongs.
NAME	CHAR (128)	The language-dependent override name of this catalog entry.
SHORTDESCRIPTION	VARCHAR (254)	The short description override of this catalog entry.
LONGDESCRIPTION	CLOB (1000000)	The long description override of this catalog entry.
THUMBNAIL	VARCHAR (254)	The thumbnail image path override of this catalog entry.
AUXDESCRIPTION1	VARCHAR (4000)	Additional description override for this catalog entry.
FULLIMAGE	VARCHAR (254)	The full image path override of this catalog entry.
AUXDESCRIPTION2	VARCHAR (4000)	Additional description override for this catalog entry.
PUBLISHED	INTEGER	The PUBLISHED flag override used for the catalog entry. Indicates 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.
KEYWORD	VARCHAR (254)	A keyword override used for searching.
FIELD1	INTEGER	Customizable field
FIELD2	VARCHAR (254)	Customizable field
FIELD3	VARCHAR (254)	Customizable field
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.
UP_NAME	VARCHAR (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.

Indexes:

Name	Column Names	Type
P_0006	CATENTDESCOVR_ID	Primary Key
I0001446	CATENTRY_ID+LANGUAGE_ID+CATOVRGRP_ID	Unique Index
I0001447	LANGUAGE_ID	Non-Unique Index
I0001448	CATOVRGRP_ID	Non-Unique Index
I0001449	CATENTRY_ID+CATOVRGRP_ID	Non-Unique Index
IPF00031	UP_NAME	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3721	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_3722	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_3723	CATOVRGRP_ID	CATOVRGRP	CATOVRGRP_ID	Cascade