# Helpshift schema ERD

Table and field reference for the Fivetran Helpshift connector.

## Table & Field Reference

### section_faq

| Column | Type | Keys |
| --- | --- | --- |
| faq_id | Unknown | PK |
| section_id | Unknown | PK, FK |

### section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_id | Unknown | FK |
| created_at | Unknown |  |
| icon | Unknown |  |
| image | Unknown |  |
| title | Unknown |  |
| custom_** |  |  |

### platform

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_id | Unknown | FK |
| type | Unknown |  |

### app

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| logo | Unknown |  |
| publish_id | Unknown |  |
| title | Unknown |  |

### analytic_faq

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| app_id | Unknown | FK |
| section_id | Unknown | FK |
| dislike | Unknown |  |
| id | Unknown |  |
| languages | Unknown |  |
| last_updated_at | Unknown |  |
| likes | Unknown |  |
| platform_type | Unknown |  |
| row_id | Unknown |  |
| section_title | Unknown |  |
| time | Unknown |  |
| title | Unknown |  |
| view | Unknown |  |

### data_portability

| Column | Type | Keys |
| --- | --- | --- |
| hs_request_id | Unknown | PK |
| encrypted_zip | Unknown |  |
| eta | Unknown |  |
| external_request_id | Unknown |  |
| hs_data_url | Unknown |  |
| reason | Unknown |  |
| request_app_publish_id | Unknown |  |
| request_external_request_id | Unknown |  |
| request_property | Unknown |  |
| request_value | Unknown |  |
| status | Unknown |  |
| url_valid_until | Unknown |  |

### agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar | Unknown |  |
| email | Unknown |  |
| last_login_at | Unknown |  |
| name | Unknown |  |
| nickname | Unknown |  |
| role | Unknown |  |
| team_name | Unknown |  |

### issue_tag

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

### private_note_email

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| issue_id | Unknown | PK, FK |
| private_note_author_id | Unknown | PK, FK |

### private_note

| Column | Type | Keys |
| --- | --- | --- |
| author_id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| author_name | Unknown |  |
| body | Unknown |  |
| created_at | Unknown |  |
| phone_number | Unknown |  |

### message_author_email

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| message_author_id | Unknown | PK, FK |
| message_id | Unknown | PK, FK |

### message_intent_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Unknown | PK |
| message_author_id | Unknown | PK, FK |
| message_id | Unknown | PK, FK |

### message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| message_author_id | Unknown | FK |
| message_id | Unknown | FK |
| content_type | Unknown |  |
| file_name | Unknown |  |
| size | Unknown |  |
| url | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| author_id | Unknown | PK |
| id | Unknown | PK |
| issue_id | Unknown | FK |
| attachment_content_type | Unknown |  |
| attachment_file_name | Unknown |  |
| attachment_size | Unknown |  |
| attachment_url | Unknown |  |
| author_name | Unknown |  |
| author_phone_number | Unknown |  |
| body | Unknown |  |
| created_at | Unknown |  |
| origin | Unknown |  |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_publish_id | Unknown | FK |
| assignee_id | Unknown | FK |
| queue_id | Unknown | FK |
| app_id | Unknown |  |
| author_email | Unknown |  |
| author_name | Unknown |  |
| changed_at | Unknown |  |
| created_at | Unknown |  |
| current_predict_label | Unknown |  |
| domain | Unknown |  |
| feedback_comment | Unknown |  |
| feedback_rating | Unknown |  |
| hs_user_id | Unknown |  |
| intent_group_id | Unknown |  |
| intent_group_name | Unknown |  |
| intent_id | Unknown |  |
| intent_name | Unknown |  |
| original_predict_label | Unknown |  |
| redacted | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |
| meta_** |  |  |

### analytic_custom_bot

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_interruption | Unknown |  |
| automation_interruption | Unknown |  |
| avg_completion_time | Unknown |  |
| cifs_mapped | Unknown |  |
| completion | Unknown |  |
| inbound_messages | Unknown |  |
| invocation | Unknown |  |
| issues_rejected | Unknown |  |
| issues_reopened | Unknown |  |
| issues_resolved | Unknown |  |
| name | Unknown |  |
| outbound_message | Unknown |  |
| row_id | Unknown |  |
| status | Unknown |  |
| time | Unknown |  |

### queue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| auto_assignment_enabled | Unknown |  |
| name | Unknown |  |

### analytic_open_issue

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| app_id | Unknown | FK |
| languages | Unknown |  |
| open_issues | Unknown |  |
| platform_type | Unknown |  |
| row_id | Unknown |  |
| time | Unknown |  |

### analytic_agent_group

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| analytic_agent_id | Unknown | PK, FK |
| analytic_agent_time | Unknown | PK, FK |

### analytic_agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| time | Unknown | PK |
| accepted_resolution | Unknown |  |
| available_time | Unknown |  |
| avg_csat | Unknown |  |
| avg_outbound_messages_per_resolved | Unknown |  |
| avg_tter | Unknown |  |
| avg_ttfr | Unknown |  |
| avg_ttr | Unknown |  |
| csat_1_count | Unknown |  |
| csat_2_count | Unknown |  |
| csat_3_count | Unknown |  |
| csat_4_count | Unknown |  |
| csat_5_count | Unknown |  |
| csat_count | Unknown |  |
| duplicates_marked | Unknown |  |
| email | Unknown |  |
| inbound_phone_call | Unknown |  |
| issue_assign | Unknown |  |
| issue_reject | Unknown |  |
| issue_resolve | Unknown |  |
| loggedin_time | Unknown |  |
| name | Unknown |  |
| online_time | Unknown |  |
| outbound_message | Unknown |  |
| outbound_phone_call | Unknown |  |
| rejected_resolution | Unknown |  |
| reopen | Unknown |  |
| row_id | Unknown |  |
| team_id | Unknown |  |
| team_name | Unknown |  |
| tter_count | Unknown |  |
| ttfr_count | Unknown |  |
| ttr_count | Unknown |  |

### analytic_custom_bot_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| custom_bot_id | Unknown |  |
| custom_bot_name | Unknown |  |
| invocation | Unknown |  |
| name | Unknown |  |
| row_id | Unknown |  |
| skip | Unknown |  |
| time | Unknown |  |
| type | Unknown |  |

### analytic_support

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| app_id | Unknown | FK |
| avg_csat | Unknown |  |
| avg_tter | Unknown |  |
| avg_ttfr | Unknown |  |
| avg_ttr | Unknown |  |
| conversations_started | Unknown |  |
| csat_1_count | Unknown |  |
| csat_2_count | Unknown |  |
| csat_3_count | Unknown |  |
| csat_4_count | Unknown |  |
| csat_5_count | Unknown |  |
| csat_count | Unknown |  |
| inbound_message | Unknown |  |
| issue_assign | Unknown |  |
| issues_created | Unknown |  |
| issues_first_responded | Unknown |  |
| languages | Unknown |  |
| outbound_message | Unknown |  |
| platform_type | Unknown |  |
| rejects_by_agent | Unknown |  |
| rejects_by_automation | Unknown |  |
| reopen | Unknown |  |
| resolves_by_agent | Unknown |  |
| resolves_by_automation | Unknown |  |
| row_id | Unknown |  |
| time | Unknown |  |
| tter_count | Unknown |  |
| ttfr_count | Unknown |  |
| ttr_count | Unknown |  |
| widget_load | Unknown |  |
| widget_opens_existing_issue | Unknown |  |
| widget_opens_no_existing_issue | Unknown |  |

### translation_lg_stag

| Column | Type | Keys |
| --- | --- | --- |
| stag | Unknown | PK |
| faq_id | Unknown | PK, FK |

### faq_issue_tag

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

### platform_type

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| faq_id | Unknown | PK, FK |

### linked_faq

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

### faq

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_id | Unknown | FK |
| publish_id | Unknown | FK |
| section_id | Unknown | FK |
| created_at | Unknown |  |
| last_updated_by | Unknown |  |
| published | Unknown |  |
| slug | Unknown |  |
| updated_at | Unknown |  |

### translation_lg

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| faq_id | Unknown | FK |
| body | Unknown |  |
| content_updated_at | Unknown |  |
| title | Unknown |  |
| translation_type | Unknown |  |

### analytic_issue_tag

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

### analytic_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| accepted_resolution | Unknown |  |
| agent_outbound_message | Unknown |  |
| app_id | Unknown |  |
| automation_category_by_outbound_message | Unknown |  |
| automation_subcategory_by_outbound_message | Unknown |  |
| avg_tter | Unknown |  |
| created_at | Unknown |  |
| current_queue_id | Unknown |  |
| current_queue_name | Unknown |  |
| custombot_outbound_message | Unknown |  |
| email | Unknown |  |
| external_user_id | Unknown |  |
| feedback_at | Unknown |  |
| feedback_comment | Unknown |  |
| feedback_rating | Unknown |  |
| first_assigned_at | Unknown |  |
| first_responded_at | Unknown |  |
| handling_time | Unknown |  |
| holding_time | Unknown |  |
| inbound_message | Unknown |  |
| inbound_phone_call | Unknown |  |
| initial_queue_id | Unknown |  |
| initial_queue_name | Unknown |  |
| is_from_phone_deflection | Unknown |  |
| languages | Unknown |  |
| last_resolved_at | Unknown |  |
| original_issue_id | Unknown |  |
| other_outbound_message | Unknown |  |
| outbound_message | Unknown |  |
| outbound_phone_call | Unknown |  |
| phone_escalation | Unknown |  |
| platform_type | Unknown |  |
| rejected_resolution | Unknown |  |
| reopen | Unknown |  |
| row_id | Unknown |  |
| state | Unknown |  |
| tter_count | Unknown |  |
| tter_sum | Unknown |  |
| ttfa | Unknown |  |
| ttfr | Unknown |  |
| ttr | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- section_faq(section_id) → section(id)
- section(app_id) → app(id)
- platform(app_id) → app(id)
- analytic_faq(section_id) → section(id)
- analytic_faq(app_id) → app(id)
- issue_tag(issue_id) → issue(id)
- private_note_email(private_note_author_id) → private_note(author_id)
- private_note_email(issue_id) → issue(id)
- private_note(issue_id) → issue(id)
- message_author_email(message_author_id) → message(author_id)
- message_author_email(message_id) → message(id)
- message_intent_label(message_id) → message(id)
- message_intent_label(message_author_id) → message(author_id)
- message_attachment(message_id) → message(id)
- message_attachment(message_author_id) → message(author_id)
- message(issue_id) → issue(id)
- issue(app_publish_id) → app(publish_id)
- issue(queue_id) → queue(id)
- issue(assignee_id) → agent(id)
- analytic_open_issue(app_id) → app(id)
- analytic_agent_group(analytic_agent_id) → analytic_agent(id)
- analytic_agent_group(analytic_agent_time) → analytic_agent(time)
- analytic_custom_bot_step(id) → analytic_custom_bot(id)
- analytic_support(app_id) → app(id)
- translation_lg_stag(faq_id) → faq(id)
- faq_issue_tag(faq_id) → faq(id)
- platform_type(faq_id) → faq(id)
- linked_faq(faq_id) → faq(id)
- faq(section_id) → section(id)
- faq(publish_id) → app(publish_id)
- faq(app_id) → app(id)
- translation_lg(faq_id) → faq(id)
- analytic_issue_tag(analytic_issue_id) → analytic_issue(id)
- analytic_issue(assignee_id) → agent(id)