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": "\u0641\u0647\u0645\u062a\u0643\u060c \u0628\u0627\u0644\u0646\u0633\u0628\u0629 \u0644\u0644\u062c\u0648\u062a\u064a\u064a\u0631\u060c Dr Haitham Boutaib \u063a\u0627\u062f\u064a \u064a\u0642\u062f\u0631 \u064a\u0634\u0648\u0641 \u0627\u0644\u062d\u0627\u0644\u0629 \u062f\u064a\u0627\u0644\u0643 \u0648\u064a\u0642\u0631\u0631 \u0627\u0644\u062d\u0644 \u0627\u0644\u0623\u0646\u0633\u0628 \u0644\u064a\u0643. \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 \u0628\u0627\u0634 \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u0648\u064a\u062a\u0627\u0635\u0644\u0648\u0627 \u0628\u064a\u0643 \u063a\u062f\u0627 \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 10:00 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647\u061f \ud83d\ude0a"}, {"type": "user", "content": "Et je suis actuellement en France"}, {"type": "bot", "content": "\u0634\u0643\u0631\u0627 \u0639\u0644\u0649 \u0627\u0644\u062a\u0648\u0636\u064a\u062d. \u0628\u0645\u0627 \u0623\u0646\u0643 \u0641\u064a \u0641\u0631\u0646\u0633\u0627\u060c \u064a\u0645\u0643\u0646\u0646\u0627 \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u0628\u0627\u0634 \u064a\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0645\u0639\u0627\u0643 \u0639\u0628\u0631 \u0627\u0644\u0647\u0627\u062a\u0641 \u0623\u0648 \u0627\u0644\u0648\u0627\u062a\u0633\u0627\u0628. \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 \u0628\u0627\u0634 \u0646\u0633\u062c\u0644\u0648 \u0627\u0644\u0637\u0644\u0628 \u062f\u064a\u0627\u0644\u0643 \u0648\u0646\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0645\u0639\u0627\u0643 \u063a\u062f\u0627 \u0639\u0644\u0649 \u0627\u0644\u0633\u0627\u0639\u0629 10:00 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647\u061f \ud83d\ude0a"}, {"type": "user", "content": "Je voulais conna\u00eetre vos tarifs pour des goutti\u00e8re juste la bas ou un appareil dentaire par derri\u00e8re"}, {"type": "bot", "content": "\u0628\u0627\u0644\u0646\u0633\u0628\u0629 \u0644\u0644\u062b\u0645\u0646 \u062f\u064a\u0627\u0644 \u0627\u0644\u062c\u0648\u062a\u064a\u064a\u0631 \u0623\u0648 \u0627\u0644\u0623\u062c\u0647\u0632\u0629 \u0627\u0644\u062a\u0642\u0648\u064a\u0645\u064a\u0629\u060c \u0643\u064a\u062a\u062d\u062f\u062f \u062d\u0633\u0628 \u0627\u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0641\u0631\u062f\u064a\u0629 \u0644\u0643\u0644 \u0645\u0631\u064a\u0636 \u0628\u0639\u062f \u062a\u0642\u064a\u064a\u0645 Dr Haitham Boutaib. \u0648\u0627\u062e\u0627 \u0646\u062d\u062c\u0632\u0648 \u0644\u064a\u0643 consultation \u0628\u0627\u0634 \u064a\u0634\u0648\u0641 \u0627\u0644\u062d\u0627\u0644\u0629 \u062f\u064a\u0627\u0644\u0643 \u0648\u064a\u0639\u0637\u064a\u0643 \u0627\u0644\u062a\u0641\u0627\u0635\u064a\u0644 \u0627\u0644\u062f\u0642\u064a\u0642\u0629\u061f \u0625\u0630\u0627 \u0645\u0645\u0643\u0646\u060c \u0639\u0637\u064a\u0646\u064a \u0627\u0644\u0625\u0633\u0645 \u0627\u0644\u0643\u0627\u0645\u0644 \u062f\u064a\u0627\u0644\u0643 \u0628\u0627\u0634 \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u064a\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0645\u0639\u0627\u0643. \ud83d\ude0a"}, {"type": "user", "content": "Oui Mme El messaoudi Hayat"}, {"type": "bot", "content": ""}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 83 in notifications