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 IBM internal use. |
RANK | DOUBLE | Reserved for IBM 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 | 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: