This table holds the information about the language
and store specific relationship between the catalog entry and the
external content the catalog entry uses.
Column Descriptions:
| Name | Type | Description |
| CE_EXTERNAL_CONTENT_REL_ID | BIGINT NOT NULL | Primary key. |
| CATENTRY_ID | BIGINT NOT NULL | The internal reference number of the catalog
entry which uses the external content. |
| CATOVRGRP_ID | BIGINT NOT NULL | Foreign key to CATOVRGRP. Describes the catalog
override group with which content and catalog entry are
associated. |
| LANGUAGE_ID | INTEGER NOT NULL | The identifier of the language. For a list of
language components, see the LANGUAGE table. |
| CONTENT_ID | VARCHAR (64) NOT NULL | The identifier of the external content. |
| TYPE | VARCHAR (64) NOT NULL | Foreign key to IDENTIFIER in
EXTERNAL_CONTENT_TYPE. Describes the type of content attached to
associated catalog entry. |
| FIELD1 | INTEGER | Customizable. |
| FIELD2 | DECIMAL (20,5) | Customizable. |
| FIELD3 | VARCHAR (254) | Customizable. |
| 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 |
| P_0054 | CE_EXTERNAL_CONTENT_REL_ID | Primary Key |
| I0001551 |
CATENTRY_ID+CONTENT_ID+CATOVRGRP_ID+LANGUAGE_ID | Unique Index |
| I0001549 | CONTENT_ID | Non-Unique Index |
| I0001550 | CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables: