Fivetran documentation

Search the docs

/

Ada

Explore the interactive ERD

Table & Field Reference

message_quick_reply

Column	Type	Keys
`index`	Unknown	PK
`message_id`	String	PKFK
`button_type`	String
`label`	String
`target`	String

message_select_table

Column	Type	Keys
`choose_prompt`	String	PK
`message_id`	String	PKFK

message_selected

Column	Type	Keys
`selected`	String	PK
`message_id`	String	PKFK

message

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	FK
`agent_info_default_image`	String
`agent_info_external_id`	String
`agent_info_image_url`	String
`agent_info_internal_id`	String
`agent_info_name`	String
`alt_text`	String
`amount`	Long
`answer_id`	String
`answer_title`	String
`body`	String
`button_type`	String
`by`	String
`chatter_id`	String
`date_created`	Instant
`event`	String
`external_chat_id`	String
`external_id`	String
`generate_link_preview`	Boolean
`has_forced_quick_replies`	Boolean
`has_variable`	Boolean
`header`	String
`in_response_to`	Unknown
`is_expired`	Boolean
`is_forced`	Boolean
`is_handoff`	Boolean
`is_positive`	Boolean
`link_description`	String
`link_icon`	String
`link_text`	String
`link_was_clicked`	Boolean
`locked`	Boolean
`meta_data_agent_id`	String
`meta_data_department_id`	String
`meta_data_display_name`	String
`meta_data_event_type`	String
`meta_data_id`	String
`meta_data_name`	String
`meta_data_new_value`	String
`meta_data_old_value`	String
`meta_data_response_id`	String
`meta_data_scope`	String
`meta_data_subtype`	String
`meta_data_triggered_by`	String
`meta_data_type`	String
`meta_message_type`	String
`multiple`	Boolean
`new_window`	Boolean
`pic_url`	String
`prompt`	String
`raw_url`	String
`recipient`	String
`record_last_updated`	Unknown
`review`	Long
`reviewable_message`	Boolean
`score`	Long
`sender`	String
`style`	String
`survey_type`	String
`temp_message_uuid`	String
`title`	String
`tos`	String
`type`	String
`unit`	String
`url`	String
`window_button_label`	String
`window_height`	Long
`window_title`	String
`window_url`	String
`window_width`	Long

conversation_feedback

Column	Type	Keys
`feedback_message`	String	PK
`conversation_id`	String	PKFK

conversation_classification_intent

Column	Type	Keys
`intent_id`	Unknown	PK
`conversation_classification_topic_id`	Unknown	PKFK
`conversation_id`	String	PKFK
`intent_name`	Unknown
`status`	Unknown

conversation_classification

Column	Type	Keys
`topic_id`	Unknown	PK
`conversation_id`	String	PKFK
`topic_name`	Unknown

conversation

Column	Type	Keys
`id`	String	PK
`agent_handle_time`	Unknown
`agent_id`	Json
`agent_name`	Json
`automated_resolution_classification`	Unknown
`automated_resolution_classification_reason`	Unknown
`bot_handle_time`	Unknown
`browser`	String
`browser_version`	String
`chatter_id`	String
`csat_ces_max`	Long
`csat_comment`	String
`csat_customer_effort_score`	Long
`csat_is_positive`	Boolean
`csat_net_promoter_score`	Long
`csat_resolved`	Boolean
`csat_score`	Unknown
`csat_style`	String
`csat_survey_type`	String
`date_created`	Instant
`date_updated`	Instant
`device`	Unknown
`end_user_id`	Unknown
`generated_topic_id`	Unknown
`generated_topic_label`	Unknown
`generated_topic_v_2_desc`	Unknown
`generated_topic_v_2_id`	Unknown
`generated_topic_v_2_parent_id`	Unknown
`generated_topic_v_2_title`	Unknown
`inquiry_summary`	Unknown
`is_engaged`	Boolean
`is_escalated`	Boolean
`is_test_user`	Boolean
`languages`	String
`oauth_channel`	Unknown
`platform`	String
`record_last_updated`	Instant
`metavariable_`
`variable_`