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": "\u0627\u0644\u0639\u0641\u0648 \u0645\u0631\u062d\u0628\u0627 \u0628\u064a\u0643 \ud83d\ude0a \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\u0648\u0645 \u0628\u0647\u0627\u061f"}, {"type": "user", "content": "[voice]"}, {"type": "bot", "content": "\u0648\u0627\u062e\u0627 \u062a\u0639\u0637\u064a\u0646\u064a \u0627\u0644\u0625\u0633\u0645 \u0627\u0644\u0643\u0627\u0645\u0644 \u062f\u064a\u0627\u0644\u0643\u061f"}, {"type": "user", "content": "[image]"}, {"type": "bot", "content": "\u0645\u0631\u062d\u0628\u0627 Imcharen Saad\u060c \u0634\u0643\u0631\u0627 \u0639\u0644\u0649 \u0627\u0644\u062a\u0648\u0636\u064a\u062d. \u0648\u0627\u0634 \u0628\u063a\u064a\u062a \u062a\u0644\u063a\u064a \u0623\u0648 \u062a\u0628\u062f\u0644 \u0627\u0644\u0645\u0648\u0639\u062f \u062f\u064a\u0627\u0644\u0643 \u0644\u064a \u0643\u0627\u0646 \u0646\u0647\u0627\u0631 \u0627\u0644\u0623\u0631\u0628\u0639\u0627\u0621 15 \u0623\u0628\u0631\u064a\u0644 2026 \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 11:30\u060c \u0648\u0644\u0627 \u0639\u0646\u062f\u0643 \u0633\u0624\u0627\u0644 \u0622\u062e\u0631 \u0628\u062e\u0635\u0648\u0635 \u0627\u0644\u0645\u0648\u0627\u0639\u064a\u062f\u061f"}, {"type": "user", "content": "<reply_to>[Audio Message]</reply_to> ."}, {"type": "bot", "content": "\u0643\u0646\u0639\u062a\u062f\u0631\u060c \u0645\u0641\u0647\u0645\u062a\u0634 \u0627\u0644\u0631\u0633\u0627\u0644\u0629 \u0627\u0644\u0635\u0648\u062a\u064a\u0629 \u0628\u0627\u0644\u0636\u0628\u0637. \u0648\u0627\u0634 \u062a\u0642\u062f\u0631 \u062a\u0648\u0636\u062d \u0644\u064a\u0627 \u0634\u0646\u0648 \u0642\u0635\u062f\u0643 \u0623\u0648 \u062a\u0643\u062a\u0628 \u0644\u064a\u0627 \u0627\u0644\u0637\u0644\u0628 \u062f\u064a\u0627\u0644\u0643 \u0647\u0646\u0627\u061f"}, {"type": "user", "content": "Kan 3andi rendez vous lyoum ghe Bach nhayad l ghraz"}, {"type": "bot", "content": "\u0634\u0643\u0631\u0627 \u0639\u0644\u0649 \u0627\u0644\u062a\u0648\u0636\u064a\u062d Saad. \u0628\u0645\u0627 \u0623\u0646 \u0639\u0646\u062f\u0643\u0648\u0645 \u0645\u0648\u0639\u062f \u0627\u0644\u064a\u0648\u0645 \u063a\u064a\u0631 \u0628\u0627\u0634 \u062a\u062d\u064a\u062f \u0627\u0644\u063a\u0631\u0627\u0632\u060c \u0648\u0627\u0634 \u0645\u062d\u062a\u0627\u062c\u064a\u0646 \u062a\u0623\u0643\u062f\u0648 \u0634\u064a \u062d\u0627\u062c\u0629 \u0623\u0648 \u062a\u0628\u062f\u0644\u0648 \u0627\u0644\u0645\u0648\u0639\u062f\u060c \u0648\u0644\u0627 \u0641\u0642\u0637 \u0643\u062a\u0633\u0648\u0644\u0648 \u0648\u0627\u0634 \u0645\u0645\u0643\u0646 \u062a\u062d\u064a\u062f\u0647\u0645 \u0641\u0645\u062f\u064a\u0646\u0629 \u0633\u064a\u062f\u064a \u0633\u0644\u064a\u0645\u0627\u0646 \u0628\u0644\u0627 \u0645\u0627 \u062a\u062c\u064a \u0644\u0633\u0644\u0627\u061f"}, {"type": "user", "content": "Oui"}, {"type": "bot", "content": "Merci pour la pr\u00e9cision Saad. Je vais transmettre votre demande \u00e0 l\u2019\u00e9quipe pour voir si c\u2019est possible de retirer les fils \u00e0 Sidi Slimane au lieu de venir \u00e0 Sal\u00e9.\n\nL\u2019\u00e9quipe va vous contacter pour vous confirmer la possibilit\u00e9 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Bghet n3ref machi mochkil nhayedhom hna"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 268 in notifications