Help Scout

Explore the interactive ERD

Table & Field Reference

customer_social_profile_history

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`customer_updated_at`	Instant	PKFK
`type`	String
`value`	String

customer_email_history

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`customer_updated_at`	Instant	PKFK
`type`	String
`value`	String

customer_phone_history

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`customer_updated_at`	Instant	PKFK
`type`	String
`value`	String

customer_chat_history

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`customer_updated_at`	Instant	PKFK
`type`	String
`value`	String

customer_website_history

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`customer_updated_at`	Instant	PKFK
`value`	String

customer_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`address_city`	String
`address_country`	String
`address_postal_code`	String
`address_state`	String
`age`	String
`background`	String
`created_at`	Instant
`first_name`	String
`gender`	String
`job_title`	String
`last_name`	String
`location`	String
`organization`	String
`photo_type`	String
`photo_url`	String
`custom_`

team_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`created_at`	Instant
`email`	String
`first_name`	String
`last_name`	String
`photo_url`	String
`role`	String
`timezone`	String

conversation_tag_history

Column	Type	Keys
`conversation_id`	Long	PKFK
`conversation_updated_at`	Instant	PKFK
`tag_id`	Long	PKFK

conversation_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`folder_id`	Long	FK
`mailbox_id`	Long	FK
`closed_at`	Instant
`closed_by`	Long
`created_at`	Instant
`customer_waiting_since_friendly`	String
`customer_waiting_since_latest_reply_from`	String
`customer_waiting_since_time`	Instant
`number`	Long
`preview`	String
`primary_customer_id`	Long
`source_type`	String
`source_via`	String
`state`	String
`status`	String
`subject`	String
`threads`	Long
`type`	String
`custom_`

mailbox_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`created_at`	Instant
`email`	String
`name`	String
`slug`	String

doc_report_popular_search

Column	Type	Keys
`index`	Unknown	PK
`doc_report_fivetran_id`	Unknown	PKFK
`count`	Unknown
`doc_report_end_date`	Unknown
`doc_report_start_date`	Unknown
`id`	Unknown
`result`	Unknown

doc_report_failed_search

Column	Type	Keys
`index`	Unknown	PK
`doc_report_fivetran_id`	Unknown	PKFK
`count`	Unknown
`doc_report_end_date`	Unknown
`doc_report_start_date`	Unknown
`id`	Unknown

doc_report_top_article

Column	Type	Keys
`index`	Unknown	PK
`doc_report_fivetran_id`	Unknown	PKFK
`collection_id`	Unknown
`count`	Unknown
`doc_report_end_date`	Unknown
`doc_report_start_date`	Unknown
`id`	Unknown
`name`	Unknown
`site_id`	Unknown

doc_report_top_category

Column	Type	Keys
`index`	Unknown	PK
`doc_report_fivetran_id`	Unknown	PKFK
`article`	Unknown
`count`	Unknown
`doc_report_end_date`	Unknown
`doc_report_start_date`	Unknown
`id`	Unknown
`name`	Unknown
`site_id`	Unknown

doc_report

Column	Type	Keys
`_fivetran_id`	String	PK
`browse_action`	Unknown
`doc_viewed_per_visit`	Unknown
`end_date`	Unknown
`failed_result`	Unknown
`found_an_answer_result`	Unknown
`search_action`	Unknown
`sent_an_email_result`	Unknown
`start_date`	Unknown
`visitor`	Unknown

tag_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`color`	String
`created_at`	Instant
`name`	String
`slug`	Unknown
`ticket_count`	Int

mailbox_folder_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`mailbox_id`	Long	PKFK
`active_count`	Long
`name`	String
`total_count`	Long
`type`	String
`user_id`	Long

team_user_history

Column	Type	Keys
`team_id`	Long	PKFK
`team_updated_at`	Instant	PKFK
`user_id`	Long	PKFK

mailbox_workflow_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`mailbox_id`	Long	PKFK
`created_at`	Instant
`name`	String
`orders`	Long
`status`	String
`type`	String

user_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`created_at`	Instant
`email`	String
`first_name`	String
`last_name`	String
`photo_url`	String
`role`	String
`timezone`	String

conversation_thread_attachment_history

Column	Type	Keys
`id`	Long	PK
`conversation_id`	Long	PKFK
`conversation_thread_id`	Long	PKFK
`conversation_updated_at`	Instant	PKFK
`filename`	String
`hash`	String
`height`	Long
`mime_type`	String
`size`	Long
`url`	String
`width`	Long

conversation_thread_bcc_history

Column	Type	Keys
`email`	String	PK
`conversation_id`	Long	PKFK
`conversation_thread_id`	Long	PKFK
`conversation_updated_at`	Instant	PKFK

conversation_thread_to_history

Column	Type	Keys
`email`	String	PK
`conversation_id`	Long	PKFK
`conversation_thread_id`	Long	PKFK
`conversation_updated_at`	Instant	PKFK

conversation_thread_cc_history

Column	Type	Keys
`email`	String	PK
`conversation_id`	Long	PKFK
`conversation_thread_id`	Long	PKFK
`conversation_updated_at`	Instant	PKFK

conversation_thread_history

Column	Type	Keys
`id`	Long	PK
`conversation_id`	Long	PKFK
`conversation_updated_at`	Instant	PKFK
`created_by_customer_id`	Long	FK
`created_by_user_id`	Long	FK
`action_text`	String
`action_type`	String
`assigned_to_id`	Long
`body`	String
`created_at`	Instant
`created_by_type`	String
`customer_id`	Long
`opened_at`	Instant
`saved_reply_id`	Long
`source_type`	String
`source_via`	String
`state`	String
`status`	String
`type`	String

happiness_rating

Column	Type	Keys
`conversation_id`	Long	PK
`rating_created_at`	Instant	PK
`rating_customer_id`	Long	PK
`number`	Long
`rating_comment`	String
`rating_customer_name`	String
`rating_id`	Long
`rating_user_id`	Long
`rating_user_name`	String
`thread_created_at`	Instant
`thread_id`	Long
`type`	String