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": "\u0623\u0633\u0627\u0645\u0629 \u0628\u0646\u0645\u0627\u0644\u0643"}, {"type": "bot", "content": "\u0634\u0643\u0631\u0627 \u0623\u0633\u0627\u0645\u0629 \ud83d\ude0a \u0634\u0646\u0648 \u0646\u0648\u0639 \u0627\u0644\u0639\u0644\u0627\u062c \u0627\u0644\u0644\u064a \u0645\u062d\u062a\u0627\u062c\u0647\u061f \u0648\u0648\u0627\u0634 \u0643\u0627\u064a\u0646 \u0634\u064a \u0648\u0642\u062a \u0645\u062d\u062f\u062f \u0627\u0644\u0633\u0628\u062a \u0627\u0644\u0644\u064a \u0643\u064a\u0646\u0627\u0633\u0628\u0643\u061f"}, {"type": "user", "content": "\u0627\u0644\u0635\u0628\u0627\u062d \u0625\u0644\u0649 \u0643\u0627\u0646 \u0645\u0645\u0643\u0646"}, {"type": "bot", "content": "\u062a\u0645 \u062a\u0633\u062c\u064a\u0644 \u0637\u0644\u0628\u0643\u060c \u0623\u0633\u0627\u0645\u0629 \ud83d\ude0a \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 \u0639\u0644\u0649 \u062d\u0633\u0627\u0628 les disponibilit\u00e9s. \u0648\u0627\u0634 \u0647\u0627\u062f \u0627\u0644\u0631\u0642\u0645 \u0627\u0644\u0644\u064a \u0643\u062a\u0647\u0636\u0631\u0648 \u0628\u0647 \u0647\u0648 \u0627\u0644\u0644\u064a \u0643\u064a\u062a\u0627\u0635\u0644\u0648\u0627 \u0628\u0647 \u0645\u0639\u0627\u0643\u061f"}, {"type": "user", "content": "Yes \ud83d\udc4d\ud83c\udffb"}, {"type": "bot", "content": "\u0628\u0627\u0631\u0643 \u0627\u0644\u0644\u0647 \u0641\u064a\u0643\u060c \u063a\u0627\u062f\u064a \u064a\u062a\u0627\u0635\u0644\u0648\u0627 \u0628\u064a\u0643 \u0642\u0631\u064a\u0628\u0627 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \ud83d\ude0a \u0625\u0630\u0627 \u0643\u0627\u0646 \u0639\u0646\u062f\u0643 \u0623\u064a \u0633\u0624\u0627\u0644 \u0622\u062e\u0631\u060c \u0645\u0631\u062d\u0628\u0627 \u0628\u0643!"}, {"type": "bot", "content": "[image]"}, {"type": "bot", "content": "Bonjour BENMALEK OUSSAMA\r\nVous avez Rendez Vous avec Dr DINANI Hicham le samedi 11 avril 2026 \u00e0 12:00 .\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\u0633\u0628\u062a 11 \u0623\u0628\u0631\u064a\u0644 2026 \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 12:00. \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": "bot", "content": "[image]"}, {"type": "bot", "content": "[image]"}, {"type": "user", "content": "Bonjour"}, {"type": "user", "content": "Je veux reporter mon rendez-vous pour le samedi prochain"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 255 in notifications