CATOVRGRP

This table holds information related to the catalog override group. The catalog override group is a container to group different catalog override.

Column Descriptions:

NameTypeDescription
CATOVRGRP_IDBIGINT NOT NULLThe internal reference number of the override group.
MEMBER_IDBIGINT NOT NULLThe reference number that identifies the owner of the override group. Along with the IDENTIFIER, these columns are a unique index.
IDENTIFIERVARCHAR (254) NOT NULLThe identifier of the override group.
STOREENT_IDINTEGER NOT NULLThe reference number of the store entity to which this override group belongs.
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.
UP_IDENTIFIERVARCHAR (254)The equivalent value of the IDENTIFIER 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:

NameColumn NamesType
P_0007CATOVRGRP_IDPrimary Key
I0001450IDENTIFIER+MEMBER_IDUnique Index
I0001451STOREENT_IDNon-Unique Index
IPF00032UP_IDENTIFIERNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3724STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3723CATOVRGRP_IDCATENTDESCOVRCATOVRGRP_IDCascade
F_3726CATOVRGRP_IDSTORECATOVRGRPCATOVRGRP_IDCascade