# Gorgias schema ERD

Table and field reference for the Fivetran Gorgias connector.

## Table & Field Reference

### template_widget_2

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| template_widget_1_index | Unknown | FK |
| widget_id | Unknown | FK |
| path | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### template_widget_1

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| widget_id | Unknown | PK, FK |
| path | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### widget

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| app_id | Unknown |  |
| context | Unknown |  |
| created_datetime | Instant |  |
| deactivated_datetime | Unknown |  |
| orders | Unknown |  |
| template_type | Unknown |  |
| type | Unknown |  |
| updated_datetime | Unknown |  |

### custom_fields

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_datetime | Unknown |  |
| deactivated_datetime | Unknown |  |
| definition_data_type | Unknown |  |
| definition_input_settings | Json |  |
| description | Unknown |  |
| external_id | Unknown |  |
| label | Unknown |  |
| managed_type | Unknown |  |
| object_type | Unknown |  |
| priority | Unknown |  |
| required | Unknown |  |
| requirement_type | Unknown |  |
| updated_datetime | Unknown |  |

### rules

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| code | Unknown |  |
| created_datetime | Instant |  |
| deactivated_datetime | Unknown |  |
| description | Unknown |  |
| event_types | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| settings | Json |  |
| type | Unknown |  |
| updated_datetime | Unknown |  |
| custom_** |  |  |

### satisfaction_survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| ticket_id | Unknown | FK |
| body_text | Unknown |  |
| created_datetime | Instant |  |
| score | Unknown |  |
| scored_datetime | Unknown |  |
| sent_datetime | Unknown |  |
| should_send_datetime | Unknown |  |

### view_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| view_id | Unknown | FK |
| field | Unknown |  |

### view_shared_with_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| view_id | Unknown | FK |
| decoration | Unknown |  |

### view_shared_with_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| view_id | Unknown | FK |
| custom_** |  |  |

### view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| category | Unknown |  |
| created_datetime | Instant |  |
| deactivated_datetime | Unknown |  |
| decoration_emoji | Unknown |  |
| filters | Unknown |  |
| name | Unknown |  |
| order_by | Unknown |  |
| order_dir | Unknown |  |
| search | Unknown |  |
| section_id | Unknown |  |
| shared_with_teams | Unknown |  |
| shared_with_users | Unknown |  |
| slug | Unknown |  |
| type | Unknown |  |
| visibility | Unknown |  |
| custom_filters_ast_** |  |  |

### view_item_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| user_id | Unknown | FK |
| view_item_id | Unknown | FK |
| address | Unknown |  |
| created_datetime | Unknown |  |
| deleted_datetime | Unknown |  |
| preferred | Unknown |  |
| type | Unknown |  |
| updated_datetime | Unknown |  |

### view_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_team_id | Unknown | FK |
| assignee_user_id | Unknown | FK |
| customer_id | Unknown | FK |
| view_id | Unknown | FK |
| integration | Json |  |
| languages | Unknown |  |
| meta | Unknown |  |
| subject | Unknown |  |

### macro_action

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| macro_id | Unknown | FK |
| name | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### macro

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_datetime | Unknown |  |
| external_id | Unknown |  |
| intent | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |
| updated_datetime | Instant |  |
| usage | Unknown |  |

### ticket_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| ticket_id | Unknown | PK, FK |
| value | Unknown |  |

### ticket_tag

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

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_user | Unknown | FK |
| customer_id | Unknown | FK |
| channel | Unknown |  |
| closed_datetime | Unknown |  |
| created_datetime | Unknown |  |
| customer_data_city | Unknown |  |
| customer_integration | Json |  |
| customer_meta_postion | Unknown |  |
| excerpt | Unknown |  |
| external_id | Unknown |  |
| from_agent | Unknown |  |
| is_unread | Unknown |  |
| languages | Unknown |  |
| last_message_datetime | Unknown |  |
| last_received_message_datetime | Unknown |  |
| messages_count | Unknown |  |
| opened_datetime | Unknown |  |
| snooze_datetime | Unknown |  |
| spam | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| trashed_datetime | Unknown |  |
| updated_datetime | Instant |  |
| via | Unknown |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | FK |
| email | Unknown |  |
| meta | Unknown |  |
| name | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| created_datetime | Instant |  |
| name | Unknown |  |

### message_source_to

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| message_id | Unknown | FK |
| address | Unknown |  |
| msg_source_to_id | Unknown |  |
| name | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| integration_id | Unknown | FK |
| rule_id | Unknown | FK |
| ticket_id | Unknown | FK |
| actions | Unknown |  |
| attachments | Json |  |
| body_html | Unknown |  |
| body_text | Unknown |  |
| channel | Unknown |  |
| created_datetime | Instant |  |
| deleted_datetime | Unknown |  |
| external_id | Unknown |  |
| failed_datetime | Unknown |  |
| from_agent | Unknown |  |
| headers_from | Unknown |  |
| headers_to | Unknown |  |
| intents | Json |  |
| is_retriable | Unknown |  |
| last_sending_error | Unknown |  |
| macros | Json |  |
| message_id | Unknown |  |
| meta | Unknown |  |
| opened_datetime | Unknown |  |
| public | Unknown |  |
| receiver_email | Unknown |  |
| receiver_firstname | Unknown |  |
| receiver_id | Unknown |  |
| receiver_lastname | Unknown |  |
| receiver_meta | Unknown |  |
| receiver_name | Unknown |  |
| sender_email | Unknown |  |
| sender_firstname | Unknown |  |
| sender_id | Unknown |  |
| sender_lastname | Unknown |  |
| sender_meta | Unknown |  |
| sender_name | Unknown |  |
| sent_datetime | Unknown |  |
| source_type | Unknown |  |
| stripped_html | Unknown |  |
| stripped_signature | Unknown |  |
| stripped_text | Unknown |  |
| subject | Unknown |  |
| uri | Unknown |  |
| via | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| object_id | Unknown | PK |
| user_id | Unknown | FK |
| context | Unknown |  |
| created_datetime | Unknown |  |
| object_type | Unknown |  |
| type | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| active | Unknown |  |
| bio | Unknown |  |
| country | Unknown |  |
| created_datetime | Instant |  |
| deactivated_datetime | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| has_2_fa_enabled | Unknown |  |
| has_password | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| role_name | Unknown |  |
| timezone | Unknown |  |
| updated_datetime | Unknown |  |
| custom_** |  |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| created_datetime | Instant |  |
| decoration_color | Unknown |  |
| deleted_datetime | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| usage | Unknown |  |

### integration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| ticket_id | Unknown | FK |
| user_id | Unknown | FK |
| created_datetime | Instant |  |
| deactivated_datetime | Unknown |  |
| decoration | Unknown |  |
| deleted_datetime | Unknown |  |
| description | Unknown |  |
| form_hello | Unknown |  |
| http_id | Unknown |  |
| http_method | Unknown |  |
| locked_datetime | Unknown |  |
| meta_address | Unknown |  |
| meta_email_forwarding_activated | Unknown |  |
| meta_preferred | Unknown |  |
| meta_provider | Unknown |  |
| meta_verified | Unknown |  |
| name | Unknown |  |
| outbound_verification_status_domain | Unknown |  |
| outbound_verification_status_single_sender | Unknown |  |
| triggers_ticket_created | Unknown |  |
| triggers_ticket_message_created | Unknown |  |
| triggers_ticket_updated | Unknown |  |
| type | Unknown |  |
| updated_datetime | Unknown |  |

### job_ticket

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

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| cancel_requested_datetime | Unknown |  |
| cancelled_datetime | Unknown |  |
| created_datetime | Instant |  |
| ended_datetime | Unknown |  |
| failed_datetime | Unknown |  |
| locked_datetime | Unknown |  |
| param_updates_status | Unknown |  |
| scheduled_datetime | Unknown |  |
| started_datetime | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### customer_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| value | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| created_datetime | Unknown |  |
| data | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| timezone | Unknown |  |
| updated_datetime | Instant |  |

## Relationships

- template_widget_2(template_widget_1_index) → template_widget_1(index)
- template_widget_2(widget_id) → template_widget_1(widget_id)
- template_widget_1(widget_id) → widget(id)
- widget(id) → event(object_id)
- rules(id) → event(object_id)
- satisfaction_survey(customer_id) → customer(id)
- satisfaction_survey(ticket_id) → ticket(id)
- view_field(view_id) → view(id)
- view_shared_with_team(id) → team(id)
- view_shared_with_team(view_id) → view(id)
- view_shared_with_user(id) → users(id)
- view_shared_with_user(view_id) → view(id)
- view(id) → event(object_id)
- view_item_channel(user_id) → users(id)
- view_item_channel(customer_id) → customer(id)
- view_item_channel(view_item_id) → view_item(id)
- view_item(customer_id) → customer(id)
- view_item(assignee_user_id) → users(id)
- view_item(assignee_team_id) → team(id)
- view_item(view_id) → view(id)
- macro_action(macro_id) → macro(id)
- ticket_custom_field(id) → custom_fields(id)
- ticket_custom_field(ticket_id) → ticket(id)
- ticket_tag(id) → tags(id)
- ticket_tag(ticket_id) → ticket(id)
- ticket(assignee_user) → users(id)
- ticket(customer_id) → customer(id)
- team_member(team_id) → team(id)
- team(id) → event(object_id)
- message_source_to(message_id) → message(id)
- message(id) → event(object_id)
- message(integration_id) → integration(id)
- message(ticket_id) → ticket(id)
- message(rule_id) → rules(id)
- event(user_id) → users(id)
- users(id) → event(object_id)
- tags(id) → event(object_id)
- integration(user_id) → users(id)
- integration(id) → event(object_id)
- integration(ticket_id) → ticket(id)
- job_ticket(ticket_id) → ticket(id)
- job_ticket(job_id) → job(id)
- job(user_id) → users(id)
- customer_custom_field(id) → custom_fields(id)
- customer_custom_field(customer_id) → customer(id)