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 
  "legacy_conversation_context_app_id": TEXT 
  "legacy_conversation_context_id": UUID 
  "source_type": TEXT 
}
"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_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_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 
}
"SUPPORT_AGENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_email": TEXT 
  "alan_employee_app_id": TEXT 
  "alan_employee_id": TEXT 
  "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 
  "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_VOICE_MESSAGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "archived_at": DATETIME 
  "contact_request_id": UUID 
  "source_id": VARCHAR 
  "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 
}
"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) 
}
"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 
}
"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 
  "contact_request_id": UUID 
  "ino_voice_campaign_target_id": VARCHAR(255) 
  "phone_number": VARCHAR 
  "recording_consent": BOOLEAN 
  "status": VARCHAR(255) 
}
"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_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
}
"SUPPORT_AGENT"."id" -> "SUPPORT_AGENT_WORKSPACE_AFFECTATION"."support_agent_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
}
"SUPPORT_SPECIALIZATION"."id" -> "SUPPORT_AGENT_SPE_MATCHING_SCORE"."support_specialization_id": {
  source-arrowhead.shape: cf-one-required
  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
}
"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" -> "phone_support"."CALLBACK_REQUEST"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"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_TIMESLOT"."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
}
"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"."HOTLINE_CALL"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"SUPPORT_AGENT"."id" -> "phone_support"."PHONE_CALL"."support_agent_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CONTACT_REQUEST"."id" -> "phone_support"."PHONE_CALL"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  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
}
"CONTACT_REQUEST"."id" -> "phone_support"."PHONE_SUPPORT_CSAT"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"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"."QUICK_CALLBACK_REQUEST"."contact_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}

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