product_properties_metadata

This table represents the definition of product properties to be added to the SolrIndex. By filling this table (and optionally defining the data of these properties in the other product_properties tables of the lab datset, the system will will automatically upload and create/update your product properties in the Solr Index.

Field name	Type	Mode	Description

Field name	Type	Mode	Description
name	STRING	REQUIRED	PK - the name of the property (must match the property name in the other product_..._property tables)
datatype	STRING	REQUIRED	must be one of the following: string, tfloat, date
stored	BOOLEAN	REQUIRED	If true, the actual value of the field can be retrieved by queries. (typically : true)
indexed	BOOLEAN	REQUIRED	If true, the value of the field can be used in queries to retrieve matching documents. (typically: true)
multivalued	BOOLEAN	REQUIRED	If true, indicates that a single document might contain multiple values for this field type. (must be false if field should be used for ranking, if false, only the first value provided in the product property tables will be used)
numeric_defaultvalues	NUMERIC	REPEATED	default numeric values set if no values found in products_numeric_properties (should only be set if datatype is "tfloat") - MUST BE LEFT EMPTY IF NOT A NUMERIC PARAMETER!
string_defaultvalues	STRING	REPEATED	default string values set if no values found in products_string_properties (should only be set if datatype is "string") - MUST BE LEFT EMPTY IF NOT A NON-LOCALIZED STRING PARAMETER!
localized_defaultvalues	RECORD	REPEATED	default localized string values set if no values found in products_localized_properties (should only be set if datatype is "localized string") - MUST BE LEFT EMPTY IF NOT A LOCALIZED STRING PARAMETER!
localized_defaultvalues. language_code	STRING	REQUIRED
localized_defaultvalues. language_value	STRING	REQUIRED
datetime_defaultvalues	DATETIME	REPEATED	default datetime values set if no values found in products_datetime_properties (should only be set if datatype is "date") - MUST BE LEFT EMPTY IF NOT A NON-LOCALIZED DATETIME PARAMETER!!
searchable_fields	STRING	REPEATED	list of search fields (like scorerTerms) where the text values should be indexed for search
localized	BOOLEAN	REQUIRED	is the field localized
origin	STRING	REQUIRED	please provide a unique key defining the origin system of these data, not used, but useful for debugging / monitoring
creation_tm	TIMESTAMP	REQUIRED	please provide timestampe of the initial creation of this row
last_modified_tm	TIMESTAMP	REQUIRED	please provide timestampe of the last modification of this row