# HappyFox schema ERD

Table and field reference for the Fivetran HappyFox connector.

## 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 | PK, FK |
| 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 | PK, FK |
| category | Unknown |  |
| orders | Unknown |  |

### custom_ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| compulsory_on_move | Unknown |  |
| depends_on_choice | Unknown |  |
| required | Unknown |  |

### staff_activity

| Column | Type | Keys |
| --- | --- | --- |
| report_id | Unknown | PK, FK |
| staff_id | Unknown | PK, FK |
| 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 | PK, FK |
| staff_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### ticket_permission

| Column | Type | Keys |
| --- | --- | --- |
| permission | Unknown | PK |
| ticket_id | Unknown | PK, FK |

### ticket_update

| Column | Type | Keys |
| --- | --- | --- |
| update_id | Unknown | PK |
| ticket_id | Unknown | PK, FK |
| 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 | PK, FK |
| behavior | Unknown |  |
| color | Unknown |  |
| defaults | Unknown |  |
| name | Unknown |  |
| orders | Unknown |  |

### ticket_priority

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ticket_id | Unknown | PK, FK |
| 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 | PK, FK |

### staff_permission

| Column | Type | Keys |
| --- | --- | --- |
| permission | Unknown | PK |
| staff_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| users_id | Unknown | PK, FK |

### 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 | PK, FK |
| tags | Unknown |  |

### section_article

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| section_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- sla(report_id) → report(id)
- custom_user_choice(user_custom_id) → user_custom(id)
- custom_ticket_choice(value_id) → ticket_custom_field(id)
- custom_ticket_choice(custom_ticket_id) → custom_ticket(id)
- custom_ticket_category(custom_ticket_id) → custom_ticket(id)
- custom_ticket(id) → ticket_custom_field(id)
- staff_activity(staff_id) → staff(id)
- staff_activity(report_id) → report(id)
- staff_performance(staff_id) → staff(id)
- staff_performance(report_id) → report(id)
- articles_tags(article_id) → article(id)
- tabular_data(display_id) → ticket(display_id)
- tabular_data(report_id) → report(id)
- ticket_custom_field(ticket_id) → ticket(id)
- ticket_subscriber(ticket_id) → ticket(id)
- ticket_permission(ticket_id) → ticket(id)
- ticket_update(ticket_id) → ticket(id)
- ticket_category(ticket_id) → ticket(id)
- ticket_status(ticket_id) → ticket(id)
- ticket_priority(ticket_id) → ticket(id)
- ticket(user_id) → users(id)
- staff_catagory(staff_id) → staff(id)
- staff_permission(staff_id) → staff(id)
- customer_activity(report_id) → report(id)
- user_custom_field(id) → user_custom(id)
- user_custom_field(users_id) → users(id)
- sections_article_tags(section_id) → section(id)
- section_article(section_id) → section(id)
- section_categories(section_id) → section(id)