SQLite Web: app.db

id

Primary key. INTEGER

chatbot_id

INTEGER NOT NULL

conversation_id

INTEGER NOT NULL

user_id

TEXT NOT NULL

reason

TEXT NOT NULL

user_name

TEXT

user_email

TEXT

user_phone

TEXT

conversation_messages

[{"type": "bot", "content": "Le dimanche, le cabinet est ferm\u00e9."}, {"type": "bot", "content": "Souhaitez-vous un rendez-vous pour le d\u00e9tartrage \u00e0 une date ou heure pr\u00e9cise ?"}, {"type": "user", "content": "How long is the service for ?"}, {"type": "bot", "content": "The appointment usually lasts between 30 and 45 minutes, but it can vary depending on your case. If you have any special requests or concerns, let me know!"}, {"type": "user", "content": "<reply_to>Bonjour \r\n*KHAWLAH Zaman*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 11 juin 2026* \u00e0 *10:00* .\r\nEn cas d'emp\u00eachement, veuillez con...</reply_to> Ok can i do 10am please on this day please."}, {"type": "bot", "content": "Thank you for confirming!"}, {"type": "bot", "content": "Your request for Thursday, June 11, 2026, at 10:00 AM for Khawlah Zaman has been received."}, {"type": "bot", "content": "The team will contact you directly to confirm your appointment."}, {"type": "bot", "content": "Please note: your appointment will only be confirmed after our team contacts you directly \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Ok"}, {"type": "bot", "content": "Merci pour votre retour ! L\u2019\u00e9quipe va vous contacter prochainement pour la confirmation. Si vous avez d\u2019autres questions, n\u2019h\u00e9sitez pas \ud83d\ude0a"}, {"type": "user", "content": "Sorry i mean june 12th"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

lead_source

TEXT

lead_source_id

TEXT

app.db — notifications

Update row 617 in notifications