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 |
---|---|---|---|
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 |