properties

This table represents the content of the properties index. The properties index represent all the properties you would like to make searchable and completable (for example, the search for an author in a books store). By filling this table, the system will stop using the standard properties index and use the content of this table instead.

Field name

Type

Mode

Description

Field name

Type

Mode

Description

id

STRING

REQUIRED

a number id (as a string) must be different for each entry (not used in logic)

language

STRING

REQUIRED

a language code (fr, de, en, it, ...)

textsuggest

STRING

NULLABLE

candidate for textual suggestion in search (optional)

label

STRING

REQUIRED

a label value of this property (name)

name

STRING

REQUIRED

the name of the property

popularity

FLOAT

REQUIRED

float value used for ranking (0 is lowest value)

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