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": "Bonjour \r\n*OUMMANY Doha*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *samedi 14 mars 2026* \u00e0 *13:30* .\r\nEn cas d'emp\u00eachement, veuillez contacter la r\u00e9ception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.\u0645\u0631\u062d\u0628\u064b\u0627\r\n**\r\n\u0644\u062f\u064a\u0643\u0645 \u0645\u0648\u0639\u062f \u0645\u0639 ** \u064a\u0648\u0645 *\u0627\u0644\u0633\u0628\u062a 14 \u0645\u0627\u0631\u0633 2026* \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 *13:30*  \ufbb6    \r\n\u0641\u064a \u062d\u0627\u0644\u0629 \u0648\u062c\u0648\u062f \u0639\u0627\u0626\u0642 \u064a\u0631\u062c\u0649 \u0627\u0644\u0627\u062a\u0635\u0627\u0644 \u0628\u0645\u0643\u062a\u0628 \u0627\u0644\u0627\u0633\u062a\u0642\u0628\u0627\u0644\r\n*060022263 / 0539948014*\r\n\u0634\u0643\u0631\u0627 \u0644\u062a\u0641\u0647\u0645\u0643\u0645"}, {"type": "user", "content": "Merci"}, {"type": "bot", "content": "[Image] Salut *OUMMANY Doha*\ud83d\udc4b\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center \ud83e\uddb7\r\n\r\n\ud83d\udcc5 Date : *samedi 14 mars 2026*\r\n\ud83d\udd58 Heure : *13:30*\r\n\ud83d\udccd Adresse : R\u00e9sidence Borj Khalij 3, \u00c9tage 5, App. 197 \u2013 Avenue Mohammed VI, Tanger (pr\u00e8s de Caf\u00e9 Sky17)\r\n\ud83d\udcde Pour toute question : 06 60 02 22 63\r\n\u2705 Merci de nous confirmer votre pr\u00e9sence en r\u00e9pondant \u00ab OUI \u00bb \u00e0 ce message\r\n\r\n\u26a0\ufe0f IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement consid\u00e9r\u00e9 comme annul\u00e9 automatiquement. \r\nMerci de votre compr\u00e9hension."}, {"type": "user", "content": "Oui merci"}, {"type": "bot", "content": "Bonjour \ud83d\ude0a Comment puis-je vous aider aujourd'hui au Centre Dentaire Tanger Bay ?"}, {"type": "bot", "content": "[Image]"}, {"type": "bot", "content": "[Image]"}, {"type": "bot", "content": "Kif ma9otlk lyoma 900 dh w avance f devis bach mli tji tjbar implant wajda inxaelah"}, {"type": "user", "content": "[Image] [Image analysis] Image description: - Summary: The image is a confirmation of a completed bank transfer from CIH Bank for an amount of 3100 Dirhams sent by Mademoiselle Doha Oummany to Haitham Boutaib.\n- Visible text: \n  - CIH BANK\n  - Virement ex\u00e9cut\u00e9\n  - 16-03-2026 - 11:06:29\n  - D'un montant de 3100 Dirhams\n  - De la part de MADEMOISELLE DOHA OUMMANY\n  - En faveur de HAITHAM BOUTAIB\n  - RIB : 230825260274221102940066\n  - Motif : Avance pr l'implant\n- Notable objects/entities: Bank logo, illustration of a person with mobile devices.\n\nUser message context: - Summary: The image displays a bank transfer confirmation from CIH Bank for 3100 Dirhams from Mademoiselle Doha Oummany to Haitham Boutaib, dated 16-03-2026. \n\n- OCR Text: \n  - \"CIH BANK\"\n  - \"Virement ex\u00e9cut\u00e9\"\n  - \"16-03-2026 - 11:06:29\"\n  - \"D'un montant de 3100 Dirhams\"\n  - \"De la part de MADEMOISELLE DOHA OUMMANY\"\n  - \"En faveur de HAITHAM BOUTAIB\"\n  - \"RIB : 230825260274221102940066\"\n  - \"Motif : Avance pr l'implant\"\n\n- Notable Objects/Entities: CIH Bank logo, illustration of a person with smartphones and cash."}, {"type": "user", "content": "Cest bn?"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 101 in notifications