WebSphere Commerce database table: ICROOTCAT

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


Column Description(s):
Column NameColumn TypeDescription
ROOTCATEGORYID BIGINT NOT NULL The internal reference number of the CATGROUP. Currently, it is the same as CATGROUP_ID.
CATGROUP_ID BIGINT CatalogGroup that the search space is created for. Foreign key to the CATGROUP table.
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.
TABLENAME VARCHAR(64) NOT NULL Name of the database view for this search space. For example, ICVnnnn_ where nnnn is the CATGROUP_ID.
LASTMODIFIED TIMESTAMP Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000128 ROOTCATEGORYID+PFREQ Unique Index
SQL050212031232750 ROOTCATEGORYID Primary Key
I0000129 LASTMODIFIED Non-Unique Index
I0000582 CATGROUP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_376 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_948 ROOTCATEGORYID CATGROUP CATGROUP_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_372 CATEGORYID ICMETAPHOR ROOTCATEGORYID Cascade

Feedback