SQLite Web: app.db

id

Primary key. INTEGER

chatbot_id

INTEGER NOT NULL

conversation_id

INTEGER NOT NULL

bot_message_id

INTEGER NOT NULL

user_message_id

INTEGER

context_window_json

[{"id": 19939, "message_id": "meta_echo_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAERgUMkE0MjE5NjA1RDNERTAxRDEwRDAA", "sender": "bot", "message_type": "text", "content": "Salam alaikom", "created_at": "2026-04-27T13:11:13.540661", "media_url": null, "media_mime_type": null}, {"id": 19940, "message_id": "meta_echo_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAERgUMkExQjdGMUIxNjdGN0U5ODU2MEEA", "sender": "bot", "message_type": "text", "content": "Je suis de la part de Dr Haitham boutaib", "created_at": "2026-04-27T13:11:50.235683", "media_url": null, "media_mime_type": null}, {"id": 19941, "message_id": "meta_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAEhgWM0VCMDc0OUQ4MEFBNUY4MENCM0U2MgA=", "sender": "user", "message_type": "text", "content": "salam marhba khai", "created_at": "2026-04-27T13:12:11.731249", "media_url": null, "media_mime_type": null}, {"id": 19942, "message_id": "meta_echo_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAERgUMkE3MjUxNTIyQ0E5RjRCODUyNDYA", "sender": "bot", "message_type": "text", "content": "Svp j’ai besoin de connecter le whatsapp du cabinet à un agent IA mais depuis le profil facebook du Dr mais je pense le whatsapp est déjà connecté l un autre business portfolio", "created_at": "2026-04-27T13:12:59.662157", "media_url": null, "media_mime_type": null}, {"id": 19943, "message_id": "meta_echo_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAERgUMkE2Q0RBNTg5NjdFQTVEMjYwODcA", "sender": "bot", "message_type": "text", "content": "C’est peut etre dyalk tatqoli si c’est le cas \nWchoukran bzaf akhi", "created_at": "2026-04-27T13:13:46.004729", "media_url": null, "media_mime_type": null}, {"id": 19944, "message_id": "meta_echo_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAERgUMkFEQzNFQzk0RTBGMzgzNTMwMjAA", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"analysis_version\": \"1.0\",\n  \"image_quality\": {\n    \"score\": 85,\n    \"issues\": []\n  },\n  \"visible_domain\": \"non_dental\",\n  \"observations\": [\n    {\n      \"feature\": \"interface screenshot\",\n      \"evidence\": \"photo shows a screenshot with text and UI elements\",\n      \"severity\": \"none\"\n    }\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"The image is not related to dental health.\"\n  },\n  \"recommended_questions\": [],\n  \"needs_additional_inputs\": {\n    \"value\": true,\n    \"requested\": [\n      \"front smile photo in good light\",\n      \"close-up of upper/lower teeth\",\n      \"left and right side views\"\n    ]\n  },\n  \"urgent_flags\": {\n    \"needs_urgent_human_review\": false,\n    \"signals\": []\n  },\n  \"safety_note_for_orchestrator\": \"AI image assessment only; not a diagnosis.\"\n}\n```", "created_at": "2026-04-27T13:16:24.637310", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/5619/download", "media_mime_type": "image/jpeg"}, {"id": 19945, "message_id": "meta_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAEhgWM0VCMDE1Rjc0MTlEMEEyQzc1Qjk1OQA=", "sender": "user", "message_type": "text", "content": "att ana anchouf", "created_at": "2026-04-27T13:17:32.221137", "media_url": null, "media_mime_type": null}, {"id": 19946, "message_id": "bot_meta_950052238199168_wamid.HBgMMjEyNjY2NDA1NzU2FQIAEhgWM0VCMDE1Rjc0MTlEMEEyQzc1Qjk1OQA=_5515", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊\n\nMerci pour votre message. Si je comprends bien, vous souhaitez connecter le WhatsApp du cabinet à un agent IA, mais il semble déjà être lié à un autre profil business. Pour clarifier cela, il serait peut-être utile de discuter directement avec notre équipe technique.\n\nJe vous propose de fixer un appel de 5 minutes avec un de nos ingénieurs IA pour voir comment on peut vous aider à résoudre ce problème. Quel jour et à quelle heure seriez-vous disponible pour cet appel ?", "created_at": "2026-04-27T13:17:49.999774", "media_url": null, "media_mime_type": null}]

TEXT NOT NULL

bot_answer

TEXT NOT NULL

label

TEXT

corrected_answer

TEXT

reviewed_by

INTEGER

reviewed_at

TEXT

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

updated_at

TEXT

synced_to_examples

INTEGER NOT NULL (default 0

synced_at

TEXT

expected_answer

TEXT

steps_of_thinking

TEXT

tool_called

TEXT

app.db — training_review_items

Update row 1508 in training_review_items