This table hold the information related to a
catalog group. A catalog group is similar to a generic category
that can contain both other catalog groups and also catalog
entries.
Column Descriptions:
| Name | Type | Description |
| CATGROUP_ID | BIGINT NOT NULL | The internal reference number of the catalog
group. |
| MEMBER_ID | BIGINT NOT NULL | The internal reference number that identifies the
owner of the catalog group. Along with IDENTIFIER, these columns
are a unique index. |
| IDENTIFIER | VARCHAR (254) | The external name that is used to identify the
catalog group. Along with MEMBER_ID, these columns are a unique
index. |
| MARKFORDELETE | INTEGER NOT NULL | Indicates if this catalog group has been marked
for deletion:
0 = No.
1 = Yes. |
| LASTUPDATE | TIMESTAMP | Indicates the last time that this catalog group
was updated. |
| FIELD1 | VARCHAR (254) | Customizable. |
| FIELD2 | VARCHAR (254) | Customizable. |
| OID | VARCHAR (64) | Reserved for HCL internal use. |
| RANK | DOUBLE | Reserved for HCL internal use. |
| 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. |
| DYNAMIC | INTEGER DEFAULT 0 | This column indicates the type of dynamic
category.
0 = Non-Dynamic Category
1 = Rule Based Category |
| 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 |
| <SYSTEM-GENERATED> | CATGROUP_ID | Primary Key |
| I0000067 | IDENTIFIER+MEMBER_ID | Unique Index |
| I0000376 | RANK | Non-Unique Index |
| I0000525 | MEMBER_ID | Non-Unique Index |
| IPF00001 | UP_IDENTIFIER | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_216 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Referenced By Child Tables: