Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: wa_blast
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:
1
wa_blast
{"j_tabs":{"wa_blast.agents":1,"wa_blast.ai_forms":1,"wa_blast.ai_form_sessions":1,"wa_blast.ai_form_submissions":1,"wa_blast.ai_turns":1,"wa_blast.app_settings":1,"wa_blast.auto_replies":1,"wa_blast.broadcasts":1,"wa_blast.broadcast_recipients":1,"wa_blast.chat_histories":1,"wa_blast.chat_labels":1,"wa_blast.closing_forms":1,"wa_blast.closing_records":1,"wa_blast.contacts":1,"wa_blast.contact_consents":1,"wa_blast.conversation_memories":1,"wa_blast.crawl_jobs":1,"wa_blast.crawl_pages":1,"wa_blast.cs_activity_logs":1,"wa_blast.flows":1,"wa_blast.flow_sessions":1,"wa_blast.follow_ups":1,"wa_blast.follow_up_enrollments":1,"wa_blast.follow_up_steps":1,"wa_blast.group_guard_configs":1,"wa_blast.group_moderation_logs":1,"wa_blast.handoffs":1,"wa_blast.inbox_read_states":1,"wa_blast.knowledges":1,"wa_blast.labels":1,"wa_blast.login_throttles":1,"wa_blast.meta_conversion_events":1,"wa_blast.opt_outs":1,"wa_blast.otp_codes":1,"wa_blast.products":1,"wa_blast.product_checkout_sessions":1,"wa_blast.product_orders":1,"wa_blast.scheduled_messages":1,"wa_blast.scheduled_statuses":1,"wa_blast.settings":1,"wa_blast.shipping_cities":1,"wa_blast.templates":1,"wa_blast.tenants":1,"wa_blast.users":1,"wa_blast.user_agent_assignments":1},"h_tabs":{"wa_blast.agents":1,"wa_blast.ai_forms":1,"wa_blast.ai_form_sessions":1,"wa_blast.ai_form_submissions":1,"wa_blast.ai_turns":1,"wa_blast.app_settings":1,"wa_blast.auto_replies":1,"wa_blast.broadcasts":1,"wa_blast.broadcast_recipients":1,"wa_blast.chat_histories":1,"wa_blast.chat_labels":1,"wa_blast.closing_forms":1,"wa_blast.closing_records":1,"wa_blast.contacts":1,"wa_blast.contact_consents":1,"wa_blast.conversation_memories":1,"wa_blast.crawl_jobs":1,"wa_blast.crawl_pages":1,"wa_blast.cs_activity_logs":1,"wa_blast.flows":1,"wa_blast.flow_sessions":1,"wa_blast.follow_ups":1,"wa_blast.follow_up_enrollments":1,"wa_blast.follow_up_steps":1,"wa_blast.group_guard_configs":1,"wa_blast.group_moderation_logs":1,"wa_blast.handoffs":1,"wa_blast.inbox_read_states":1,"wa_blast.knowledges":1,"wa_blast.labels":1,"wa_blast.login_throttles":1,"wa_blast.meta_conversion_events":1,"wa_blast.opt_outs":1,"wa_blast.otp_codes":1,"wa_blast.products":1,"wa_blast.product_checkout_sessions":1,"wa_blast.product_orders":1,"wa_blast.scheduled_messages":1,"wa_blast.scheduled_statuses":1,"wa_blast.settings":1,"wa_blast.shipping_cities":1,"wa_blast.templates":1,"wa_blast.tenants":1,"wa_blast.users":1,"wa_blast.user_agent_assignments":1}}
[{"":{"wa_blast.ai_form_submissions":{"form_id":["wa_blast.ai_forms","id"]}}},{"":{"wa_blast.product_orders":{"product_id":["wa_blast.products","id"]}}}]
[]
-1
1
Untitled *
vShow/Hide tables list View in fullscreen New page Open page Save page Save page as Delete pages Create table Create relation Choose column to display Reload Help Angular links / Direct links Snap to grid vSmall/Big All Toggle small/big Toggle relation lines Export schema > Move Menu > Pin text
v wa_blast agents
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*name : longtext
*system_prompt : text
*tone : varchar(191)
*ai_enabled : tinyint(1)
*auto_read : tinyint(1)
*ai_reply_delay_min : bigint(20)
*ai_reply_delay_max : bigint(20)
*device_j_id : longtext
*number : longtext
*greeting_enabled : tinyint(1)
*greeting_message : text
*business_hours_enabled : tinyint(1)
*business_start : varchar(5)
*business_end : varchar(5)
*away_message : text
*conversation_summary : text
*last_summary_at : datetime(3)
*spreadsheet_url : text
*spreadsheet_sheet_name : varchar(80)
*sheet_sync_enabled : tinyint(1)
*origin_city_id : bigint(20)
*origin_city_name : varchar(100)
*default_weight_gram : bigint(20)
*enabled_couriers : varchar(100)
*api_key : varchar(80)
*webhook_url : text
*webhook_secret : varchar(80)
*created_at : datetime(3)
v wa_blast ai_forms
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*name : varchar(160)
*goal : text
*intent_hints_json : text
*steps_json : text
*enabled : tinyint(1)
*handoff : tinyint(1)
*success_message : text
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast ai_form_sessions
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*form_id : bigint(20) unsigned
*step_index : bigint(20)
*data_json : text
*status : varchar(24)
*expires_at : datetime(3)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast ai_form_submissions
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*form_id : bigint(20) unsigned
*sender : varchar(32)
*code : varchar(32)
*status : varchar(24)
*data_json : text
*summary : text
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast ai_turns
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*user_message : text
*ai_reply : text
*model : varchar(80)
*prompt_version : varchar(40)
*knowledge_used_count : bigint(20)
*knowledge_ids : varchar(255)
*top_similarity : double
*answer_overlap : double
*product_used_count : bigint(20)
*product_ids : varchar(255)
*retrieval_mode : varchar(24)
*retrieval_query : text
*grounding_retried : tinyint(1)
*grounding_fallback : tinyint(1)
*response_policy : varchar(24)
*response_retried : tinyint(1)
*response_chars : bigint(20)
*used_shipping_tool : tinyint(1)
*escalated : tinyint(1)
*error : text
*latency_ms : bigint(20)
*created_at : datetime(3)
v wa_blast app_settings
*key : varchar(64)
*value : text
v wa_blast auto_replies
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*keywords : text
*match_type : varchar(16)
*reply : text
*enabled : tinyint(1)
*sort_order : bigint(20)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast broadcasts
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*agent_ids : text
*quarantine_json : text
*message : text
*product_id : bigint(20) unsigned
*product_buttons_json : text
*target_type : varchar(16)
*status : varchar(16)
*pause_reason : varchar(48)
*pause_code : bigint(20)
*paused_at : datetime(3)
*consent_category : varchar(32)
*consent_source : varchar(48)
*risk_level : varchar(16)
*risk_reasons : text
*risk_acknowledged : tinyint(1)
*override_reason : text
*override_by : bigint(20) unsigned
*override_at : datetime(3)
*min_delay : bigint(20)
*max_delay : bigint(20)
*rest_every : bigint(20)
*rest_duration : bigint(20)
*media_type : varchar(16)
*media_path : longtext
*file_name : longtext
*mimetype : longtext
*contact_name : varchar(120)
*contact_number : varchar(32)
*total : bigint(20)
*sent : bigint(20)
*failed : bigint(20)
*skipped : bigint(20)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast broadcast_recipients
*id : bigint(20) unsigned
*broadcast_id : bigint(20) unsigned
*number : varchar(64)
*name : longtext
*agent_id : bigint(20) unsigned
*status : varchar(16)
*error : longtext
*sent_at : datetime(3)
v wa_blast chat_histories
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*message : longtext
*reply : longtext
*from_human : tinyint(1)
*media_type : varchar(16)
*media_path : longtext
*media_metadata : blob
*media_fetch_status : varchar(24)
*file_name : longtext
*mimetype : longtext
*image_analysis : text
*image_analysis_status : varchar(24)
*image_analysis_model : varchar(120)
*image_analysis_confidence : double
*image_analysis_answer : text
*image_analysis_product_id : bigint(20) unsigned
*image_analysis_needs_human : tinyint(1)
*wa_msg_id : varchar(64)
*reply_to : longtext
*reply_text : varchar(200)
*revoked : tinyint(1)
*delivery_status : varchar(24)
*send_error : text
*retry_count : bigint(20)
*next_retry_at : datetime(3)
*created_at : datetime(3)
v wa_blast chat_labels
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*label_id : varchar(64)
*sender : varchar(32)
v wa_blast closing_forms
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*schema_json : text
*enabled : tinyint(1)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast closing_records
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*status : varchar(20)
*confidence : double
*data_json : text
*raw_summary : text
*sheet_error : longtext
*idempotency_key : varchar(128)
*sheet_row : bigint(20)
*exported_at : datetime(3)
*created_at : datetime(3)
v wa_blast contacts
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*number : varchar(32)
*name : longtext
*notes : text
*tags : text
*lead_stage : varchar(24)
*lead_stage_source : varchar(24)
*lead_stage_reason : varchar(500)
*lead_stage_confidence : double
*lead_stage_locked : tinyint(1)
*lead_stage_analyzed_chat_id : bigint(20) unsigned
*lead_stage_updated_at : datetime(3)
*manual_pause_until : datetime(3)
*updated_at : datetime(3)
v wa_blast contact_consents
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*number : varchar(32)
*category : varchar(32)
*source : varchar(48)
*note : text
*granted_at : datetime(3)
*revoked_at : datetime(3)
*recorded_by : bigint(20) unsigned
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast conversation_memories
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*summary : text
*last_chat_id : bigint(20) unsigned
*last_summary_at : datetime(3)
*brief_json : text
*brief_chat_id : bigint(20) unsigned
*brief_at : datetime(3)
*updated_at : datetime(3)
v wa_blast crawl_jobs
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*root_url : text
*domain : varchar(255)
*status : varchar(16)
*pages_found : bigint(20)
*error : text
*persona_updated : tinyint(1)
*persona_error : text
*created_at : datetime(3)
*finished_at : datetime(3)
v wa_blast crawl_pages
*id : bigint(20) unsigned
*job_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*url : text
*title : text
*status : varchar(16)
*char_count : bigint(20)
*content : longtext
*error : text
*recommended : tinyint(1)
*recommend_score : bigint(20)
*recommend_tier : varchar(16)
*recommend_reason : varchar(400)
*trained_at : datetime(3)
*created_at : datetime(3)
v wa_blast cs_activity_logs
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*user_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*action : varchar(32)
*detail : varchar(500)
*created_at : datetime(3)
v wa_blast flows
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*enabled : tinyint(1)
*trigger : varchar(64)
*match_type : varchar(16)
*display_mode : varchar(16)
*structure : longtext
*delay_min : bigint(20)
*delay_max : bigint(20)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast flow_sessions
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*node_id : varchar(64)
*updated_at : datetime(3)
v wa_blast follow_ups
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*name : varchar(160)
*enabled : tinyint(1)
*stop_on_reply : tinyint(1)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast follow_up_enrollments
*id : bigint(20) unsigned
*follow_up_id : bigint(20) unsigned
*number : varchar(32)
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*name : longtext
*enrolled_at : datetime(3)
*next_step : bigint(20)
*status : varchar(16)
*stopped_reason : varchar(32)
*last_sent_at : datetime(3)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast follow_up_steps
*id : bigint(20) unsigned
*follow_up_id : bigint(20) unsigned
*step_order : bigint(20)
*delay_hours : bigint(20)
*message : text
*ai_generated : tinyint(1)
*ai_instruction : text
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast group_guard_configs
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*group_jid : varchar(64)
*group_name : varchar(128)
*enabled : tinyint(1)
*delete_spam : tinyint(1)
*flag_for_kick : tinyint(1)
*auto_kick : tinyint(1)
*block_phones : tinyint(1)
*block_words : text
*flood_count : bigint(20)
*flood_window_sec : bigint(20)
*allow_numbers : text
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast group_moderation_logs
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*group_jid : varchar(64)
*group_name : varchar(128)
*sender : varchar(32)
*sender_jid : varchar(64)
*sender_name : varchar(128)
*wa_msg_id : varchar(64)
*action : varchar(16)
*reason : varchar(128)
*excerpt : varchar(280)
*status : varchar(16)
*acted_by : varchar(32)
*created_at : datetime(3)
v wa_blast handoffs
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*last_msg : text
*created_at : datetime(3)
v wa_blast inbox_read_states
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*last_read_at : datetime(3)
*updated_at : datetime(3)
*whats_app_unread_count : bigint(20)
*whats_app_synced : tinyint(1)
*whats_app_state_at : datetime(3)
v wa_blast knowledges
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*question : text
*answer : text
*tags : longtext
*embedding : longtext
*embedding_model : varchar(80)
*source : varchar(16)
*source_url : text
*char_count : bigint(20)
*active : tinyint(1)
*priority : bigint(20)
*verified_at : datetime(3)
*effective_from : datetime(3)
*effective_until : datetime(3)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast labels
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*label_id : varchar(64)
*name : longtext
*color : bigint(20)
*updated_at : datetime(3)
v wa_blast login_throttles
*id : bigint(20) unsigned
*key : varchar(255)
*failures : bigint(20)
*first_seen : datetime(3)
*locked_until : datetime(3)
*updated_at : datetime(3)
v wa_blast meta_conversion_events
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*event_id : varchar(100)
*event_name : varchar(48)
*event_time : datetime(3)
*source_url : text
*user_data_json : text
*custom_data_json : text
*status : varchar(16)
*attempts : bigint(20)
*next_attempt_at : datetime(3)
*last_error : text
*meta_response : text
*sent_at : datetime(3)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast opt_outs
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*created_at : datetime(3)
v wa_blast otp_codes
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*number : varchar(32)
*code_hash : varchar(64)
*expires_at : datetime(3)
*attempts : bigint(20)
*used : tinyint(1)
*created_at : datetime(3)
v wa_blast products
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*name : varchar(255)
*product_type : varchar(32)
*price : varchar(64)
*description : text
*details_json : text
*knowledge : text
*ai_sales_guidance : text
*image_path : varchar(512)
*image_mime : varchar(64)
*buttons_json : text
*checkout_steps_json : text
*checkout_handoff : tinyint(1)
*checkout_success_message : text
*embedding : longtext
*embedding_model : varchar(80)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast product_checkout_sessions
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*sender : varchar(32)
*product_id : bigint(20) unsigned
*step_index : bigint(20)
*data_json : text
*status : varchar(24)
*expires_at : datetime(3)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast product_orders
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*product_id : bigint(20) unsigned
*sender : varchar(32)
*order_code : varchar(32)
*status : varchar(24)
*data_json : text
*summary : text
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast scheduled_messages
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*run_at : datetime(3)
*message : text
*product_id : bigint(20) unsigned
*product_buttons_json : text
*recipients : longtext
*recipient_count : bigint(20)
*target_type : varchar(16)
*media_type : varchar(16)
*media_path : longtext
*file_name : longtext
*mimetype : longtext
*min_delay : bigint(20)
*max_delay : bigint(20)
*rest_every : bigint(20)
*rest_duration : bigint(20)
*status : varchar(16)
*consent_category : varchar(32)
*consent_source : varchar(48)
*risk_level : varchar(16)
*risk_reasons : text
*risk_acknowledged : tinyint(1)
*override_reason : text
*override_by : bigint(20) unsigned
*override_at : datetime(3)
*broadcast_id : bigint(20) unsigned
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast scheduled_statuses
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*run_at : datetime(3)
*text : text
*media_type : varchar(16)
*media_path : longtext
*mimetype : longtext
*status : varchar(16)
*error : text
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast settings
*id : bigint(20) unsigned
*system_prompt : text
*ai_model : varchar(191)
*tone : varchar(191)
v wa_blast shipping_cities
*id : bigint(20) unsigned
*raja_ongkir_id : bigint(20)
*province : varchar(100)
*type : varchar(20)
*city_name : varchar(100)
*full_name : varchar(200)
*search_text : text
v wa_blast templates
*id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*title : varchar(120)
*body : text
*sort_order : bigint(20)
*media_type : varchar(24)
*media_path : longtext
*file_name : varchar(255)
*mimetype : varchar(120)
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast tenants
*id : bigint(20) unsigned
*name : longtext
*created_at : datetime(3)
*updated_at : datetime(3)
v wa_blast users
*id : bigint(20) unsigned
*username : varchar(64)
*password : longtext
*role : varchar(24)
*name : longtext
*email : varchar(255)
*email_verified : tinyint(1)
*email_verify_token : varchar(128)
*phone : varchar(32)
*tenant_id : bigint(20) unsigned
*is_super_admin : tinyint(1)
*active : tinyint(1)
*password_reset_token : varchar(128)
*password_reset_expiry : datetime(3)
v wa_blast user_agent_assignments
*id : bigint(20) unsigned
*tenant_id : bigint(20) unsigned
*user_id : bigint(20) unsigned
*agent_id : bigint(20) unsigned
*created_at : datetime(3)