CATGROUP_EXTERNAL_CONTENT_REL

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:

NameTypeDescription
CG_EXTERNAL_CONTENT_REL_IDBIGINT NOT NULLPrimary key.
CATGROUP_IDBIGINT NOT NULLThe internal reference number of the catalog group which uses the external content.
CATOVRGRP_IDBIGINT NOT NULLForeign key to CATOVRGRP. Describes the catalog override group with which content and category are associated.
LANGUAGE_IDINTEGER NOT NULLThe identifier of the language. For a list of language components, see the LANGUAGE table.
CONTENT_IDVARCHAR (64) NOT NULLThe identifier of the external content.
TYPEVARCHAR (64) NOT NULLForeign key to IDENTIFIER in EXTERNAL_CONTENT_TYPE. Describes the type of content attached to associated category.
FIELD1INTEGERCustomizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0055CG_EXTERNAL_CONTENT_REL_IDPrimary Key
I0001554 CATGROUP_ID+CONTENT_ID+CATOVRGRP_ID+LANGUAGE_IDUnique Index
I0001552CONTENT_IDNon-Unique Index
I0001553CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3787CONTENT_IDEXTERNAL_CONTENTCONTENT_IDCascade
F_3788CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_3789TYPEEXTERNAL_CONTENT_TYPEIDENTIFIERCascade