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": "\u0634\u0643\u0631\u0627 \u0639\u0628\u062f \u0627\u0644\u0646\u0648\u0631 \u0639\u0644\u0649 \u0627\u0644\u062a\u0648\u0636\u064a\u062d \ud83d\ude0a \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\u0637\u0644\u0628\u0643\u0645 \u0628\u062e\u0635\u0648\u0635 remise \u062f\u064a\u0627\u0644 500 \u062f\u0631\u0647\u0645 \u0645\u0646 \u0622\u062e\u0631 traitement implant\u060c \u0648\u063a\u0627\u062f\u064a \u064a\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0645\u0639\u0643\u0648\u0645 \u0641\u064a \u0623\u0642\u0631\u0628 \u0648\u0642\u062a \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Ana khlestkom o ntouma vaqe ktsaloni"}, {"type": "user", "content": "https://www.alosoft.ma/rdv_dentiproplus/3787219/drboutaib_hFvdHDPFItT8BbyBaOz9hFbGbeSfvP.ics"}, {"type": "user", "content": "https://www.alosoft.ma/rdv_dentiproplus/3787219/drmouallem_LU0aLO5rbsrrUcN8muaf8iHTbAwLOG.ics"}, {"type": "user", "content": "OUSAMA"}, {"type": "bot", "content": "\u0634\u0643\u0631\u0627 OUSAMA \u0639\u0644\u0649 \u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0631\u0648\u0627\u0628\u0637. \u0628\u0639\u062b\u0646\u0627 \u0637\u0644\u0628\u0643 \u0644\u0644\u0641\u0631\u064a\u0642 \u0648\u063a\u0627\u062f\u064a \u064a\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0645\u0639\u0643\u0648\u0645 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \u0641\u064a \u0623\u0642\u0631\u0628 \u0648\u0642\u062a \u0628\u0627\u0634 \u064a\u062c\u0627\u0648\u0628\u0648\u0643 \u0639\u0644\u0649 \u0623\u064a \u0627\u0633\u062a\u0641\u0633\u0627\u0631 \u0639\u0646\u062f\u0643 \u0628\u062e\u0635\u0648\u0635 \u0627\u0644\u0645\u0648\u0627\u0639\u064a\u062f \u0623\u0648 \u0623\u064a \u0645\u0648\u0636\u0648\u0639 \u0622\u062e\u0631 \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "Bonsoir"}, {"type": "bot", "content": "Bonsoir \ud83d\ude0a Bienvenue au Centre Dentaire Tanger Bay. Comment puis-je vous aider ?"}, {"type": "user", "content": "Svp bghit rev"}, {"type": "user", "content": "Rdv"}, {"type": "bot", "content": "\u0645\u0631\u062d\u0628\u0627 \ud83d\ude0a \u0628\u0627\u0634 \u0646\u0633\u062c\u0644\u0648 \u0644\u0643\u0648\u0645 \u0645\u0648\u0639\u062f\u060c \u0645\u0645\u0643\u0646 \u062a\u0639\u0637\u064a\u0646\u064a \u0627\u0644\u0625\u0633\u0645 \u0627\u0644\u0643\u0627\u0645\u0644 \u062f\u064a\u0627\u0644\u0643\u0648\u0645\u060c \u0634\u0646\u0648 \u0646\u0648\u0639 \u0627\u0644\u0639\u0644\u0627\u062c \u0623\u0648 \u0627\u0644\u0633\u0628\u0628 \u0627\u0644\u0644\u064a \u0645\u062d\u062a\u0627\u062c\u064a\u0646 \u0639\u0644\u064a\u0647 \u0627\u0644\u0645\u0648\u0639\u062f\u060c \u0648\u0641\u0627\u0634 \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0644\u064a \u0645\u0646\u0627\u0633\u0628\u0643\u0648\u0645\u061f"}, {"type": "user", "content": "Oui ayoub boutaib mea 9 gheda bghit blanchiment"}]

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