HappyFox
Explore the interactive ERD
Table & Field Reference
sla
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
report_id | Unknown | FK |
achieved | Unknown | |
name | Unknown | |
target | Unknown | |
tickets_breached | Unknown | |
tickets_checked | Unknown |
custom_user_choice
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_custom_id | Unknown | PKFK |
dependant_field | Json | |
id | Unknown | |
text | Unknown |
user_custom
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
depends_on_choice | Unknown | |
name | Unknown | |
orders | Unknown | |
required | Unknown | |
type | Unknown | |
visible_to_staff_only | Unknown |
custom_ticket_choice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_ticket_id | Unknown | FK |
value_id | Unknown | FK |
dependant_field | Json |
custom_ticket_category
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
custom_ticket_id | Unknown | PKFK |
category | Unknown | |
orders | Unknown |
custom_ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
compulsory_on_move | Unknown | |
depends_on_choice | Unknown | |
required | Unknown |
staff_activity
| Column | Type | Keys |
|---|---|---|
report_id | Unknown | PKFK |
staff_id | Unknown | PKFK |
assigned | Unknown | |
completed | Unknown | |
name | Unknown | |
no_of_reply | Unknown | |
participated | Unknown | |
pending | Unknown | |
private_notes | Unknown | |
time_spent | Unknown |
report
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown |
staff_performance
| Column | Type | Keys |
|---|---|---|
report_id | Unknown | PKFK |
staff_id | Unknown | PKFK |
average_first_response_time | Unknown | |
average_no_of_responses | Unknown | |
average_no_of_responses_for_completion | Unknown | |
average_response_time | Unknown | |
average_time_spent | Unknown | |
average_time_to_ticket_complete | Unknown | |
name | Unknown |
articles_tags
| Column | Type | Keys |
|---|---|---|
tags | Unknown | PK |
article_id | Unknown | PKFK |
article
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attachments | Json | |
content | Unknown | |
contents | Unknown | |
full_url | Unknown | |
language_enabled | Unknown | |
language_id | Unknown | |
language_name | Unknown | |
language_visible | Unknown | |
last_updated_at | Unknown | |
related_articles | Json | |
section_id | Unknown | |
section_name | Unknown | |
slug | Unknown | |
title | Unknown | |
view | Unknown |
tabular_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
display_id | Unknown | FK |
report_id | Unknown | FK |
assignee | Unknown | |
due_date | Unknown | |
status_id | Unknown | |
status_name | Unknown | |
subject | Unknown |
ticket_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_id | Unknown | FK |
compulsory_on_complete | Unknown | |
name | Unknown | |
type | Unknown | |
value | Unknown | |
value_id | Unknown | |
visible_to_staff_only | Unknown |
ticket_subscriber
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_id | Unknown | PKFK |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown |
ticket_permission
| Column | Type | Keys |
|---|---|---|
permission | Unknown | PK |
ticket_id | Unknown | PKFK |
ticket_update
| Column | Type | Keys |
|---|---|---|
update_id | Unknown | PK |
ticket_id | Unknown | PKFK |
assignee_change | Unknown | |
category_change | Unknown | |
custom_field_change | Unknown | |
due_date_change | Unknown | |
priority_change_new | Unknown | |
priority_change_new_name | Unknown | |
priority_change_old | Unknown | |
priority_change_old_name | Unknown | |
satisfaction_survey | Unknown | |
status_change_new | Unknown | |
status_change_new_name | Unknown | |
status_change_old | Unknown | |
status_change_old_name | Unknown | |
time_spent | Unknown | |
time_stamp | Unknown | |
to_id | Unknown | |
to_type | Unknown |
ticket_category
| Column | Type | Keys |
|---|---|---|
category | Unknown | PK |
index | Unknown | PK |
ticket_id | Unknown | FK |
ticket_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_id | Unknown | PKFK |
behavior | Unknown | |
color | Unknown | |
defaults | Unknown | |
name | Unknown | |
orders | Unknown |
ticket_priority
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_id | Unknown | PKFK |
defaults | Unknown | |
name | Unknown | |
orders | Unknown |
ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
assigned_to | Unknown | |
attachment | Json | |
attachments_count | Unknown | |
category_description | Unknown | |
category_id | Unknown | |
category_name | Unknown | |
category_prepopulate_cc | Unknown | |
category_public | Unknown | |
category_time_spent_mandatory | Unknown | |
created_at | Unknown | |
display_id | Unknown | |
due_date | Unknown | |
first_message | Unknown | |
jira_issue_id | Unknown | |
last_modified | Unknown | |
last_staff_reply_at | Unknown | |
last_updated_at | Unknown | |
last_user_reply_at | Unknown | |
merged_tickets | Json | |
merged_to | Unknown | |
messages_count | Unknown | |
sla_breaches | Unknown | |
source | Unknown | |
subject | Unknown | |
subscribers | Json | |
tags | Unknown | |
time_spent | Unknown | |
unresponded | Unknown | |
user_contact_groups | Json | |
user_created_at | Unknown | |
user_email | Unknown | |
user_name | Unknown | |
user_pending_tickets_count | Unknown | |
user_primary_phoneid | Unknown | |
user_primary_phonenumber | Unknown | |
user_primary_phonetype | Unknown | |
user_tickets_count | Unknown | |
user_updated_at | Unknown | |
visible_only_staff | Unknown |
staff_catagory
| Column | Type | Keys |
|---|---|---|
category | Unknown | PK |
staff_id | Unknown | PKFK |
staff_permission
| Column | Type | Keys |
|---|---|---|
permission | Unknown | PK |
staff_id | Unknown | PKFK |
staff
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
email | Unknown | |
is_account_admin | Unknown | |
name | Unknown | |
role_id | Unknown | |
role_name | Unknown |
customer_activity
| Column | Type | Keys |
|---|---|---|
contact_id | Unknown | PK |
report_id | Unknown | PKFK |
completed_ticket | Unknown | |
email | Unknown | |
name | Unknown | |
no_of_reply | Unknown | |
no_of_ticket | Unknown | |
pending_ticket | Unknown | |
time_spent | Unknown |
user_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
users_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_groups | Unknown | |
created_at | Unknown | |
email | Unknown | |
name | Unknown | |
pending_tickets_count | Unknown | |
primary_phone_id | Unknown | |
primary_phone_number | Unknown | |
primary_phone_type | Unknown | |
tickets_count | Unknown | |
updated_at | Unknown |
sections_article_tags
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
section_id | Unknown | PKFK |
tags | Unknown |
section_article
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
section_id | Unknown | PKFK |
attachments | Json | |
contents | Unknown | |
full_url | Unknown | |
language_enabled | Unknown | |
language_id | Unknown | |
language_name | Unknown | |
language_visible | Unknown | |
last_updated_at | Unknown | |
related_articles | Json | |
section_name | Unknown | |
slug | Unknown | |
title | Unknown | |
views | Unknown |
section_categories
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
section_id | Unknown | PKFK |
description | Unknown | |
name | Unknown | |
prepopulate_cc | Unknown | |
public | Unknown | |
time_spent_mandatory | Unknown |
section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown | |
parent_section_id | Unknown | |
parent_section_name | Unknown |