Data model

"CONTACT_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_id": TEXT 
  "app_user_id": TEXT 
  "classification_result": JSONB 
  "duplicated_from_id": UUID 
  "has_been_processed_as_new_conversation": BOOLEAN 
  "intercom_conversation_id": TEXT 
  "intercom_workspace_id": TEXT 
  "language": VARCHAR(255) 
  "legacy_conversation_context_app_id": TEXT 
  "legacy_conversation_context_id": UUID 
  "source_type": TEXT 
  "user_role": VARCHAR(255) 
}
"CONTACT_REQUEST_ASSIGNMENT_METADATA" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contact_request_id": UUID 
  "recommended_admin_id": TEXT 
  "reserved_for_automated_answers_review": BOOLEAN 
}
"CONTACT_REQUEST_IN_APP_CONTEXT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_version": TEXT 
  "contact_request_id": UUID 
  "device_brand": TEXT 
  "entry_point": VARCHAR(255) 
  "origin": VARCHAR(255) 
  "page": TEXT 
  "page_metadata": JSONB 
  "platform": VARCHAR(255) 
  "source": TEXT 
}
"CONTACT_REQUEST_INTERCOM_STATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "assigned_intercom_admin_id": TEXT 
  "assigned_intercom_inbox_id": TEXT 
  "contact_request_id": UUID 
  "last_admin_reply_at": DATETIME 
  "last_inbox_assignment_by": TEXT 
  "last_member_notified_at": DATETIME 
  "last_user_reply_at": DATETIME 
  "started_at": DATETIME 
  "state": TEXT 
  "waiting_since": DATETIME 
}
"CONTACT_REQUEST_TAG" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contact_request_id": UUID 
  "intercom_tag_id": TEXT 
  "name": TEXT 
  "notified_at": DATETIME 
}
"CONVERSATION_PART" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contact_request_id": UUID 
  "document_ids": ARRAY 
  "has_sent_satisfaction_question": BOOLEAN 
  "is_satisfied": BOOLEAN 
  "message": JSONB 
  "message_type": VARCHAR(255) 
  "navigation_info": JSONB 
  "voice_message_id": UUID 
}
"SUPPORT_AGENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_email": TEXT 
  "alan_employee_app_id": TEXT 
  "alan_employee_id": TEXT 
  "ino_agent_id": INTEGER 
  "intercom_admin_id": TEXT 
  "is_deleted": BOOLEAN 
  "is_external_admin": BOOLEAN 
  "platform_name": TEXT 
  "spoken_languages": ARRAY 
  "work_location": VARCHAR(255) 
}
"SUPPORT_AGENT_WORKSPACE_AFFECTATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "intercom_workspace_id": TEXT 
  "is_active": BOOLEAN 
  "is_assigner_enabled": BOOLEAN 
  "level": INTEGER 
  "roles": ARRAY 
  "support_agent_id": UUID 
}
"SUPPORT_SPECIALIZATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "display_order": INTEGER 
  "intercom_inbox_id": TEXT 
  "intercom_inbox_name": TEXT 
  "intercom_workspace_id": TEXT 
  "is_used_by_assigner": BOOLEAN 
  "is_used_for_rejection": BOOLEAN 
  "should_validate_tags_on_close": BOOLEAN 
  "soft_deleted": BOOLEAN 
}
"SUPPORT_AGENT_SPE_MATCHING_SCORE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "score": FLOAT 
  "support_agent_workspace_affectation_id": UUID 
  "support_specialization_id": UUID 
}
"SUPPORT_CSAT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "comment": TEXT 
  "contact_request_id": UUID 
  "csat_id": VARCHAR 
  "member_reply_at": DATETIME 
  "rating": INTEGER 
  "status": VARCHAR(255) 
  "support_agent_id": UUID 
  "survey_sent_at": DATETIME 
  "survey_updated_at": DATETIME 
}
"SUPPORT_FEATURE_CONFIGURATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "configuration": JSONB 
  "feature_name": VARCHAR(255) 
}
"SUPPORT_IN_APP_NOTIFICATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_user_id": TEXT 
  "clicked_at": DATETIME 
  "conversation_id": TEXT 
  "dismissed_at": DATETIME 
  "type": VARCHAR(255) 
  "user_role": VARCHAR(255) 
  "viewed_at": DATETIME 
}
"SUPPORT_VOICE_MESSAGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "archived_at": DATETIME 
  "contact_request_id": UUID 
  "source_type": VARCHAR 
  "uri": VARCHAR(2083) 
}
"assigner"."ASSIGNER_CONFIGURATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_id": TEXT 
  "assigner_configuration_data": JSONB 
  "intercom_workspace_id": TEXT 
  "rejection_configuration_data": JSONB 
}
"assigner"."ASSIGNER_RECALIBRATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_email": TEXT 
  "app_id": TEXT 
  "intercom_workspace_id": TEXT 
}
"assigner"."CONTACT_REQUEST_ASSIGNMENT_EVENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "action": VARCHAR(255) 
  "assigner_result": JSONB 
  "assigner_results_for_audit": JSONB 
  "assignment_type": VARCHAR(255) 
  "comment": TEXT 
  "contact_request_id": UUID 
  "intercom_admin_id": TEXT 
  "reassigned_to_inbox_id": TEXT 
  "rejection_reason": VARCHAR(255) 
}
"automated_resolution"."AI_ASSISTANT_CONVERSATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "config_branch": VARCHAR(64) 
  "config_version": VARCHAR(64) 
  "contact_request_id": UUID 
  "does_member_satisfy_specialized_engine_rules": BOOLEAN 
  "escalation_channel": VARCHAR(255) 
  "escalation_reason": VARCHAR(255) 
  "is_assistant_activated_at_entry_point": BOOLEAN 
  "is_eligible_for_escalation_review": BOOLEAN 
  "is_escalated_by_assistant": BOOLEAN 
  "is_from_non_logged_in_entry_point": BOOLEAN 
  "is_intercom_conversation_created_from_command": BOOLEAN 
  "is_member_satisfied": BOOLEAN 
  "is_specialized_engine_open_at_entry_point": BOOLEAN 
  "is_specialized_engine_rolled_out_for_user": BOOLEAN 
  "specialized_agent": VARCHAR(255) 
  "state": VARCHAR(255) 
  "translation_map": JSONB 
  "unsatisfied_member_message": TEXT 
  "unsatisfied_member_voice_message_id": UUID 
}
"automated_resolution"."AI_ASSISTANT_REVIEW" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "ai_assistant_conversation_id": UUID 
  "end_time": DATETIME 
  "is_flagged_for_review": BOOLEAN 
  "review_output": JSONB 
  "review_type": VARCHAR(255) 
  "reviewed_by": TEXT 
  "start_time": DATETIME 
}
"automated_resolution"."MEMBER_ATTRIBUTES_SNAPSHOT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "agent_name": TEXT 
  "ai_assistant_conversation_id": UUID 
  "member_attributes": JSONB 
}
"automated_resolution"."SUPPORT_AI_AGENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contact_classes": ARRAY 
  "escalation_review_done_by": TEXT 
  "monitoring_review_percent": FLOAT 
  "name": VARCHAR(255) 
  "percentage_enabled": INTEGER 
}
"automated_resolution"."SUPPORT_AI_ENTRY_POINT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "deployment_rate": INTEGER 
  "entry_point": VARCHAR(255) 
  "origin": VARCHAR(255) 
}
"channel_management"."CUTOFF_PERIOD" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_name": TEXT 
  "applies_only_to_accounts": ARRAY 
  "applies_to_population": ARRAY 
  "description": TEXT 
  "end_at": DATETIME 
  "is_active": BOOLEAN 
  "priority": INTEGER 
  "soft_deleted_at": BOOLEAN 
  "start_at": DATETIME 
}
"channel_management"."CHANNEL_CUTOFF_CONFIGURATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "channel": VARCHAR(255) 
  "cutoff_period_id": UUID 
  "message": TEXT 
  "open": BOOLEAN 
}
"channel_management"."OPENING_HOURS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_name": TEXT 
  "applicable_timezone": TEXT 
  "applies_on_day": DATE 
  "banner_message": TEXT 
  "description": TEXT 
  "is_default": BOOLEAN 
  "schedule": JSONB 
}
"contact_request_insights"."CONTACT_REQUEST_INSIGHTS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "assistant_activity": JSONB 
  "automated_answer_task_finished_at": DATETIME 
  "contact_request_id": UUID 
  "doctor_ai_agent_task_id": UUID 
  "error_message": TEXT 
  "escalation_reason_enum": TEXT 
  "extracted_escalation_reason": JSONB 
  "finished_at": DATETIME 
  "member_intent": JSONB 
  "mood": JSONB 
  "next_actions": JSONB 
  "relevant_member_attributes": JSONB 
  "started_at": DATETIME 
  "status": VARCHAR(11) 
  "subject": JSONB 
}
"feedback"."FEEDBACK_CATEGORY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "available_in_app_ids": ARRAY 
  "default_content": TEXT 
  "description": TEXT 
  "intercom_labels": ARRAY 
  "is_care_oncall_thread_required": BOOLEAN 
  "is_enabled_for_externals": BOOLEAN 
  "is_linear_priority_required": BOOLEAN 
  "label": TEXT 
  "linear_label_ids": ARRAY 
  "linear_team_id": TEXT 
  "linear_template_id": TEXT 
  "parent_id": UUID 
  "report_on_tool": TEXT 
}
"legal_complaint_check"."LEGAL_COMPLAINT_CHECK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "agent_reply_quality_reasoning": TEXT 
  "agents_reply_quality": TEXT 
  "complaint_category": TEXT 
  "confidence_score": INTEGER 
  "config_branch": VARCHAR(64) 
  "config_version": VARCHAR(64) 
  "contact_request_id": UUID 
  "conversation_close_date": DATETIME 
  "detailed_reasoning": TEXT 
  "doctor_ai_agent_task_id": UUID 
  "doubts_or_ambiguity": TEXT 
  "identified_keywords": ARRAY 
  "is_complaint": BOOLEAN 
  "linear_card_short_code": TEXT 
  "title": TEXT 
  "topic": TEXT 
}
"phone_support"."CALLBACK_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "archived_at": DATETIME 
  "contact_request_id": UUID 
  "phone_number": VARCHAR 
  "recording_consent": BOOLEAN 
}
"phone_support"."CALLBACK_TIMESLOT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contact_request_id": UUID 
  "google_event_id": TEXT 
  "google_event_link": TEXT 
  "is_cancelled": BOOLEAN 
  "reminder_sent_at": DATETIME 
  "support_agent_id": UUID 
  "timeslot_end": DATETIME 
  "timeslot_start": DATETIME 
}
"phone_support"."CALLBACK_TIMESLOTS_SUGGESTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contact_request_id": UUID 
  "suggested_timeslots": JSONB 
  "support_agent_id": UUID 
}
"phone_support"."HOTLINE_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "archived_at": DATETIME 
  "contact_request_id": UUID 
  "phone_number": VARCHAR 
  "recording_consent": BOOLEAN 
}
"phone_support"."PHONE_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contact_request_id": UUID 
  "duration_in_seconds": INTEGER 
  "ino_interaction_id": TEXT 
  "ino_status": TEXT 
  "start": DATETIME 
  "support_agent_id": UUID 
}
"phone_support"."PHONE_CALL_RECORDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "archived_at": DATETIME 
  "phone_call_id": UUID 
  "uri": VARCHAR(2083) 
}
"phone_support"."PHONE_SUPPORT_CSAT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "comment": VARCHAR 
  "contact_request_id": UUID 
  "csat_id": VARCHAR 
  "phone_call_id": UUID 
  "rating": INTEGER 
}
"phone_support"."QUICK_CALLBACK_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "archived_at": DATETIME 
  "attempt_count": INTEGER 
  "contact_request_id": UUID 
  "ino_voice_campaign_target_id": VARCHAR(255) 
  "phone_number": VARCHAR 
  "recording_consent": BOOLEAN 
  "status": VARCHAR(255) 
}
"snooze"."SNOOZE_SEQUENCE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "cancel_on_event": TEXT 
  "cancel_on_event_metadata": JSONB 
  "cancel_reason": TEXT 
  "cancelled_at": DATETIME 
  "cancelled_on_event": TEXT 
  "contact_request_id": UUID 
  "is_cancelled": BOOLEAN 
  "legacy_snooze_sequence_id": UUID 
  "reply_language": TEXT 
  "support_agent_id": UUID 
  "template_name": TEXT 
  "used_template_id": TEXT 
  "used_template_type": VARCHAR(255) 
}
"snooze"."SNOOZE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "closed_at": DATETIME 
  "note_left_at": DATETIME 
  "on_unsnooze_close": BOOLEAN 
  "on_unsnooze_leave_note": TEXT 
  "on_unsnooze_reply_message": TEXT 
  "replied_at": DATETIME 
  "sequence_id": UUID 
  "snoozed_at": DATETIME 
  "snoozed_until": DATETIME 
  "target_time_string": TEXT 
  "unsnoozed_at": DATETIME 
}
"snooze"."SHARED_SNOOZE_TEMPLATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "display_order": INTEGER 
  "filters": JSONB 
  "is_active": BOOLEAN 
  "restricted_to_platforms": ARRAY 
  "snoozes": JSONB 
  "template_name": JSONB 
  "workspace_names": ARRAY 
}
"CONTACT_REQUEST"."id" -> "CONTACT_REQUEST"."duplicated_from_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "CONTACT_REQUEST_ASSIGNMENT_METADATA"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "CONTACT_REQUEST_IN_APP_CONTEXT"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "CONTACT_REQUEST_INTERCOM_STATE"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "CONTACT_REQUEST_TAG"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "CONVERSATION_PART"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SUPPORT_AGENT"."id" -> "SUPPORT_AGENT_WORKSPACE_AFFECTATION"."support_agent_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SUPPORT_SPECIALIZATION"."id" -> "SUPPORT_AGENT_SPE_MATCHING_SCORE"."support_specialization_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SUPPORT_AGENT_WORKSPACE_AFFECTATION"."id" -> "SUPPORT_AGENT_SPE_MATCHING_SCORE"."support_agent_workspace_affectation_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "SUPPORT_CSAT"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"SUPPORT_AGENT"."id" -> "SUPPORT_CSAT"."support_agent_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "SUPPORT_VOICE_MESSAGE"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "assigner"."CONTACT_REQUEST_ASSIGNMENT_EVENT"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "automated_resolution"."AI_ASSISTANT_CONVERSATION"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"automated_resolution"."AI_ASSISTANT_CONVERSATION"."id" -> "automated_resolution"."AI_ASSISTANT_REVIEW"."ai_assistant_conversation_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"automated_resolution"."AI_ASSISTANT_CONVERSATION"."id" -> "automated_resolution"."MEMBER_ATTRIBUTES_SNAPSHOT"."ai_assistant_conversation_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"channel_management"."CUTOFF_PERIOD"."id" -> "channel_management"."CHANNEL_CUTOFF_CONFIGURATION"."cutoff_period_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "contact_request_insights"."CONTACT_REQUEST_INSIGHTS"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"feedback"."FEEDBACK_CATEGORY"."id" -> "feedback"."FEEDBACK_CATEGORY"."parent_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "legal_complaint_check"."LEGAL_COMPLAINT_CHECK"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "phone_support"."CALLBACK_REQUEST"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"SUPPORT_AGENT"."id" -> "phone_support"."CALLBACK_TIMESLOT"."support_agent_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "phone_support"."CALLBACK_TIMESLOT"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SUPPORT_AGENT"."id" -> "phone_support"."CALLBACK_TIMESLOTS_SUGGESTION"."support_agent_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "phone_support"."CALLBACK_TIMESLOTS_SUGGESTION"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "phone_support"."HOTLINE_CALL"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "phone_support"."PHONE_CALL"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SUPPORT_AGENT"."id" -> "phone_support"."PHONE_CALL"."support_agent_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"phone_support"."PHONE_CALL"."id" -> "phone_support"."PHONE_CALL_RECORDING"."phone_call_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"phone_support"."PHONE_CALL"."id" -> "phone_support"."PHONE_SUPPORT_CSAT"."phone_call_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "phone_support"."PHONE_SUPPORT_CSAT"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"CONTACT_REQUEST"."id" -> "phone_support"."QUICK_CALLBACK_REQUEST"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "snooze"."SNOOZE_SEQUENCE"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SUPPORT_AGENT"."id" -> "snooze"."SNOOZE_SEQUENCE"."support_agent_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"snooze"."SNOOZE_SEQUENCE"."id" -> "snooze"."SNOOZE"."sequence_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

Hold "Alt" / "Option" to enable pan & zoom