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": "Ghda ?"}, {"type": "user", "content": "Ola b3do"}, {"type": "bot", "content": "[voice]"}, {"type": "user", "content": "Ahh safe sbt f sbah parfait"}, {"type": "bot", "content": "Bonjour \r\n*AMZIL Amina*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 11 avril 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*AMZIL*\r\n\u0644\u062f\u064a\u0643\u0645 \u0645\u0648\u0639\u062f \u0645\u0639 ** \u064a\u0648\u0645 *\u0627\u0644\u0633\u0628\u062a 11 \u0623\u0628\u0631\u064a\u0644 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": "[voice]"}, {"type": "bot", "content": "Sf wakha marhba"}, {"type": "bot", "content": "[image]"}, {"type": "bot", "content": "Bonjour \r\n*AMZIL Amina*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 11 avril 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*AMZIL*\r\n\u0644\u062f\u064a\u0643\u0645 \u0645\u0648\u0639\u062f \u0645\u0639 ** \u064a\u0648\u0645 *\u0627\u0644\u0633\u0628\u062a 11 \u0623\u0628\u0631\u064a\u0644 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"}, {"type": "bot", "content": "\u0645\u0631\u062d\u0628\u0627 Amina\u060c \u0634\u0643\u0631\u0627\u064b \u0639\u0644\u0649 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u062f\u064a\u0627\u0644\u0643. \u0634\u0641\u062a \u0627\u0644\u0631\u0633\u0627\u0644\u0629 \u062f\u064a\u0627\u0644\u0643 \u0628\u062e\u0635\u0648\u0635 \u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u0645\u0648\u0639\u062f \u062d\u064a\u062b \u0639\u0646\u062f\u0643 \u0627\u0644\u062a\u0632\u0627\u0645 \u0622\u062e\u0631\u060c \u0648\u0627\u0644\u0641\u0631\u064a\u0642 \u062f\u064a\u0627\u0644\u0646\u0627 \u0628\u0644\u063a \u0623\u0646\u0647 \u0645\u0631\u062d\u0628\u0627 \u0648\u0623\u064a \u062a\u063a\u064a\u064a\u0631 \u0645\u0645\u0643\u0646.\n\n\u064a\u0644\u0627 \u0628\u063a\u064a\u062a\u0650 \u062a\u0628\u062f\u0644\u064a \u0627\u0644\u0645\u0648\u0639\u062f\u060c \u0642\u0648\u0644\u064a \u0644\u064a\u0627 \u063a\u064a\u0631 \u0627\u0644\u0648\u0642\u062a \u0623\u0648 \u0627\u0644\u0646\u0647\u0627\u0631 \u0627\u0644\u0644\u064a \u0645\u0646\u0627\u0633\u0628\u0643 \u0623\u0643\u062b\u0631 (\u0645\u062b\u0644\u0627\u064b \u0627\u0644\u0627\u062b\u0646\u064a\u0646 \u0623\u0648 \u0634\u064a \u0646\u0647\u0627\u0631 \u0622\u062e\u0631 \u0641\u0627\u0644\u0639\u0634\u064a\u0629)\u060c \u0648\u063a\u0627\u062f\u064a \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647.\n\n\u0648\u0627\u062e\u0627 \u062a\u0642\u0648\u0644\u064a \u0644\u064a \u0634\u0646\u0648 \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0644\u064a \u0645\u0631\u064a\u062d \u0644\u064a\u0643\u061f"}, {"type": "user", "content": "Nhar tlal m3a 5"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 203 in notifications