CATGPENREL

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:

NameTypeDescription
CATGROUP_IDBIGINT NOT NULLThe source catalog group of this relationship.
CATALOG_IDBIGINT NOT NULLThe catalog inside of which this relationship is found.
CATENTRY_IDBIGINT NOT NULLThe target catalog entry of this relationship.
RULEVARCHAR (254)Reserved for HCL internal use.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence number that determines the display order of the contents of the catalog group.
LASTUPDATETIMESTAMPIndicates the last time that this relationship was updated.
FIELD1VARCHAR (254)Customizable.
FIELD2INTEGERCustomizable.
FIELD3DECIMAL (20,5)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATGROUP_ID+CATENTRY_ID+CATALOG_IDPrimary Key
I0000523CATALOG_IDNon-Unique Index
I0000524CATENTRY_IDNon-Unique Index
I0001546CATGROUP_ID+CATALOG_ID+CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_213CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_214CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_215CATALOG_IDCATALOGCATALOG_IDCascade