This table holds the information about the language
and store specific relationship between the catalog group and the
external content the catalog group uses.
Column Descriptions:
Name | Type | Description |
CG_EXTERNAL_CONTENT_REL_ID | BIGINT NOT NULL | Primary key. |
CATGROUP_ID | BIGINT NOT NULL | The internal reference number of the catalog
group which uses the external content. |
CATOVRGRP_ID | BIGINT NOT NULL | Foreign key to CATOVRGRP. Describes the catalog
override group with which content and category 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 category. |
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_0055 | CG_EXTERNAL_CONTENT_REL_ID | Primary Key |
I0001554 |
CATGROUP_ID+CONTENT_ID+CATOVRGRP_ID+LANGUAGE_ID | Unique Index |
I0001552 | CONTENT_ID | Non-Unique Index |
I0001553 | CATGROUP_ID | Non-Unique Index |
Constrained By Parent Tables: