Helpshift
Explore the interactive ERD
Table & Field Reference
section_faq
| Column | Type | Keys |
|---|---|---|
faq_id | Unknown | PK |
section_id | Unknown | PKFK |
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 | PKFK |
private_note_email
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
issue_id | Unknown | PKFK |
private_note_author_id | Unknown | PKFK |
private_note
| Column | Type | Keys |
|---|---|---|
author_id | Unknown | PK |
issue_id | Unknown | PKFK |
author_name | Unknown | |
body | Unknown | |
created_at | Unknown | |
phone_number | Unknown |
message_author_email
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
message_author_id | Unknown | PKFK |
message_id | Unknown | PKFK |
message_intent_label
| Column | Type | Keys |
|---|---|---|
label_id | Unknown | PK |
message_author_id | Unknown | PKFK |
message_id | Unknown | PKFK |
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 | PKFK |
analytic_agent_time | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
faq_issue_tag
| Column | Type | Keys |
|---|---|---|
tag_name | Unknown | PK |
faq_id | Unknown | PKFK |
platform_type
| Column | Type | Keys |
|---|---|---|
type | Unknown | PK |
faq_id | Unknown | PKFK |
linked_faq
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
faq_id | Unknown | PKFK |
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 | PKFK |
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 |