The Insight Index tables support searching across documents and events:
- index_value holds unique indexed values.
- event_index holds the relationship between these values and events.
- document_index holds the relationships between these values and documents.
As well as the instance_uuid, index_value holds.
| property | The property that is being indexed. |
| value | The value of the property, in a normalized form (all spaces and pinctuation removed, all lower case). |
| display | The value of the property, in its original form. |
These three tables have the message retention period set to 7 days, so that the messages used to load the index are purged periodically.