This table holds information related to the catalog
override group. The catalog override group is a container to group
different catalog override.
Column Descriptions:
Name | Type | Description |
CATOVRGRP_ID | BIGINT NOT NULL | The internal reference number of the override
group. |
MEMBER_ID | BIGINT NOT NULL | The reference number that identifies the owner of
the override group. Along with the IDENTIFIER, these columns are a
unique index. |
IDENTIFIER | VARCHAR (254) NOT NULL | The identifier of the override group. |
STOREENT_ID | INTEGER NOT NULL | The reference number of the store entity to which
this override group belongs. |
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_IDENTIFIER | VARCHAR (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:
Name | Column Names | Type |
P_0007 | CATOVRGRP_ID | Primary Key |
I0001450 | IDENTIFIER+MEMBER_ID | Unique Index |
I0001451 | STOREENT_ID | Non-Unique Index |
IPF00032 | UP_IDENTIFIER | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3724 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_3723 | CATOVRGRP_ID | CATENTDESCOVR | CATOVRGRP_ID | Cascade |
F_3726 | CATOVRGRP_ID | STORECATOVRGRP | CATOVRGRP_ID | Cascade |