Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ICROOTCAT
This table is deprecated and is provided for backward compatibility only. When a search space is created, an entry is made in this table.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000128 ROOTCATEGORYID+PFREQ Unique Index SQL100520030344210 ROOTCATEGORYID Primary Key I0000129 LASTMODIFIED Non-Unique Index I0000582 CATGROUP_ID Non-Unique Index
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 CATEGORYID ICMETAPHOR ROOTCATEGORYID Cascade
Related reference
_vcc_freeselect_bottom_