# Algolia schema ERD

Table and field reference for the Fivetran Algolia connector.

## Table & Field Reference

### country

| Column | Type | Keys |
| --- | --- | --- |
| country | Unknown | PK |
| index_name | Unknown | PK |
| start_date | Unknown | PK |
| count | Unknown |  |
| end_date | Unknown |  |

### settings

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| index_name | Unknown | FK |
| alternatives_as_exact | Unknown |  |
| attribute_for_distinct | Unknown |  |
| attributes_for_faceting | Unknown |  |
| attributes_to_highlight | Unknown |  |
| attributes_to_index | Unknown |  |
| attributes_to_retrieve | Unknown |  |
| attributes_to_snippet | Unknown |  |
| exact_on_single_word_query | Unknown |  |
| highlight_post_tag | Unknown |  |
| highlight_pre_tag | Unknown |  |
| hits_per_page | Unknown |  |
| max_values_per_facet | Unknown |  |
| min_word_size_for_1_typo | Unknown |  |
| min_word_size_for_2_typo | Unknown |  |
| numeric_attributes_to_index | Unknown |  |
| optional_words | Unknown |  |
| pagination_limited_to | Unknown |  |
| query_type | Unknown |  |
| ranking | Unknown |  |
| remove_words_if_no_results | Unknown |  |
| separators_to_index | Unknown |  |
| snippet_ellipsis_text | Unknown |  |
| unretrievable_attributes | Unknown |  |
| version | Unknown |  |

### click_through_rate

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| index_name | Unknown | PK |
| click_count | Unknown |  |
| rate | Unknown |  |
| tracked_search_count | Unknown |  |

### search_no_result_rate

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| index_name | Unknown | PK |
| count | Unknown |  |
| no_result_count | Unknown |  |
| rate | Unknown |  |

### average_click_position

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| index_name | Unknown | PK |
| average | Unknown |  |
| click_count | Unknown |  |

### click_position

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| click_count | Unknown |  |
| end_date | Unknown |  |
| index_name | Unknown |  |
| position | Json |  |
| start_date | Unknown |  |

### index_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| index_name | Unknown | FK |

### rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| rule_id | Unknown | PK, FK |
| anchoring | Unknown |  |
| pattern | Unknown |  |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| index_detail_id | Unknown | FK |
| index_name | Unknown | FK |

### index_replica

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| index_name | Unknown | PK, FK |
| replica | Unknown |  |

### index

| Column | Type | Keys |
| --- | --- | --- |
| index_name | Unknown | PK |
| primary_index | Unknown | FK |
| created_at | Unknown |  |
| data_size | Unknown |  |
| entries | Unknown |  |
| file_size | Unknown |  |
| last_build_time_s | Unknown |  |
| number_of_pending_tasks | Unknown |  |
| pending_task | Unknown |  |
| updated_at | Unknown |  |
| virtual | Unknown |  |

### top_filter

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| attribute | Unknown |  |
| count | Unknown |  |
| end_date | Unknown |  |
| index_name | Unknown |  |
| operator | Unknown |  |
| start_date | Unknown |  |
| value | Unknown |  |

### search_no_click_rate

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| index_name | Unknown | PK |
| count | Unknown |  |
| no_click_count | Unknown |  |
| rate | Unknown |  |

### search_count

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| count | Unknown |  |
| date | Unknown |  |
| index_name | Unknown |  |

### filter

| Column | Type | Keys |
| --- | --- | --- |
| attribute | Unknown | PK |
| index_name | Unknown | PK |
| start_date | Unknown | PK |
| count | Unknown |  |
| end_date | Unknown |  |

### hit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| click_count | Unknown |  |
| conversion_count | Unknown |  |
| count | Unknown |  |
| end_date | Unknown |  |
| hit | Unknown |  |
| index_name | Unknown |  |
| start_date | Unknown |  |
| tracked_hit_count | Unknown |  |

### search

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| click_count | Unknown |  |
| conversion_count | Unknown |  |
| count | Unknown |  |
| end_date | Unknown |  |
| index_name | Unknown |  |
| nb_hits | Unknown |  |
| search | Unknown |  |
| start_date | Unknown |  |
| tracked_search_count | Unknown |  |

### user_count

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| index_name | Unknown | PK |
| count | Unknown |  |

### search_no_click

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| count | Unknown |  |
| end_date | Unknown |  |
| index_name | Unknown |  |
| nb_hits | Unknown |  |
| search | Unknown |  |
| start_date | Unknown |  |

### search_no_result

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| count | Unknown |  |
| end_date | Unknown |  |
| index_name | Unknown |  |
| search | Unknown |  |
| start_date | Unknown |  |
| with_filter_count | Unknown |  |

### conversion_rate

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| index_name | Unknown | PK |
| conversion_count | Unknown |  |
| rate | Unknown |  |
| tracked_search_count | Unknown |  |

## Relationships

- settings(index_name) → index(index_name)
- index_detail(index_name) → index(index_name)
- rule_condition(rule_id) → rule(id)
- rule(index_name) → index(index_name)
- rule(index_detail_id) → index_detail(id)
- index_replica(index_name) → index(index_name)
- index(primary_index) → index(index_name)