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": "Si vous avez besoin de modifier ou d\u2019annuler, n\u2019h\u00e9sitez pas \u00e0 contacter la r\u00e9ception au 06 60 02 22 63."}, {"type": "bot", "content": "\u00c0 bient\u00f4t \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 !"}, {"type": "user", "content": "D'accord  inchaalah"}, {"type": "bot", "content": "\u0628\u0627\u0631\u0643 \u0627\u0644\u0644\u0647 \u0641\u064a\u0643 Sanae\u060c \u0639\u0644\u0649 \u0627\u0644\u0631\u062d\u0628 \u0648\u0627\u0644\u0633\u0639\u0629 \ud83d\ude0a \u0625\u0630\u0627 \u0627\u062d\u062a\u062c\u062a\u064a \u0623\u064a \u0645\u0633\u0627\u0639\u062f\u0629 \u0623\u062e\u0631\u0649\u060c \u0623\u0646\u0627 \u0647\u0646\u0627. \u0646\u062a\u0645\u0646\u0649 \u0644\u064a\u0643 \u064a\u0648\u0645 \u062c\u0645\u064a\u0644 \u0648\u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \u064a\u0643\u0648\u0646 \u0643\u0644 \u0634\u064a\u0621 \u0628\u062e\u064a\u0631!"}, {"type": "user", "content": "[voice]"}, {"type": "bot", "content": "\u0634\u0643\u0631\u0627 Sanae \u0639\u0644\u0649 \u0627\u0644\u062a\u0648\u0636\u064a\u062d. \u063a\u0627\u062f\u064a \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u0627\u0644\u0637\u0628\u064a \u062f\u064a\u0627\u0644\u0646\u0627 \u0628\u062e\u0635\u0648\u0635 \u0627\u0644\u0645\u0634\u0643\u0644 \u062f\u064a\u0627\u0644 \u0627\u0644\u0633\u0644\u0643 \u0627\u0644\u0644\u064a \u062e\u0627\u0631\u062c \u0641\u0640 les bagues \u0644\u062a\u062d\u062a \u0648\u0643\u064a\u062f\u064a\u0631 \u0644\u064a\u0643 \u0627\u0644\u0625\u0632\u0639\u0627\u062c\u060c \u0648\u063a\u0627\u062f\u064a \u064a\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0645\u0639\u0627\u0643 \u0641\u064a \u0623\u0642\u0631\u0628 \u0648\u0642\u062a \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \u0628\u0627\u0634 \u064a\u0644\u0642\u0627\u0648 \u0644\u0643 \u0627\u0644\u062d\u0644 \u0627\u0644\u0645\u0646\u0627\u0633\u0628 \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Le 16 mai fat wach bghiti tgouli le 23 mai??"}, {"type": "bot", "content": "[voice]"}, {"type": "bot", "content": "Bonjour \r\n*BENMASSAOUD Sanae*\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 23 mai 2026* \u00e0 *10: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 23 \u0645\u0627\u064a 2026* \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 *10: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": "Safi inchaalah"}, {"type": "bot", "content": "Bonjour \r\n*BENMASSAOUD Sanae*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 15 juin 2026* \u00e0 *11:00* .\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\u0623\u062b\u0646\u064a\u0646 15 \u064a\u0648\u0646\u064a\u0648 2026* \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 *11:00*  \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": "Salam 3afat ta7et lia wa7eda mn  douk les  brackets li rekebthom simana li fatet .chno 5asni ndir ?"}]

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