Intercom

Explore the interactive ERD

Table & Field Reference

collection_history

Column	Type	Keys
`id`	String	PK
`help_center_id`	String	FK
`created_at`	Instant
`default_locale`	String
`description`	String
`icon`	String
`name`	String
`order`	Int
`parent_id`	String
`type`	String
`updated_at`	Instant
`url`	String
`workspace_id`	String

conversation_history

Column	Type	Keys
`id`	String	PK
`conversation_rating_contact_id`	String	FK
`source_author_id`	String	FK
`assignee_id`	String
`company_id`	String
`created_at`	Instant
`first_contact_reply_created_at`	Instant
`first_contact_reply_type`	String
`first_contact_reply_url`	String
`open`	Boolean
`priority`	String
`read`	Boolean
`sla_name`	String
`sla_status`	String
`snoozed_until`	Instant
`state`	String
`team_assignee_id`	String
`title`	String
`updated_at`	Instant
`waiting_since`	Instant
`ai_agent_`
`conversation_rating_`
`source_`
`statistics_`

survey_question

Column	Type	Keys
`question_id`	Long	PK
`receipt_id`	Long	PKFK
`question`	String
`response_type`	String

subscription_type_content_type

Column	Type	Keys
`value`	String	PK
`subscription_type_id`	String	PKFK

contact_tag_history

Column	Type	Keys
`contact_id`	String	PKFK
`tag_id`	String	PKFK
`contact_updated_at`	Instant	FK

conversation_topic_history

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	PKFK
`conversation_updated_at`	Instant	FK
`name`	String
`type`	String

subscription_type_translation

Column	Type	Keys
`name`	String	PK
`subscription_type_id`	String	PKFK
`description`	String
`locale`	String

message_open

Column	Type	Keys
`opened_at`	Instant	PK
`receipt_id`	Long	PKFK

news_item_history

Column	Type	Keys
`id`	String	PK
`body`	String
`cover_image_url`	String
`created_at`	Instant
`deliver_silently`	Boolean
`sender_id`	String
`state`	String
`title`	String
`type`	String
`updated_at`	Instant
`workspace_id`	String

help_center_history

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`custom_domain`	String
`display_name`	String
`identifier`	String
`updated_at`	Instant
`url`	String
`website_turned_on`	Boolean
`workspace_id`	String

contact_data_event

Column	Type	Keys
`id`	String	PK
`intercom_user_id`	String	FK
`created_at`	Instant
`email`	String
`event_name`	String
`type`	String
`user_id`	String

company_tag_history

Column	Type	Keys
`company_id`	String	PKFK
`tag_id`	String	PKFK
`company_updated_at`	Instant	FK

ticket_type_attribute_history

Column	Type	Keys
`id`	String	PK
`ticket_type_id`	String	FK
`archived`	Boolean
`created_at`	Instant
`data_type`	String
`default`	Boolean
`description`	String
`input_options`	Json
`name`	String
`order`	Long
`required_to_create`	Boolean
`required_to_create_for_contacts`	Boolean
`type`	String
`updated_at`	Instant
`visible_on_create`	Boolean
`visible_to_contacts`	Boolean
`workspace_id`	String

conversation_tag_history

Column	Type	Keys
`conversation_id`	String	PKFK
`tag_id`	String	PKFK
`conversation_updated_at`	Instant	FK
`applied_at`	Instant
`applied_by_id`	String
`applied_by_type`	String
`tag_name`	String

call_transcript

Column	Type	Keys
`_fivetran_id`	String	PK
`call_id`	Long	PKFK
`content`	String
`end_time`	String
`speaker`	String
`speaker_label`	String
`start_time`	String

ticket_part_attachment_history

Column	Type	Keys
`index`	Int	PK
`ticket_id`	String	PKFK
`ticket_part_id`	String	PKFK
`content_type`	String
`filesize`	Long
`height`	Int
`name`	String
`type`	String
`url`	String
`width`	Int

article_history

Column	Type	Keys
`id`	String	PK
`collection_id`	String	FK
`author_id`	String
`body`	String
`created_at`	Instant
`default_locale`	String
`description`	String
`parent_id`	String
`parent_type`	String
`section_id`	String
`state`	String
`title`	String
`type`	String
`updated_at`	Instant
`url`	String
`workspace_id`	String
`statistics_`

article_parent

Column	Type	Keys
`parent_id`	String	PK
`article_id`	String	PKFK

conversation_ai_agent_content_source

Column	Type	Keys
`index`	Long	PK
`conversation_id`	String	PKFK
`content_type`	String
`locale`	String
`title`	String
`url`	String

conversation_part_history

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	FK
`conversation_updated_at`	Instant	FK
`app_package_code`	String
`assigned_to_id`	String
`assigned_to_type`	String
`body`	String
`created_at`	Instant
`email_message_metadata_message_id`	String
`email_message_metadata_subject`	String
`notified_at`	Instant
`part_type`	String
`state`	String
`updated_at`	Instant
`author_`

news_item_label_history

Column	Type	Keys
`value`	String	PK
`news_item_id`	String	PKFK

ticket_link_history

Column	Type	Keys
`id`	String	PK
`ticket_id`	String	PKFK
`category`	String
`type`	String

conversation_admin_history

Column	Type	Keys
`admin_id`	String	PKFK
`conversation_id`	String	PKFK
`conversation_updated_at`	Instant	FK

contact_segment_history

Column	Type	Keys
`contact_id`	String	PKFK
`segment_id`	String	PKFK
`contact_updated_at`	Instant	FK

ticket_contact_history

Column	Type	Keys
`id`	String	PKFK
`ticket_id`	String	PKFK
`external_id`	String
`type`	String

contact_subscription_history

Column	Type	Keys
`contact_id`	String	PKFK
`subscription_id`	String	PKFK
`contact_updated_at`	Instant	FK
`consent_type`	String

admin

Column	Type	Keys
`id`	String	PK
`away_mode_enabled`	Boolean
`away_mode_reassign`	Boolean
`email`	String
`has_inbox_seat`	Boolean
`job_title`	String
`name`	String

ticket_type_history

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`category`	String
`created_at`	Instant
`description`	String
`icon`	String
`is_internal`	Boolean
`name`	String
`type`	String
`updated_at`	Instant
`workspace_id`	String

conversation_part_attachment_history

Column	Type	Keys
`url`	String	PK
`conversation_part_id`	String	PKFK
`conversation_part_updated_at`	Instant	FK
`name`	String

away_status_reason

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`deleted`	Boolean
`emoji`	String
`label`	String
`orders`	Int
`updated_at`	Instant

newsfeed_history

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`name`	String
`type`	String
`updated_at`	Instant

team

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

conversation_source_attachment_history

Column	Type	Keys
`url`	String	PK
`conversation_id`	String	PKFK
`conversation_updated_at`	Instant	FK
`content_type`	String
`filesize`	Long
`height`	Long
`name`	String
`type`	String
`width`	Long

survey_answer

Column	Type	Keys
`question_id`	Long	PKFK
`receipt_id`	Long	PKFK
`answered_at`	Instant
`response`	String

receipt_response

Column	Type	Keys
`content_id`	Long	PK
`receipt_id`	Long	PK
`ruleset_id`	Long	PK
`company_external_id`	String
`company_id`	String
`content_title`	String
`content_type`	String
`conversation_id`	Long
`created_via`	String
`device`	String
`email`	String
`first_answer`	Instant
`first_button_tap`	Instant
`first_checklist_step_click`	Instant
`first_checklist_step_completion`	Instant
`first_checklist_step_open`	Instant
`first_checklist_step_receipt`	Instant
`first_click`	Instant
`first_collected_email`	Instant
`first_completion`	Instant
`first_dismissal`	Instant
`first_fin_helpful_answer`	Instant
`first_fin_step_reached`	Instant
`first_goal_success`	Instant
`first_hard_bounce`	Instant
`first_keyword_reply`	Instant
`first_open`	Instant
`first_people_reached_receipt`	Instant
`first_permission_grant`	Instant
`first_push_failure`	Instant
`first_reaction`	Instant
`first_reply`	Instant
`first_screen_view`	Instant
`first_series_completion`	Instant
`first_series_disengagement`	Instant
`first_series_exit`	Instant
`first_sms_failure`	Instant
`first_soft_bounce`	Instant
`first_spam_complaint`	Instant
`first_tour_step_failure`	Instant
`first_tour_step_view`	Instant
`first_unsubscribe`	Instant
`first_webhook_failure`	Instant
`first_whatsapp_failure`	Instant
`name`	String
`node_id`	String
`received_at`	Instant
`ruleset_version_id`	Long
`series_id`	Long
`series_title`	String
`user_external_id`	String
`user_id`	String

contact_company_history

Column	Type	Keys
`company_id`	String	PKFK
`contact_id`	String	PKFK
`contact_updated_at`	Instant	FK

ticket_part_history

Column	Type	Keys
`id`	String	PK
`ticket_id`	String	PKFK
`app_package_code`	String
`assigned_to_id`	String
`assigned_to_type`	String
`body`	String
`created_at`	Instant
`external_id`	String
`part_type`	String
`previous_ticket_state`	String
`redacted`	Boolean
`ticket_state`	String
`type`	String
`updated_at`	Instant
`author_`

conversation_contact_history

Column	Type	Keys
`contact_id`	String	PKFK
`conversation_id`	String	PKFK
`conversation_updated_at`	Instant	FK

company_segment_history

Column	Type	Keys
`company_id`	String	PKFK
`segment_id`	String	PKFK
`company_updated_at`	Instant	FK

admin_activity_log

Column	Type	Keys
`id`	String	PK
`performed_by_id`	String	FK
`activity_description`	String
`activity_type`	String
`created_at`	Instant
`metadata`	Json
`performed_by_ip`	String
`performed_by_type`	String

email_address_header

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_part_id`	String	PKFK
`email_address`	String
`name`	String
`type`	String

company_history

Column	Type	Keys
`id`	String	PK
`app_id`	String
`company_id`	String
`created_at`	Instant
`industry`	String
`last_request_at`	Instant
`monthly_spend`	Int
`name`	String
`plan_id`	String
`plan_name`	String
`remote_created_at`	Instant
`session_count`	Int
`size`	Int
`updated_at`	Instant
`user_count`	Int
`website`	String

newsfeed_assignment

Column	Type	Keys
`news_item_id`	String	PKFK
`newsfeed_id`	String	PKFK
`published_at`	Instant

contact_history

Column	Type	Keys
`id`	String	PK
`admin_id`	Long	FK
`android_app_name`	String
`android_app_version`	String
`android_device`	String
`android_last_seen_at`	Instant
`android_os_version`	String
`android_sdk_version`	String
`avatar`	String
`browser`	String
`browser_language`	String
`browser_version`	String
`created_at`	Instant
`email`	String
`enabled_push_messaging`	Boolean
`external_id`	String
`formatted_phone`	String
`has_hard_bounced`	Boolean
`ios_app_name`	String
`ios_app_version`	String
`ios_device`	String
`ios_last_seen_at`	Instant
`ios_os_version`	String
`ios_sdk_version`	String
`language_override`	String
`last_contacted_at`	Instant
`last_email_clicked_at`	Instant
`last_email_opened_at`	Instant
`last_replied_at`	Instant
`last_seen_at`	Instant
`location_city`	String
`location_country`	String
`location_region`	String
`marked_email_as_spam`	Boolean
`name`	String
`os`	String
`phone`	String
`referrer`	String
`role`	String
`signed_up_at`	Instant
`unsubscribed_from_emails`	Boolean
`updated_at`	Instant
`utm_campaign`	String
`utm_content`	String
`utm_medium`	String
`utm_source`	String
`utm_term`	String
`workspace_id`	String

contact_social_profile_history

Column	Type	Keys
`name`	String	PK
`user_id`	String	PKFK
`user_updated_at`	Instant	FK
`url`	String

news_item_reaction_history

Column	Type	Keys
`value`	String	PK
`news_item_id`	String	PKFK

tag

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

call

Column	Type	Keys
`id`	Long	PK
`admin_id`	String	FK
`contact_id`	String	FK
`conversation_id`	String	FK
`answered_at`	Instant
`call_type`	String
`created_at`	Instant
`direction`	String
`ended_at`	Instant
`ended_reason`	String
`fin_recording_url`	String
`fin_transcription_url`	String
`initiated_at`	Instant
`phone`	String
`recording_url`	String
`state`	String
`transcript_status`	String
`transcription_url`	String
`type`	String
`updated_at`	Instant

team_admin

Column	Type	Keys
`admin_id`	String	PKFK
`team_id`	String	PKFK

data_attribute_option

Column	Type	Keys
`value`	String	PK
`data_attribute_model`	String	PKFK
`data_attribute_name`	String	PKFK

ticket_state

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`category`	String
`external_label`	String
`internal_label`	String
`type`	String

segment

Column	Type	Keys
`id`	String	PK
`count`	Int
`created_at`	Instant
`name`	String
`person_type`	String
`type`	String
`updated_at`	Instant

series_disengagement

Column	Type	Keys
`disengaged_at`	Instant	PK
`receipt_id`	Long	PKFK
`disengaged_node_ruleset_id`	String

team_admin_priority_level

Column	Type	Keys
`admin_id`	String	PKFK
`team_id`	String	PKFK
`priority`	String

data_attribute

Column	Type	Keys
`model`	String	PK
`name`	String	PK
`admin_id`	String	FK
`api_writable`	Boolean
`archived`	Boolean
`created_at`	Instant
`custom`	Boolean
`data_type`	String
`description`	String
`full_name`	String
`id`	String
`label`	String
`messenger_writable`	Boolean
`type`	String
`ui_writable`	Boolean
`updated_at`	Instant

subscription_type

Column	Type	Keys
`id`	String	PK
`consent_type`	String
`default_translation_description`	String
`default_translation_locale`	String
`default_translation_name`	String
`state`	String
`type`	String

ticket_history

Column	Type	Keys
`id`	String	PKFK
`ticket_state_id`	String	FK
`ticket_type_id`	String	FK
`admin_assignee_id`	String
`category`	String
`created_at`	Instant
`is_shared`	Boolean
`linked_objects_has_more`	Boolean
`linked_objects_total_count`	Long
`open`	Boolean
`snoozed_until`	Instant
`team_assignee_id`	String
`ticket_id`	String
`ticket_parts_total_count`	Long
`ticket_state`	String
`ticket_state_external_label`	String
`ticket_state_internal_label`	String
`type`	String
`updated_at`	Instant

conversation_part_tag_history

Column	Type	Keys
`conversation_part_id`	String	PKFK
`tag_id`	String	PKFK
`conversation_part_updated_at`	Instant	FK