Create
Query
app.db
—
messages
account_credits
api_keys
app_settings
automation_agent_handoffs
automation_runs
automation_whatsapp_r...
automations
bookings
bulk_campaigns
bulk_recipients
chatbot_collections
chatbot_eval_run_rows
chatbot_eval_runs
chatbot_instance_conn...
chatbot_tools
chatbot_usage
chatbot_user_assignments
chatbots
confirmed_orders
conversations
credit_transactions
evolution_instances
follow_up_classifications
follow_ups_sent
form_fields
form_submissions
form_submissions_dynamic
forms
google_calendar_conne...
google_oauth_pending
human_notification_stats
knowledge_base_documents
leads
media_files
message_handled_stats
messages
meta_connections
meta_oauth_states
notifications
phone_receptionists
presence_status
product_variants
products
smile_preview_embed_v...
smile_preview_generat...
smile_preview_jobs
smile_preview_leads
smile_preview_plans
smile_preview_settings
sqlite_sequence
training_review_items
users
variant_media
voice_agent_configs
voice_agent_instance_...
voice_agent_widget_co...
voice_call_history
whatsapp_meta_connections
whatsapp_meta_oauth_states
whatsapp_provider_pre...
whatsapp_routing_pref...
widget_connections
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 38178 in messages
id
Primary key.
INTEGER
conversation_id
INTEGER NOT NULL
message_id
3EB0ADE88BBCD0496B2C15
TEXT NOT NULL
sender
user
TEXT NOT NULL
message_type
text
TEXT NOT NULL (default 'text'
content
RAPPORT D'ACTIVITÉ QUOTIDIEN Date : 02/06/2026 Cabinet : Centre Dentaire El Ouazzani ───────────────── WHATSAPP ───────────────── ▸ Messages patients : 47 ▸ Messages internes : 3 ▸ Nouveaux contacts : 8 ▸ Patients de retour : 12 ───────────────── PAYS WHATSAPP ───────────────── ▸ Conversations WhatsApp actives : 16 ▸ Part du Maroc : 81.25% (13) ▸ Part à l'étranger : 18.75% (3) • 🇲🇦 Maroc : 13 (81.25%) • 🇫🇷 France : 2 (12.50%) • 🇧🇪 Belgique : 1 (6.25%) ───────────────── ALERTES & SUIVI ÉQUIPE ───────────────── ▸ Alertes envoyées : 6 ▸ Traitées par l'équipe : 4 ▸ En attente : 2 ───────────────── CAS EN ATTENTE (À TRAITER) ───────────────── • Fatima Zahra — 212661298555 • Youssef Benali — 212648181906 • amine — 33766648942
TEXT
media_url
NULL
TEXT
media_mime_type
NULL
TEXT
chatbot_id
INTEGER NOT NULL
created_at
2026-06-02T19:06:09.409006
TEXT NOT NULL
status
read
TEXT (default 'sent'
delivered_at
2026-06-02T19:06:16.886308
TEXT
read_at
2026-06-02T19:06:16.886308
TEXT
sender_user_id
NULL
TEXT
metadata
NULL
TEXT
Update
Cancel