This table is used to 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. No extensive support for the override
published flag. Support with
limitations. |
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 |