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": "[image]"}, {"type": "bot", "content": "Bonjour \r\n*ALAIN JEAN Azar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 17 avril 2026* \u00e0 *16: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\u062c\u0645\u0639\u0629 17 \u0623\u0628\u0631\u064a\u0644 2026* \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 *16: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": "bot", "content": "[voice]"}, {"type": "user", "content": "Ok"}, {"type": "bot", "content": "Bonjour,\r\nNous esp\u00e9rons que vous allez bien. Nous voulions simplement nous assurer que tout se passe bien suite \u00e0 votre extraction et que vous ne ressentez pas de g\u00eane particuli\u00e8re.\r\nSi vous avez la moindre question ou inqui\u00e9tude, n\u2019h\u00e9sitez pas \u00e0 nous contacter.\r\nBon r\u00e9tablissement."}, {"type": "bot", "content": "Bonjour \r\n*ALAIN JEAN Azar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 28 avril 2026* \u00e0 *14: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\u062b\u0644\u0627\u062b\u0627\u0621 28 \u0623\u0628\u0631\u064a\u0644 2026* \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 *14: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": "bot", "content": "[voice]"}, {"type": "user", "content": "Salam \nJe quitte pour le S\u00e9n\u00e9gal \nDu 05 au 09/05/26"}, {"type": "bot", "content": "Ok"}, {"type": "user", "content": "Pour les dents \u00e7a va douloureux que je bois du chaud ou du froid mais \u00e7a va alhamdoulilah"}, {"type": "bot", "content": "Hamdolilah"}, {"type": "user", "content": "Bonjour \nNon malheureusement \nJe quitte demain soir pour le S\u00e9n\u00e9gal je serais de retour le 09/05/2026\nIl faut reporter au Lundi prochain"}]

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 332 in notifications