This table relates catalog groups (or categories)
to child catalog group (or child categories). You can use this
table to dictate the navigational flow from catalog groups to child
catalog groups. Each relationship is also qualified by a Catalog
ID.
Column Descriptions:
Name | Type | Description |
CATGROUP_ID_PARENT | BIGINT NOT NULL | The source catalog group of this
relationship. |
CATGROUP_ID_CHILD | BIGINT NOT NULL | The target catalog group of this
relationship. |
CATALOG_ID | BIGINT NOT NULL | The catalog in which this relationship is
found. |
RULE | VARCHAR (254) | Reserved for HCL internal use. |
SEQUENCE | DOUBLE NOT NULL DEFAULT 0 | The sequence number that determines the display
order of the contents of the catalog group. |
LASTUPDATE | TIMESTAMP | Indicates the last time that this relationship
was updated. |
CATALOG_ID_LINK | BIGINT | Reserved for HCL internal use. |
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_CHILD+CATGROUP_ID_PARENT+CATALOG_ID | Primary Key |
I0000294 | CATALOG_ID_LINK | Non-Unique Index |
I0000527 | CATALOG_ID | Non-Unique Index |
I0000528 | CATGROUP_ID_PARENT | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_224 | CATGROUP_ID_CHILD | CATGROUP | CATGROUP_ID | Cascade |
F_225 | CATGROUP_ID_PARENT | CATGROUP | CATGROUP_ID | Cascade |
F_226 | CATALOG_ID | CATALOG | CATALOG_ID | Cascade |
F_983 | CATALOG_ID_LINK | CATALOG | CATALOG_ID | Cascade |