This table hold the information related to a CatalogGroup. A CatalogGroup is similar to a generic Category that can contain both other CatalogGroups and also CatalogEntries.
Column Description(s):
Column Name | Column Type | Description |
CATGROUP_ID |
BIGINT NOT NULL |
The internal reference number of the CatalogGroup. |
MEMBER_ID |
BIGINT NOT NULL |
The internal reference number that identifies the owner of the CatalogGroup. Along with IDENTIFIER, these columns are a unique index. |
IDENTIFIER |
VARCHAR(254) |
The external name that is used to identify the CatalogGroup. Along with MEMBER_ID, these columns are a unique index. |
MARKFORDELETE |
INTEGER NOT NULL |
Indicates if this CatalogGroup has been marked for deletion:
0 = No.
1 = Yes. |
LASTUPDATE |
TIMESTAMP |
Indicates the last time that this CatalogGroup was updated. |
FIELD1 |
VARCHAR(254) |
Customizable. |
FIELD2 |
VARCHAR(254) |
Customizable. |
OID |
VARCHAR(64) |
Reserved for IBM internal use. |
RANK |
DOUBLE |
Relative search ranking. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000067 |
IDENTIFIER+MEMBER_ID |
Unique Index |
SQL050212031209780 |
CATGROUP_ID |
Primary Key |
I0000376 |
RANK |
Non-Unique Index |
I0000525 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_216 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_210 |
CATGROUP_ID |
CATGPCALCD |
CATGROUP_ID |
Cascade |
F_213 |
CATGROUP_ID |
CATGPENREL |
CATGROUP_ID |
Cascade |
F_217 |
CATGROUP_ID |
CATGRPATTR |
CATGROUP_ID |
Cascade |
F_219 |
CATGROUP_ID |
CATGRPDESC |
CATGROUP_ID |
Cascade |
F_222 |
CATGROUP_ID |
CATGRPPS |
CATGROUP_ID |
Cascade |
F_224 |
CATGROUP_ID_CHILD |
CATGRPREL |
CATGROUP_ID |
Cascade |
F_225 |
CATGROUP_ID_PARENT |
CATGRPREL |
CATGROUP_ID |
Cascade |
F_229 |
CATGROUP_ID |
CATGRPTPC |
CATGROUP_ID |
Cascade |
F_231 |
CATGROUP_ID |
CATTOGRP |
CATGROUP_ID |
Cascade |
F_977 |
CATGROUP_ID |
CPPMNCAT |
CATGROUP_ID |
Cascade |
F_298 |
CATGROUP_ID |
DISPCGPREL |
CATGROUP_ID |
Cascade |
F_361 |
CATGROUP_ID |
ICEXPLFEAT |
CATGROUP_ID |
Cascade |
F_948 |
ROOTCATEGORYID |
ICROOTCAT |
CATGROUP_ID |
Cascade |
F_376 |
CATGROUP_ID |
ICROOTCAT |
CATGROUP_ID |
Cascade |
F_435 |
CATGROUP_ID_TO |
MASSOCGPGP |
CATGROUP_ID |
Cascade |
F_436 |
CATGROUP_ID_FROM |
MASSOCGPGP |
CATGROUP_ID |
Cascade |
F_783 |
CATGROUP_ID |
STORECGRP |
CATGROUP_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.