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": "user", "content": "Salam s\u2019il vous pla\u00eet je peux venir vendredi matin pour soins de dents ? \ud83d\ude4f\ud83c\udffb c\u2019est Asmae Bouhnane"}, {"type": "bot", "content": "\u0648\u0639\u0644\u064a\u0643\u0645 \u0627\u0644\u0633\u0644\u0627\u0645 \u0648\u0631\u062d\u0645\u0629 \u0627\u0644\u0644\u0647\u060c \u0645\u0631\u062d\u0628\u0627 \u0627\u0644\u0633\u064a\u062f\u0629 Asmae \ud83d\ude0a\n\n\u0628\u0627\u0634 \u0646\u062d\u062c\u0632\u0648 \u0644\u0643 \u0645\u0648\u0639\u062f \u062e\u0627\u0635\u0646\u0627 \u0646\u0639\u0631\u0641\u0648 \u0634\u0646\u0648 \u0646\u0648\u0639 \u0627\u0644\u0639\u0644\u0627\u062c \u0627\u0644\u0644\u064a \u0628\u063a\u064a\u062a\u064a \u0648 \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0644\u064a \u0643\u064a\u0646\u0627\u0633\u0628\u0643 \u0628\u0627\u0644\u0636\u0628\u0637. \u0627\u0644\u062c\u0645\u0639\u0629 \u0635\u0628\u0627\u062d\u0627 \u0643\u0646\u062e\u062f\u0645\u0648 \u0645\u0646 10:30 \u062d\u062a\u0649 16:30. \u0648\u0627\u0634 \u0643\u0627\u064a\u0646 \u0634\u064a \u0648\u0642\u062a \u0645\u062d\u062f\u062f \u0627\u0644\u0644\u064a \u0643\u064a\u0646\u0627\u0633\u0628\u0643\u061f \n\n\u063a\u0627\u062f\u064a \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u0648\u063a\u0627\u062f\u064a \u064a\u062a\u0627\u0635\u0644\u0648\u0627 \u0628\u064a\u0643 \u0628\u0627\u0634 \u064a\u0623\u0643\u062f\u0648 \u0627\u0644\u0645\u0648\u0639\u062f \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647."}, {"type": "user", "content": "Soins de dents (kyste dentaire)"}, {"type": "bot", "content": "\u062a\u0645 \u062a\u0633\u062c\u064a\u0644 \u0637\u0644\u0628\u0643\u060c \u0627\u0644\u0633\u064a\u062f\u0629 Asmae. \u0627\u0644\u0641\u0631\u064a\u0642 \u063a\u0627\u062f\u064a \u064a\u062a\u0627\u0635\u0644\u0648\u0627 \u0628\u064a\u0643 \u0628\u0627\u0634 \u064a\u0623\u0643\u062f\u0648 \u0627\u0644\u0645\u0648\u0639\u062f \u062f\u064a\u0627\u0644\u0643 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647. \u0634\u0643\u0631\u0627 \u0639\u0644\u0649 \u0627\u0644\u062b\u0642\u0629 \u062f\u064a\u0627\u0644\u0643 \u0648\u0646\u062a\u0645\u0646\u0649 \u0644\u0643 \u0646\u0647\u0627\u0631 \u0645\u0648\u0641\u0642! \ud83d\ude0a"}, {"type": "user", "content": "Merci \ud83d\ude4f\ud83c\udffb"}, {"type": "bot", "content": "\u0627\u0644\u0639\u0641\u0648 \u0645\u0631\u062d\u0628\u0627 \u0628\u064a\u0643 \u0627\u0644\u0633\u064a\u062f\u0629 Asmae! \ud83d\ude0a \u0625\u0630\u0627 \u0643\u0627\u0646 \u0639\u0646\u062f\u0643 \u0623\u064a \u0633\u0624\u0627\u0644 \u0622\u062e\u0631 \u0623\u0648 \u0627\u062d\u062a\u062c\u062a\u064a \u0634\u064a \u062d\u0627\u062c\u0629\u060c \u0631\u0647\u0646 \u0627\u0644\u0625\u0634\u0627\u0631\u0629 \u062f\u064a\u0627\u0644\u0643. \u0646\u0647\u0627\u0631\u0643 \u0645\u0628\u0631\u0648\u0643! \ud83d\ude4f\ud83c\udffb"}, {"type": "bot", "content": "SALAM ASMAE C BON INCHALLAH"}, {"type": "bot", "content": "VENDREDI MN  20.30 TAL 16.30 KHDAMIN CONTINUT DONC AJI WTSSNAY NOUBA DIALK"}, {"type": "user", "content": "Ok nchaallah"}, {"type": "user", "content": "merci"}, {"type": "bot", "content": "[Image] Bonjour Bouhnane Asmae\r\nVous avez Rendez Vous avec Dr DINANI Hicham le vendredi 13 mars 2026 \u00e0 10:45 .\r\nEn cas d'emp\u00eachement, veuillez contactre la r\u00e9ception pour prendre un autre Rendez Vous.\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 \u0627\u0644\u062f\u0643\u062a\u0648\u0631 \u062f\u064a\u0646\u0627\u0646\u064a \u0647\u0634\u0627\u0645 \u064a\u0648\u0645 \u0627\u0644\u062c\u0645\u0639\u0629 13 \u0645\u0627\u0631\u0633 2026 \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 10:45. \u0641\u064a \u062d\u0627\u0644\u0629 \u0648\u062c\u0648\u062f \u0639\u0627\u0626\u0642.\r\n\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 \u0644\u062a\u062d\u062f\u064a\u062f \u0645\u0648\u062c\u062f \u0622\u062e\u0631.\r\n\u0634\u0643\u0631\u0627 \u0644\u062a\u0641\u0647\u0645\u0643\u0645\r\n05 37 86 02 03"}, {"type": "user", "content": "Salam chaimae j\u2019esp\u00e8re que tu vas bien"}, {"type": "bot", "content": "\u0648\u0639\u0644\u064a\u0643\u0645 \u0627\u0644\u0633\u0644\u0627\u0645 \u0648\u0631\u062d\u0645\u0629 \u0627\u0644\u0644\u0647\u060c \u0645\u0631\u062d\u0628\u0627 \u0627\u0644\u0633\u064a\u062f\u0629 Chaimae! \u0643\u0646\u062a\u0645\u0646\u0627 \u062a\u0643\u0648\u0646\u064a \u0628\u062e\u064a\u0631 \u0648\u0639\u0644\u0649 \u062e\u064a\u0631. \u0643\u064a\u0641\u0627\u0634 \u0646\u0642\u062f\u0631 \u0646\u0639\u0627\u0648\u0646\u0643 \u0627\u0644\u064a\u0648\u0645\u061f \ud83d\ude0a"}, {"type": "user", "content": "Stp apr\u00e8s la premi\u00e8re s\u00e9ance de soin du kyste vendredi"}, {"type": "bot", "content": "\u0628\u0639\u062f \u0623\u0648\u0644 \u062c\u0644\u0633\u0629 \u0644\u0639\u0644\u0627\u062c \u0627\u0644\u0643\u064a\u0633 \u064a\u0648\u0645 \u0627\u0644\u062c\u0645\u0639\u0629\u060c \u0645\u0646 \u0627\u0644\u0645\u0647\u0645 \u062a\u0644\u062a\u0632\u0645\u064a \u0628\u062a\u0639\u0644\u064a\u0645\u0627\u062a \u0627\u0644\u062f\u0643\u062a\u0648\u0631 \u0648\u062a\u0627\u062e\u062f\u064a \u0627\u0644\u0623\u062f\u0648\u064a\u0629 \u0627\u0644\u0644\u064a \u063a\u0627\u062f\u064a \u064a\u0648\u0635\u064a \u0628\u0647\u0627. \u0625\u0630\u0627 \u0643\u0627\u0646 \u0639\u0646\u062f\u0643 \u0623\u064a \u0623\u0644\u0645 \u0623\u0648 \u0645\u0636\u0627\u0639\u0641\u0627\u062a\u060c \u0645\u0646 \u0627\u0644\u0623\u0641\u0636\u0644 \u062a\u062a\u0648\u0627\u0635\u0644\u064a \u0645\u0639 \u0627\u0644\u0639\u064a\u0627\u062f\u0629 \u0645\u0628\u0627\u0634\u0631\u0629. \n\n\u0648\u0627\u062e\u0627 \u062a\u0642\u0648\u0644\u064a \u0648\u0627\u0634 \u0643\u0627\u064a\u0646 \u0634\u064a \u062d\u0627\u062c\u0629 \u0623\u062e\u0631\u0649 \u0646\u0642\u062f\u0631 \u0646\u0639\u0627\u0648\u0646\u0643 \u0628\u0647\u0627\u061f \ud83d\ude0a"}, {"type": "user", "content": "<reply_to>\u0625\u0630\u0627 \u0643\u0627\u0646 \u0639\u0646\u062f\u0643 \u0623\u064a \u0623\u0644\u0645 \u0623\u0648 \u0645\u0636\u0627\u0639\u0641\u0627\u062a\u060c \u0645\u0646 \u0627\u0644\u0623\u0641\u0636\u0644 \u062a\u062a\u0648\u0627\u0635\u0644\u064a \u0645\u0639 \u0627\u0644\u0639\u064a\u0627\u062f\u0629 \u0645\u0628\u0627\u0634\u0631\u0629.</reply_to> Oui j\u2019ai un gonflement"}, {"type": "bot", "content": "Je suis d\u00e9sol\u00e9 d'apprendre cela. Il est important de contacter la clinique imm\u00e9diatement pour discuter de votre gonflement. Je vais informer l'\u00e9quipe pour qu'ils puissent vous appeler d\u00e8s que possible. \n\nPouvez-vous me confirmer si vous souhaitez que je les informe maintenant ?"}, {"type": "user", "content": "<reply_to>Pouvez-vous me confirmer si vous souhaitez que je les informe maintenant ?</reply_to> Oui stp"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 98 in notifications