autocomplete
- Sylvain Paillard
This table represents the content of the autocomplete index. The autocomplete index represent the textual suggestions appearing while people are searching on your web-site before they press enter. By filling this table, the system will stop using the standard autocomplete 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 | REQUIRED | candidate for textual suggestion in search |
extrasearch | STRING | NULLABLE | alternative similar writings (optional) |
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 |