Fivetran documentation

Search the docs

/

Front

Explore the interactive ERD

Table & Field Reference

conversation

Column	Type	Keys
`id`	String	PK
`last_message_id`	String	FK
`teammate_id`	String	FK
`created_at`	Instant
`recipient_handle`	String
`recipient_role`	String
`status`	String
`status_category`	String
`status_id`	String
`subject`	String

inbox_channel

Column	Type	Keys
`channel_id`	String	PKFK
`inbox_id`	String	PKFK

inbox

Column	Type	Keys
`id`	String	PK
`address`	String
`name`	String
`send_as`	String
`type`	String

rule_action

Column	Type	Keys
`index`	Int	PK
`rule_id`	String	PKFK
`action`	String

conversation_link_history

Column	Type	Keys
`link_id`	String	PK
`updated_at`	Instant	PK
`conversation_id`	String	PKFK
`source_rule_id`	String	FK
`source_teammate_id`	String	FK
`event_type`	String
`source_type`	String

list

Column	Type	Keys
`id`	String	PK
`name`	String

comment

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	FK
`author_id`	String
`body`	String
`posted_at`	Instant

team_teammate

Column	Type	Keys
`team_id`	String	PKFK
`teammate_id`	String	PKFK

shift_teammate

Column	Type	Keys
`shift_id`	String	PKFK
`teammate_id`	String	PKFK

shift

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`name`	String
`times`	Json
`timezone`	String
`updated_at`	Instant

conversation_tag_history

Column	Type	Keys
`tag_id`	String	PK
`updated_at`	Instant	PK
`conversation_id`	String	PKFK
`source_rule_id`	String	FK
`source_teammate_id`	String	FK
`event_type`	String
`source_type`	String

conversation_link

Column	Type	Keys
`conversation_id`	String	PKFK
`link_id`	String	PKFK

tag

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`description`	String
`highlight`	String
`is_private`	Boolean
`is_visible_in_conversation_lists`	Boolean
`name`	String
`parent_tag_id`	String
`updated_at`	Instant

ticket_status

Column	Type	Keys
`id`	String	PK
`category`	String
`created_at`	Instant
`description`	String
`name`	String
`updated_at`	Instant

comment_mention

Column	Type	Keys
`teammate_id`	String	PK
`comment_id`	String	PKFK

message_recipient

Column	Type	Keys
`index`	Int	PK
`message_id`	String	PKFK
`contact_id`	String	FK
`handle`	String
`role`	String

conversation_inbox

Column	Type	Keys
`conversation_id`	String	PKFK
`inbox_id`	String	PKFK

message_template_inbox

Column	Type	Keys
`inbox_id`	String	PKFK
`message_template_id`	String	PKFK

inbox_teammate

Column	Type	Keys
`inbox_id`	String	PKFK
`teammate_id`	String	PKFK

message_template_folder

Column	Type	Keys
`id`	String	PK
`owner_id`	String	FK
`parent_folder_id`	String	FK
`created_at`	Instant
`name`	String
`updated_at`	Instant

account

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`description`	String
`domains`	Json
`external_id`	String
`logo_url`	String
`name`	String
`updated_at`	Instant

message

Column	Type	Keys
`id`	String	PK
`author_id`	String	FK
`conversation_id`	String	FK
`blurb`	String
`body`	String
`created_at`	Instant
`duration`	Int
`have_been_answered`	Boolean
`have_been_favorited`	Boolean
`have_been_retweeted`	Boolean
`headers`	Json
`intercom_url`	String
`is_inbound`	Boolean
`is_retweet`	Boolean
`text`	String
`thread_ref`	String
`twitter_url`	String
`type`	String

teammate

Column	Type	Keys
`id`	String	PK
`email`	String
`first_name`	String
`is_admin`	Boolean
`is_available`	Boolean
`last_name`	String
`username`	String

contact_link

Column	Type	Keys
`index`	Int	PK
`contact_id`	String	PKFK
`link`	String

follower

Column	Type	Keys
`conversation_id`	String	PKFK
`teammate_id`	String	PKFK

conversation_status_history

Column	Type	Keys
`status`	String	PK
`updated_at`	Instant	PK
`conversation_id`	String	PKFK
`source_rule_id`	String	FK
`source_teammate_id`	String	FK
`target_teammate_id`	String	FK
`source_type`	String

link

Column	Type	Keys
`id`	String	PK
`external_url`	String
`name`	String
`type`	String

team_inbox

Column	Type	Keys
`inbox_id`	String	PKFK
`team_id`	String	PKFK

channel

Column	Type	Keys
`id`	String	PK
`address`	String
`send_as`	String
`settings`	Json
`type`	String

team

Column	Type	Keys
`id`	String	PK
`name`	String

message_template

Column	Type	Keys
`id`	String	PK
`folder_id`	String	FK
`owner_id`	String	FK
`body`	String
`is_available_for_all_inboxes`	Boolean
`name`	String
`subject`	String

attachment

Column	Type	Keys
`index`	Int	PK
`message_id`	String	PKFK
`cid`	String
`content_type`	String
`filename`	String
`is_inline`	Boolean
`size`	Int
`url`	String

contact

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`avatar_url`	String
`description`	String
`name`	String

conversation_tag

Column	Type	Keys
`conversation_id`	String	PKFK
`tag_id`	String	PKFK

contact_handle

Column	Type	Keys
`index`	Int	PK
`contact_id`	String	PKFK
`handle`	String
`source`	String

contact_note

Column	Type	Keys
`index`	Int	PK
`contact_id`	String	PKFK
`author_id`	String	FK
`body`	String
`created_at`	Instant

contact_list

Column	Type	Keys
`contact_id`	String	PKFK
`list_id`	String	PKFK

message_template_attachment

Column	Type	Keys
`id`	String	PK
`message_template_id`	String	PKFK
`cid`	String
`content_type`	String
`filename`	String
`is_inline`	Boolean
`size`	Int
`url`	String

rule

Column	Type	Keys
`id`	String	PK
`name`	String