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": "Imta"}, {"type": "user", "content": "Nji"}, {"type": "bot", "content": "\u0645\u0631\u062d\u0628\u0627 \ud83d\ude0a \u0628\u063a\u064a\u062a \u0646\u062a\u0623\u0643\u062f \u0645\u0639\u0627\u0643: \u0648\u0627\u0634 \u0627\u0644\u0625\u0633\u0645 \u0627\u0644\u0643\u0627\u0645\u0644 \u0647\u0648 Noura Ait Arab\u061f \u0648\u0634\u062d\u0627\u0644 \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0644\u064a \u0645\u0646\u0627\u0633\u0628\u0643\u0648\u0645 \u0628\u0627\u0634 \u062a\u062c\u064a \u062a\u062f\u064a\u0631\u064a \u0627\u0644\u0632\u064a\u0627\u0631 \u062f\u064a\u0627\u0644 les bagues\u061f"}, {"type": "user", "content": "Oui noura ait arab"}, {"type": "user", "content": "3chya"}, {"type": "user", "content": "Machi sba7"}, {"type": "bot", "content": "\u0645\u0631\u062d\u0628\u0627 Noura Ait Arab \ud83d\ude0a \u062a\u0633\u062c\u0651\u0644 \u0627\u0644\u0637\u0644\u0628 \u062f\u064a\u0627\u0644\u0643\u0648\u0645\u060c \u0648\u0627\u0644\u0641\u0631\u064a\u0642 \u063a\u0627\u062f\u064a \u064a\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0628\u064a\u0643\u0648\u0645 \u0628\u0627\u0634 \u064a\u0623\u0643\u062f\u0648 \u0627\u0644\u0645\u0648\u0639\u062f \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \ud83d\ude4f\ud83c\udffb\n\u062f\u064a\u0631 \u0641\u0628\u0627\u0644\u0643 \u0623\u0646 \u0627\u0644\u0645\u0648\u0639\u062f \u063a\u0627\u062f\u064a \u064a\u062a\u0623\u0643\u062f \u063a\u064a\u0631 \u0628\u0639\u062f \u0645\u0627 \u064a\u062a\u0648\u0627\u0635\u0644 \u0645\u0639\u0627\u0643 \u0627\u0644\u0641\u0631\u064a\u0642 \u0645\u0628\u0627\u0634\u0631\u0629."}, {"type": "bot", "content": "Mercredi \u00e0 pr\u00e8s midi mn 15H30  TAL 19H00 HNA F CABINET AJI WTSSNAY NOUBA DIALK"}, {"type": "user", "content": "No 3afak"}, {"type": "user", "content": "9bal"}, {"type": "bot", "content": "\u0648\u0627\u062e\u0627 Noura\u060c \u063a\u0627\u062f\u064a \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u0623\u0646\u0643\u0650 \u0643\u062a\u0641\u0636\u0644\u064a \u0648\u0642\u062a \u0642\u0628\u0644 15:30 \u064a\u0648\u0645 \u0627\u0644\u0623\u0631\u0628\u0639\u0627\u0621. \u0627\u0644\u0641\u0631\u064a\u0642 \u063a\u0627\u062f\u064a \u064a\u062a\u0648\u0627\u0635\u0644\u0648\u0627 \u0628\u064a\u0643\u0648\u0645 \u0628\u0627\u0634 \u064a\u0634\u0648\u0641\u0648 \u0648\u0627\u0634 \u0645\u0645\u0643\u0646 \u064a\u0644\u0642\u0627\u0648 \u0644\u064a\u0643\u0648\u0645 \u0648\u0642\u062a \u0645\u0646\u0627\u0633\u0628 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647 \ud83d\ude4f\ud83c\udffb"}, {"type": "user", "content": "9bal MN jeudi"}]

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