Gorgias
Explore the interactive ERD
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 | PKFK |
path | Unknown | |
title | Unknown | |
type | Unknown |
widget
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
view_id | Unknown | FK |
decoration | Unknown |
view_shared_with_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
view_id | Unknown | FK |
custom_** |
view
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
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 | PKFK |
ticket_id | Unknown | PKFK |
value | Unknown |
ticket_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
created_datetime | Instant | |
decoration_color | Unknown | |
deleted_datetime | Unknown | |
description | Unknown | |
name | Unknown | |
usage | Unknown |
integration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
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 | PKFK |
ticket_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 |