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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000128 | ROOTCATEGORYID, PFREQ | Unique Index |
I0000129 | LASTMODIFIED | Non-Unique Index |
SQL030416034944070 | ROOTCATEGORYID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_372 | ROOTCATEGORYID | ICMETAPHOR | CATEGORYID | Cascade |