Intercom schema

17 tables · 10 joins

About the connector Start free

17 tables

Loading diagram…

admin

contact

conversation

conversation_part

admin

5

id

string

name

string

email

string

job_title

string

_weld_synced

date

team_admin

4

admin_id

string

team_id

string

index

int

_weld_synced

date

call

19

id

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

company

14

id

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

contact

43

id

string

external_id

string

owner_id

string

workspace_id

string

name

string

email

string

phone

string

role

string

avatar

string

contact_company

5

contact_id

string

company_id

string

index

int

contact_updated_at

date

_weld_synced

date

contact_social_profile

6

contact_id

string

name

string

url

string

index

int

contact_updated_at

date

_weld_synced

date

contact_tag

5

contact_id

string

tag_id

string

index

int

contact_updated_at

date

_weld_synced

date

conversation

59

id

string

admin_assignee_id

int

team_assignee_id

int

open

boolean

priority

string

read

boolean

state

string

title

string

conversation_rating_remark

string

conversation_admin

5

conversation_id

string

admin_id

string

index

int

conversation_updated_at

date

_weld_synced

date

conversation_contact

5

conversation_id

string

contact_id

string

index

int

conversation_updated_at

date

_weld_synced

date

conversation_tag

5

conversation_id

string

tag_id

string

index

int

conversation_updated_at

date

_weld_synced

date

conversation_part

14

id

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

conversation_part_attachment

6

conversation_part_id

string

name

string

url

string

index

int

conversation_part_created_at

date

_weld_synced

date

tag

3

id

string

name

string

_weld_synced

date

team

3

id

string

name

string

_weld_synced

date

ticket

19

id

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