Develop > Presentation layer > Customize marketing > Work with Product Advisor > Create a Product Advisor search space manually for the separate search space
Product Advisor search space database tables for the separate search space
The tables and views in this section are used by Product Advisor for separate search spaces.
- ICT category_id
- This table contains catalog entries for the search space. This table is created and populated during search space creation.
- ICTDESC category_id
- This table contains language-dependent attribute information for catalog entries of the search space. This table is created and populated during search space creation.
- ICV category_id_NULL
- This is a view of the combined data in the ICT category_id, ICTDESC category_id and ICTPRICES tables. Since the ICTPRICES table is populated with data from the OFFERPRICE table for the "S" type of trading position container. Product Advisor searches are performed against the view. Every catalog entry that to be accessible through a Product Advisor search should have rows in this view for each store_id, currency, and language_id that you expect customers to use.
- ICCNCPTLNK
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICCONSTRNT
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICCONSTVAL
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICDATAREG
- This table is a registry used by Product Advisor. It is reserved for IBM use. This table is created and populated during WCS instance creation.
- ICDEWIDREG
- This table is a registry used by Product Advisor. It is reserved for IBM use. This table is created and populated during WCS instance creation.
- ICEXPLDESC
- This table contains language-dependent information about the features in the ICEXPLFEAT table. The NAME column must correspond to column names in CATENTRY, CATENTDESC, LISTPRICE TABLES or values in the NAME column of ATTRIBUTE and CATENTATTR tables. This table is created during WCS instance creation, and populated during search space creation.
- ICEXPLFEAT
- This table identifies which attributes (features) exist in the search space as well as information about the attributes. This table is created during WCS instance creation, and populated during search space creation.
- ICFEATPROP
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICKNOWDESC
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICKNOWLEDG
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICMERDESC
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICMERTREE
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICMETAFEAT
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICMETAPHOR
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICMETAPROP
- This table contains metaphor-related data. This table is created during WCS instance creation, and populated during metaphor creation.
- ICMETAREG
- This table is a registry used by Product Advisor. It is reserved for IBM use. This table is created during WCS instance creation, and populated during metaphor creation.
- ICMREGDESC
- This table contains metaphor-related data. It is also related to ICMETAREG, and is reserved for IBM use. This table is created during WCS instance creation, and populated during metaphor creation.
- ICROOTCAT
- This table contains the list of categories that have search spaces. You cannot create a metaphor until you have a valid entry here. The entries for ROOTCATEGORYID and CATGROUP_ID should be identical. The TABLENAME entry corresponds to the view created for the search space, minus the "null" suffix. This table is created during WCS instance creation, and populated during search space creation.
- ICTPRICES
- This table contains the prices (listprice) for each catalog entry in the search space. A catalog entry will not be found by a Product Advisor search unless a price for it exists in the currency used by the customer. This table is created during WCS instance creation, and populated during search space creation.
Related concepts
Related tasks
Create a Product Advisor search space using an XML file
Create a Product Advisor search space for the separate search space using sample utility
Create a Product Advisor search space manually for the separate search space
Create metaphors using the command utilities
Related reference
RemoveProductsFromSearchSpace URL
RemoveProductsFromAllSearchSpaces URL