# Retently schema ERD

Table and field reference for the Fivetran Retently connector.

## Table & Field Reference

### latest_score

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| detractors | Unknown |  |
| detractors_count | Unknown |  |
| metrics_type | Unknown |  |
| passives | Unknown |  |
| passives_count | Unknown |  |
| promoters | Unknown |  |
| promoters_count | Unknown |  |
| score | Unknown |  |
| score_sum | Unknown |  |
| total_responses | Unknown |  |

### customer_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | Unknown | PK |
| customer_id | Unknown | PK, FK |

### customer_property

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_id | Unknown | PK, FK |
| label | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| created_date | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| channel | Unknown |  |
| metric | Unknown |  |
| name | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| template_id | Unknown | FK |
| channel | Unknown |  |
| is_active | Unknown |  |
| metric | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### outbox_additional_recipient

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_id | Unknown | PK, FK |
| mandrill_message_id | Unknown | FK |
| email | Unknown |  |
| type | Unknown |  |

### outbox_customer_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | Unknown | PK |
| outbox_customer_id | Unknown | PK, FK |

### outbox

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| campaign_id | Unknown | FK |
| company_id | Unknown | FK |
| survey_template_id | Unknown | FK |
| channel | Unknown |  |
| detailed_status_has_feedback | Unknown |  |
| detailed_status_is_bounced | Unknown |  |
| detailed_status_is_opened | Unknown |  |
| detailed_status_is_opted_out | Unknown |  |
| detailed_status_is_responded | Unknown |  |
| detailed_status_opened_date | Unknown |  |
| detailed_status_responded_date | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| mandrill_message_id | Unknown |  |
| person_tags | Json |  |
| sent_by | Unknown |  |
| sent_date | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| template_id | Unknown |  |
| custom_** |  |  |

### report_question_stats

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| report_campaign_id | Unknown | PK, FK |
| is_on_main | Unknown |  |
| is_starred | Unknown |  |
| metrics_type | Unknown |  |
| position | Unknown |  |
| stats_first_day | Unknown |  |
| stats_first_detractors | Unknown |  |
| stats_first_opened | Unknown |  |
| stats_first_passives | Unknown |  |
| stats_first_promoters | Unknown |  |
| stats_first_responded | Unknown |  |
| stats_first_score | Unknown |  |
| stats_first_score_sum | Unknown |  |
| stats_first_skipped | Unknown |  |
| stats_first_total | Unknown |  |
| stats_last_day | Unknown |  |
| stats_last_detractors | Unknown |  |
| stats_last_opened | Unknown |  |
| stats_last_passives | Unknown |  |
| stats_last_promoters | Unknown |  |
| stats_last_responded | Unknown |  |
| stats_last_score | Unknown |  |
| stats_last_score_sum | Unknown |  |
| stats_last_skipped | Unknown |  |
| stats_last_total | Unknown |  |
| title | Unknown |  |

### report_trend

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_campaign_id | Unknown | PK, FK |
| day | Unknown |  |
| detractor | Unknown |  |
| passive | Unknown |  |
| promoter | Unknown |  |
| score | Unknown |  |
| total | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| delivery_stats_id | Unknown |  |
| delivery_stats_is_bounced | Unknown |  |
| delivery_stats_opened | Unknown |  |
| delivery_stats_opted_out | Unknown |  |
| delivery_stats_responded | Unknown |  |
| delivery_stats_total_count | Unknown |  |
| detractor | Unknown |  |
| passive | Unknown |  |
| promoter | Unknown |  |
| score | Unknown |  |
| total | Unknown |  |

### company_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | Unknown | PK |
| company_id | Unknown | PK, FK |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contacts_count | Unknown |  |
| created_date | Unknown |  |
| cx_metrics_ces | Unknown |  |
| cx_metrics_csat | Unknown |  |
| cx_metrics_nps | Unknown |  |
| cx_metrics_star | Unknown |  |
| cx_metrics_xsa | Unknown |  |
| domain | Unknown |  |
| industry_name | Unknown |  |
| name | Unknown |  |

### feedback_note

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feedback_id | Unknown | PK, FK |
| author | Unknown |  |
| content | Unknown |  |
| date | Unknown |  |
| metrics_type | Unknown |  |

### feedback_additional_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feedback_id | Unknown | PK, FK |
| answer | Unknown |  |
| consent | Unknown |  |
| metrics_type | Unknown |  |
| question_text | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### feedback_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | Unknown | PK |
| feedback_id | Unknown | PK, FK |

### feedback_topic

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feedback_id | Unknown | PK, FK |
| name | Unknown |  |
| sentiment | Unknown |  |

### feedback_response_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_name | Unknown | PK |
| feedback_id | Unknown | PK, FK |

### feedback

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| company_id | Unknown | FK |
| customer_id | Unknown | FK |
| assigned | Unknown |  |
| channel | Unknown |  |
| checkbox | Unknown |  |
| city | Unknown |  |
| comment | Unknown |  |
| country | Unknown |  |
| created_date | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_bogus | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| metrics_type | Unknown |  |
| rating_category | Unknown |  |
| resolved | Unknown |  |
| score | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| custom_** |  |  |

## Relationships

- customer_tag(customer_id) → customer(id)
- customer_property(customer_id) → customer(id)
- customer(company_id) → company(id)
- campaign(template_id) → template(id)
- outbox_additional_recipient(mandrill_message_id) → outbox(customer_id)
- outbox_additional_recipient(customer_id) → outbox(customer_id)
- outbox_customer_tag(outbox_customer_id) → outbox(customer_id)
- outbox(campaign_id) → campaign(id)
- outbox(customer_id) → customer(id)
- outbox(company_id) → company(id)
- outbox(survey_template_id) → template(id)
- report_question_stats(report_campaign_id) → report(campaign_id)
- report_trend(report_campaign_id) → report(campaign_id)
- report(campaign_id) → campaign(id)
- company_tag(company_id) → company(id)
- feedback_note(feedback_id) → feedback(id)
- feedback_additional_question(feedback_id) → feedback(id)
- feedback_tag(feedback_id) → feedback(id)
- feedback_topic(feedback_id) → feedback(id)
- feedback_response_tag(feedback_id) → feedback(id)
- feedback(campaign_id) → campaign(id)
- feedback(customer_id) → customer(id)
- feedback(company_id) → company(id)