ERD for Intercom

15 tables

Loading diagram…

admin

string

name

string

job_title

string

_weld_synced

date

intercom_team_admin

admin_id

string

team_id

string

index

int

_weld_synced

date

contact

string

external_id

string

owner_id

string

workspace_id

string

name

string

phone

string

role

string

avatar

string

has_hard_bounced

boolean

marked_email_as_spam

boolean

unsubscribed_from_emails

boolean

browser

string

browser_version

string

browser_language

string

language_override

string

location_city

string

location_country

string

location_region

string

location_country_code

string

location_continent_code

string

android_app_name

string

android_app_version

string

android_device

string

android_os_version

string

android_sdk_version

string

android_last_seen_at

string

ios_app_name

string

ios_app_version

string

ios_device

string

ios_os_version

string

ios_sdk_version

string

ios_last_seen_at

date

created_at

date

updated_at

date

signed_up_at

date

last_contacted_at

date

last_email_clicked_at

date

last_email_opened_at

date

last_replied_at

date

last_seen_at

date

_weld_synced

date

intercom_contact_company

contact_id

string

company_id

string

index

int

contact_updated_at

date

_weld_synced

date

intercom_contact_tag

contact_id

string

tag_id

string

index

int

contact_updated_at

date

_weld_synced

date

conversation

string

admin_assignee_id

int

team_assignee_id

int

open

boolean

priority

string

read

boolean

state

string

title

string

conversation_rating_remark

string

conversation_rating_value

int

conversation_rating_created_at

date

first_contact_reply_type

string

first_contact_reply_url

string

first_contact_reply_created_at

date

sla_name

string

sla_status

string

source_type

string

source_id

string

source_author_id

string

source_author_type

string

source_delivered_as

string

source_subject

string

source_body

string

source_url

string

source_redacted

boolean

created_at

date

updated_at

date

snoozed_until

date

waiting_since

date

statistics_type

string

statistics_time_to_assignment

double

statistics_time_to_admin_reply

double

statistics_time_to_first_close

double

statistics_time_to_last_close

double

statistics_median_time_to_reply

string

statistics_first_contact_reply_at

date

statistics_first_assignment_at

date

statistics_first_admin_reply_at

date

statistics_first_close_at

date

statistics_last_assignment_at

date

statistics_last_assignment_admin_reply_at

date

statistics_last_contact_reply_at

date

statistics_last_admin_reply_at

date

statistics_last_close_at

date

statistics_last_closed_by_id

string

statistics_count_reopens

double

statistics_count_assignments

double

statistics_count_conversation_parts

double

ai_agent_content_sources_type

string

ai_agent_content_sources_content_sources

string

ai_agent_content_sources_total_count

double

ai_agent_last_answer_type

string

ai_agent_rating

double

ai_agent_rating_remark

string

ai_agent_resolution_state

string

ai_agent_source_type

string

ai_agent_source_title

string

ai_agent_participated

boolean

_weld_synced

date

intercom_conversation_admin

conversation_id

string

admin_id

string

index

int

conversation_updated_at

date

_weld_synced

date

intercom_conversation_contact

conversation_id

string

contact_id

string

index

int

conversation_updated_at

date

_weld_synced

date

conversation_part

string

conversation_id

string

author_id

string

author_type

string

body

string

part_type

string

redacted

boolean

assigned_to_id

string

assigned_to_type

string

created_at

date

updated_at

date

notified_at

date

conversation_updated_at

date

_weld_synced

date

intercom_conversation_part_attachment

conversation_part_id

string

name

string

url

string

index

int

conversation_part_created_at

date

_weld_synced

date

call

string

conversation_id

string

admin_id

string

contact_id

string

type

string

state

string

initiated_at

date

answered_at

date

ended_at

date

created_at

date

updated_at

date

recording_url

string

call_type

string

direction

string

ended_reason

string

phone

string

fin_recording_url

string

fin_transcription_url

string

_weld_synced

date

company

string

company_id

string

name

string

monthly_spend

double

session_count

int

size

int

user_count

int

plan_id

string

plan_name

string

industry

string

website

string

created_at

date

updated_at

date

_weld_synced

date

tag

string

name

string

_weld_synced

date

team

string

name

string

_weld_synced

date

ticket

string

ticket_state

string

ticket_type_id

string

ticket_type_name

string

ticket_type_description

string

ticket_type_icon

string

ticket_type_workspace_id

string

ticket_type_archived

boolean

ticket_type_created_at

date

ticket_type_updated_at

date

ticket_type_is_internal

boolean

contacts_contacts

string

admin_assignee_id

string

team_assignee_id

string

created_at

date

updated_at

date

ticket_parts_ticket_parts

string

ticket_parts_total_count

double

default_title

string

platforms

string

severity

string

default_description

string

ticket_category

string

device_id

string

failure_reason

string

department

string

_weld_synced

date

Table

Sub table