# SISTRIX schema ERD

Table and field reference for the Fivetran SISTRIX connector.

## Table & Field Reference

### domain_visibility_index

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| device | Unknown | PK |
| domain | Unknown | PK, FK |
| value | Unknown |  |

### keyword_domain_seo

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| competition | Unknown |  |
| date | Unknown |  |
| domain | Unknown |  |
| info | Unknown |  |
| keyword | Unknown |  |
| position | Unknown |  |
| traffic | Unknown |  |
| url | Unknown |  |

### domain_ranking_distribution

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| device | Unknown | PK |
| domain | String | PK |
| page_01 | Unknown |  |
| page_02 | Unknown |  |
| page_03 | Unknown |  |
| page_04 | Unknown |  |
| page_05 | Unknown |  |
| page_06 | Unknown |  |
| page_07 | Unknown |  |
| page_08 | Unknown |  |
| page_09 | Unknown |  |
| page_10 | Unknown |  |

### keyword_domain_sem

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| competition | Unknown |  |
| date | Unknown |  |
| domain | Unknown |  |
| info | Unknown |  |
| keyword | Unknown |  |
| position | Unknown |  |
| traffic | Unknown |  |
| url | Unknown |  |

### domain_kw_count_sem_info

| Column | Type | Keys |
| --- | --- | --- |
| device | Unknown | PK |
| index | Unknown | PK |
| domain | Unknown | PK, FK |
| country | Unknown |  |

### domain_kw_count_sem

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| device | Unknown | PK |
| domain | Unknown | PK, FK |
| value | Unknown |  |

### domain_visibility_index_overview

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| days | Unknown |  |
| device | Unknown |  |
| domain | Unknown |  |

### domain_visibility_index_overview_min

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| device | Unknown | PK |
| domain | String | PK, FK |
| value | Unknown |  |

### domain_visibility_index_overview_max

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| device | Unknown | PK |
| domain | String | PK, FK |
| value | Unknown |  |

### domain_kw_count_seo

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| device | Unknown | PK |
| domain | Unknown | PK, FK |
| value | Unknown |  |

### domain_kw_count_seo_info

| Column | Type | Keys |
| --- | --- | --- |
| device | Unknown | PK |
| index | Unknown | PK |
| domain | Unknown | PK, FK |
| country | Unknown |  |

## Relationships

- domain_visibility_index(domain) → domain_visibility_index_overview(domain)
- domain_kw_count_sem_info(domain) → domain_kw_count_sem(domain)
- domain_kw_count_sem(domain) → keyword_domain_sem(domain)
- domain_visibility_index_overview_min(domain) → domain_visibility_index_overview(domain)
- domain_visibility_index_overview_max(domain) → domain_visibility_index_overview(domain)
- domain_kw_count_seo(domain) → keyword_domain_seo(domain)
- domain_kw_count_seo_info(domain) → domain_kw_count_seo(domain)