Database Table: ICROOTCAT

When a search space is created, an entry is made in this table.

Column Name Column Type Column Description
CATGROUP_ID BIGINT
NULL
CatalogGroup that the search space is created for. Foreign key to the CATGROUP table.
LASTMODIFIED TIMESTAMP
NULL
Reserved for IBM internal use.
PFPASYNC INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
PFREQ INTEGER
NOT NULL, DEFAULT 1
Indicates if exploration space is required or not. Matches EXPLREQ in ICMETAPHOR.
ROOTCATEGORYID BIGINT
NOT NULL
The internal reference number of the CATGROUP. Currently is same as CATGROUP_ID.
TABLENAME VARCHAR (64)
NOT NULL
Name of the database view for this search space. For example, ICVnnnn_ where nnnn is the CATGROUP_ID.
Indexes:
Index Name Indexed Column Names Index Type
I0000128 ROOTCATEGORYID, PFREQ Unique Index
I0000129 LASTMODIFIED Non-Unique Index
SQL030416034944070 ROOTCATEGORYID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_376 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_948 ROOTCATEGORYID CATGROUP CATGROUP_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_372 ROOTCATEGORYID ICMETAPHOR CATEGORYID Cascade