Create
Query
app.db
—
notifications
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 500 in notifications
id
Primary key.
INTEGER
chatbot_id
INTEGER NOT NULL
conversation_id
INTEGER NOT NULL
user_id
212661151280
TEXT NOT NULL
reason
urgent_pain: demande d'aide urgente un dimanche (cabinet fermé) — patient souhaite être dépanné aujourd'hui
TEXT NOT NULL
user_name
NULL
TEXT
user_email
NULL
TEXT
user_phone
212661151280
TEXT
conversation_messages
[{"type": "user", "content": "Bonjour localisation et num\u00e9ro de t\u00e9l\u00e9phone \nMerci"}, {"type": "bot", "content": "Bonjour \ud83d\ude0a\n\nNotre cabinet est situ\u00e9 \u00e0 Avenue Mohammed VI, R\u00e9sidence Borj Khalij Tanger 3, \u00e9tage 5, appartement num\u00e9ro 197, Tanger."}, {"type": "bot", "content": "Voici le lien Google Maps : \nhttps://maps.app.goo.gl/RCzcJXSXvgMzrRMFA\n\nNum\u00e9ro de t\u00e9l\u00e9phone : +212 660-022-263\n\nN\u2019h\u00e9sitez pas si vous avez d\u2019autres questions !"}, {"type": "user", "content": "Vous \u00eates ouvert aujourd'hui jusqu'\u00e0 quelle heure"}, {"type": "bot", "content": "Aujourd'hui c\u2019est dimanche, le cabinet est ferm\u00e9. Nous serons ouverts demain lundi \u00e0 partir de 09h00 jusqu\u2019\u00e0 19h00. Si vous souhaitez un rendez-vous, dites-le-moi !"}, {"type": "user", "content": "J ai besoin d \u00eatre d\u00e9panner aujourd'hui"}]
TEXT NOT NULL
status
pending
TEXT NOT NULL (default 'pending'
created_at
2026-05-24T12:53:18.899688
TEXT NOT NULL
resolved_at
NULL
TEXT
lead_source
whatsapp
TEXT
lead_source_id
212661151280
TEXT
Update
Cancel