ICROOTCAT

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
ROOTCATEGORYIDBIGINT NOT NULLReserved for HCL internal use.
CATGROUP_IDBIGINTReserved for HCL internal use.
PFPASYNCINTEGER NOT NULL DEFAULT 0Reserved for HCL internal use.
PFREQINTEGER NOT NULL DEFAULT 1Reserved for HCL internal use.
TABLENAMEVARCHAR (64) NOT NULLReserved for HCL internal use.
LASTMODIFIEDTIMESTAMPReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ROOTCATEGORYIDPrimary Key
I0000128ROOTCATEGORYID+PFREQUnique Index
I0000129LASTMODIFIEDNon-Unique Index
I0000582CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_376CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_948ROOTCATEGORYIDCATGROUPCATGROUP_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_372ROOTCATEGORYIDICMETAPHORCATEGORYIDCascade