This table relates catalog groups (or categories)
to the catalog entries that are inside them. You can also use this
table to dictate the navigational flow from catalog groups to
catalog entries. Each relationship is also qualified by a Catalog
ID.
Column Descriptions:
Name | Type | Description |
CATGROUP_ID | BIGINT NOT NULL | The source catalog group of this
relationship. |
CATALOG_ID | BIGINT NOT NULL | The catalog inside of which this relationship is
found. |
CATENTRY_ID | BIGINT NOT NULL | The target catalog entry of this
relationship. |
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. |
FIELD1 | VARCHAR (254) | Customizable. |
FIELD2 | INTEGER | Customizable. |
FIELD3 | DECIMAL (20,5) | Customizable. |
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+CATENTRY_ID+CATALOG_ID | Primary Key |
I0000523 | CATALOG_ID | Non-Unique Index |
I0000524 | CATENTRY_ID | Non-Unique Index |
I0001546 | CATGROUP_ID+CATALOG_ID+CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_213 | CATGROUP_ID | CATGROUP | CATGROUP_ID | Cascade |
F_214 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_215 | CATALOG_ID | CATALOG | CATALOG_ID | Cascade |