# Refiner schema ERD

Table and field reference for the Fivetran Refiner connector.

## Table & Field Reference

### nps_report

| Column | Type | Keys |
| --- | --- | --- |
| date_range_end | Instant | PK |
| date_range_start | Instant | PK |
| count | Unknown |  |
| detractors | Unknown |  |
| nps | Unknown |  |
| passives | Unknown |  |
| promoters | Unknown |  |

### rating_report

| Column | Type | Keys |
| --- | --- | --- |
| date_range_end | Instant | PK |
| date_range_start | Instant | PK |
| average | Unknown |  |
| count | Unknown |  |
| data | Json |  |
| sum | Unknown |  |

### csat_report

| Column | Type | Keys |
| --- | --- | --- |
| date_range_end | Instant | PK |
| date_range_start | Instant | PK |
| count | Unknown |  |
| csat | Unknown |  |
| data_neutral | Unknown |  |
| data_satisfied | Unknown |  |
| data_unsatisfied | Unknown |  |
| data_very_satisfied | Unknown |  |
| data_very_unsatisfied | Unknown |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived_at | Instant |  |
| channels | Json |  |
| created_at | Instant |  |
| first_form_view_at | Instant |  |
| folder | Unknown |  |
| last_form_view_at | Instant |  |
| name | Unknown |  |
| published_at | Instant |  |
| updated_at | Instant |  |

### distribution_report

| Column | Type | Keys |
| --- | --- | --- |
| date_range_end | Instant | PK |
| date_range_start | Instant | PK |
| data | Json |  |
| datapoints | Unknown |  |
| responses | Unknown |  |

### response_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| response_id | Unknown | PK, FK |

### response_segment

| Column | Type | Keys |
| --- | --- | --- |
| response_id | Unknown | PK, FK |
| segment | Unknown | PK, FK |

### response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| form_id | Unknown | FK |
| completed_at | Instant |  |
| dismissed_at | Instant |  |
| first_data_reception_at | Instant |  |
| first_shown_at | Instant |  |
| last_data_reception_at | Instant |  |
| last_shown_at | Instant |  |
| received_at | Instant |  |
| show_counter | Unknown |  |
| data_** |  |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_manual | Unknown |  |
| name | Unknown |  |

### contact_segment

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_display_name | Unknown |  |
| account_domain | Unknown |  |
| account_first_seen_at | Instant |  |
| account_id | Unknown |  |
| account_last_seen_at | Instant |  |
| account_remote_id | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| first_seen_at | Instant |  |
| last_form_submission_at | Unknown |  |
| last_seen_at | Instant |  |
| last_tracking_event_at | Instant |  |
| remote_id | Unknown |  |
| account_attributes_** |  |  |
| attributes_** |  |  |

### count_report

| Column | Type | Keys |
| --- | --- | --- |
| date_range_end | Instant | PK |
| date_range_start | Instant | PK |
| responses | Unknown |  |
| views | Unknown |  |

## Relationships

- response_tag(response_id) → response(id)
- response_segment(segment) → segment(id)
- response_segment(response_id) → response(id)
- response(form_id) → form(id)
- response(contact_id) → contact(id)
- contact_segment(id) → segment(id)
- contact_segment(contact_id) → contact(id)