CATALOG

This table holds the information related to a catalog.

Column Descriptions:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLThe internal reference number of the catalog.
MEMBER_IDBIGINT NOT NULLThe internal reference number that identifies the owner of the catalog. Along with the IDENTIFIER, these columns are a unique index.
IDENTIFIERVARCHAR (254) NOT NULLThe external identifier used to identify the catalog. Along with the MEMBER_ID, these columns are a unique index.
DESCRIPTIONVARCHAR (254)An administrative description of the catalog.
TPCLEVELINTEGERReserved for HCL internal use.
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>CATALOG_IDPrimary Key
I0000061MEMBER_ID+IDENTIFIERUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_183MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1033CATALOG_IDCATTOGRPCATALOG_ID_LINKCascade
F_141CATALOG_IDBUYSUPMAPCATALOG_IDCascade
F_185CATALOG_IDCATALOGDSCCATALOG_IDCascade
F_187CATALOG_IDCATCNTRCATALOG_IDCascade
F_215CATALOG_IDCATGPENRELCATALOG_IDCascade
F_223CATALOG_IDCATGRPPSCATALOG_IDCascade
F_226CATALOG_IDCATGRPRELCATALOG_IDCascade
F_228CATALOG_IDCATGRPTPCCATALOG_IDCascade
F_230CATALOG_IDCATTOGRPCATALOG_IDCascade
F_3662CATALOG_IDCATFILTERCATALOG_IDCascade
F_3679CATALOG_IDATTRDICTSRCHCONFMASTERCATALOG_IDCascade
F_3682CATALOG_IDCLSATTRSRCHCONFMASTERCATALOG_IDCascade
F_3714CATALOG_IDSTOREDEFCATCATALOG_IDCascade
F_3762CATALOG_IDSRCHPROPRELVCATALOG_IDCascade
F_778CATALOG_IDSTORECATCATALOG_IDCascade
F_978CATALOG_IDCPPMNCATCATALOG_IDCascade
F_983CATALOG_IDCATGRPRELCATALOG_ID_LINKCascade