# Simplesat schema ERD

Table and field reference for the Fivetran Simplesat connector.

## Table & Field Reference

### answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | FK |
| response_id | Unknown | FK |
| survey_id | Unknown | FK |
| choice | Unknown |  |
| choice_label | Unknown |  |
| choices | Json |  |
| comment | Unknown |  |
| created | Unknown |  |
| follow_up_answer | Unknown |  |
| follow_up_answer_choice | Unknown |  |
| follow_up_answer_choices | Json |  |
| modified | Unknown |  |
| published_as_testimonial | Unknown |  |
| sentiment | Unknown |  |

### response_team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| response_id | Unknown | PK, FK |
| created | Unknown |  |
| custom_attributes | Json |  |
| email | Unknown |  |
| external_id | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |

### response_answer

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

### response_tag

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

### response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | FK |
| created | Unknown |  |
| customer_company | Unknown |  |
| customer_custom_attributes | Unknown |  |
| customer_email | Unknown |  |
| customer_external_id | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| customer_tags | Unknown |  |
| ip_address | Unknown |  |
| modified | Unknown |  |
| source | Unknown |  |
| team_member_id | Unknown |  |
| ticket_custom_attributes | Json |  |
| ticket_external_id | Unknown |  |
| ticket_id | Unknown |  |
| ticket_subject | Unknown |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_name | Unknown |  |
| metric | Unknown |  |
| name | Unknown |  |
| survey_token | Unknown |  |
| survey_type | Unknown |  |

### question_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| question_id | Unknown | PK, FK |
| action | Unknown |  |
| conditions | Json |  |
| question | Json |  |

### question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | FK |
| choices | Json |  |
| metric | Unknown |  |
| orders | Unknown |  |
| rating_scale | Unknown |  |
| required | Unknown |  |
| text | Unknown |  |

## Relationships

- answer(question_id) → question(id)
- answer(response_id) → response(id)
- answer(survey_id) → survey(id)
- response_team_member(response_id) → response(id)
- response_answer(answer_id) → answer(id)
- response_answer(response_id) → response(id)
- response_tag(response_id) → response(id)
- response(survey_id) → survey(id)
- question_rule(question_id) → question(id)
- question(survey_id) → survey(id)