# Ada schema ERD

Table and field reference for the Fivetran Ada connector.

## Table & Field Reference

### message_quick_reply

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_id | String | PK, FK |
| button_type | String |  |
| label | String |  |
| target | String |  |

### message_select_table

| Column | Type | Keys |
| --- | --- | --- |
| choose_prompt | String | PK |
| message_id | String | PK, FK |

### message_selected

| Column | Type | Keys |
| --- | --- | --- |
| selected | String | PK |
| message_id | String | PK, FK |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| conversation_id | String | FK |
| agent_info_default_image | String |  |
| agent_info_external_id | String |  |
| agent_info_image_url | String |  |
| agent_info_internal_id | String |  |
| agent_info_name | String |  |
| alt_text | String |  |
| amount | Long |  |
| answer_id | String |  |
| answer_title | String |  |
| body | String |  |
| button_type | String |  |
| by | String |  |
| chatter_id | String |  |
| date_created | Instant |  |
| event | String |  |
| external_chat_id | String |  |
| external_id | String |  |
| generate_link_preview | Boolean |  |
| has_forced_quick_replies | Boolean |  |
| has_variable | Boolean |  |
| header | String |  |
| in_response_to | Unknown |  |
| is_expired | Boolean |  |
| is_forced | Boolean |  |
| is_handoff | Boolean |  |
| is_positive | Boolean |  |
| link_description | String |  |
| link_icon | String |  |
| link_text | String |  |
| link_was_clicked | Boolean |  |
| locked | Boolean |  |
| meta_data_agent_id | String |  |
| meta_data_department_id | String |  |
| meta_data_display_name | String |  |
| meta_data_event_type | String |  |
| meta_data_id | String |  |
| meta_data_name | String |  |
| meta_data_new_value | String |  |
| meta_data_old_value | String |  |
| meta_data_response_id | String |  |
| meta_data_scope | String |  |
| meta_data_subtype | String |  |
| meta_data_triggered_by | String |  |
| meta_data_type | String |  |
| meta_message_type | String |  |
| multiple | Boolean |  |
| new_window | Boolean |  |
| pic_url | String |  |
| prompt | String |  |
| raw_url | String |  |
| recipient | String |  |
| record_last_updated | Unknown |  |
| review | Long |  |
| reviewable_message | Boolean |  |
| score | Long |  |
| sender | String |  |
| style | String |  |
| survey_type | String |  |
| temp_message_uuid | String |  |
| title | String |  |
| tos | String |  |
| type | String |  |
| unit | String |  |
| url | String |  |
| window_button_label | String |  |
| window_height | Long |  |
| window_title | String |  |
| window_url | String |  |
| window_width | Long |  |

### conversation_feedback

| Column | Type | Keys |
| --- | --- | --- |
| feedback_message | String | PK |
| conversation_id | String | PK, FK |

### conversation_classification_intent

| Column | Type | Keys |
| --- | --- | --- |
| intent_id | Unknown | PK |
| conversation_classification_topic_id | Unknown | PK, FK |
| conversation_id | String | PK, FK |
| intent_name | Unknown |  |
| status | Unknown |  |

### conversation_classification

| Column | Type | Keys |
| --- | --- | --- |
| topic_id | Unknown | PK |
| conversation_id | String | PK, FK |
| topic_name | Unknown |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| agent_handle_time | Unknown |  |
| agent_id | Json |  |
| agent_name | Json |  |
| automated_resolution_classification | Unknown |  |
| automated_resolution_classification_reason | Unknown |  |
| bot_handle_time | Unknown |  |
| browser | String |  |
| browser_version | String |  |
| chatter_id | String |  |
| csat_ces_max | Long |  |
| csat_comment | String |  |
| csat_customer_effort_score | Long |  |
| csat_is_positive | Boolean |  |
| csat_net_promoter_score | Long |  |
| csat_resolved | Boolean |  |
| csat_score | Unknown |  |
| csat_style | String |  |
| csat_survey_type | String |  |
| date_created | Instant |  |
| date_updated | Instant |  |
| device | Unknown |  |
| end_user_id | Unknown |  |
| generated_topic_id | Unknown |  |
| generated_topic_label | Unknown |  |
| generated_topic_v_2_desc | Unknown |  |
| generated_topic_v_2_id | Unknown |  |
| generated_topic_v_2_parent_id | Unknown |  |
| generated_topic_v_2_title | Unknown |  |
| inquiry_summary | Unknown |  |
| is_engaged | Boolean |  |
| is_escalated | Boolean |  |
| is_test_user | Boolean |  |
| languages | String |  |
| oauth_channel | Unknown |  |
| platform | String |  |
| record_last_updated | Instant |  |
| metavariable_** |  |  |
| variable_** |  |  |

## Relationships

- message_quick_reply(message_id) → message(id)
- message_select_table(message_id) → message(id)
- message_selected(message_id) → message(id)
- message(conversation_id) → conversation(id)
- conversation_feedback(conversation_id) → conversation(id)
- conversation_classification_intent(conversation_classification_topic_id) → conversation_classification(topic_id)
- conversation_classification_intent(conversation_id) → conversation_classification(conversation_id)
- conversation_classification(conversation_id) → conversation(id)