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": 18263, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTFBNTZBNkE0OTBEOUVCOUU3RAA=", "sender": "user", "message_type": "voice", "content": "[Voice message] و سلمان فاروتي، و سلمان فاروتي.", "created_at": "2026-04-24T09:17:50.180252", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/5022/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 18264, "message_id": "bot_meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTFBNTZBNkE0OTBEOUVCOUU3RAA=_518", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة الصوتية بالضبط. واش تقدر توضح ليا شنو قصدك؟", "created_at": "2026-04-24T09:18:03.820428", "media_url": null, "media_mime_type": null}, {"id": 18304, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTJBQTMzNTJEMUIzOUY5RDFEQgA=", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script:**\nالسلام عليكم، لاباس عليك؟ مزيان؟ كلشي مزيان؟\n\n**Latin Script:**\nSalamou alaykoum, labass 3lik? Mezyan? Koulchi mezyan?", "created_at": "2026-04-24T10:05:49.168614", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/5032/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 18305, "message_id": "bot_meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTJBQTMzNTJEMUIzOUY5RDFEQgA=_9809", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 بارك الله فيك، نتوما بخير؟ كيفاش نقدر نعاونك اليوم؟", "created_at": "2026-04-24T10:06:07.077469", "media_url": null, "media_mime_type": null}, {"id": 18306, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQTg4RjQ3MDZCRDYxMkIzRDE3NQA=", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nالسلام عليكم، كلشي مزيان؟ الحمد لله، كلشي مزيان.\n\n**Latin Script:**\nSalam o alaikom, koulchi mzyan? Alhamdolillah, koulchi mzyan.", "created_at": "2026-04-24T10:06:17.248746", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/5033/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 18308, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQTI1Rjk5OUVDMTQzMDg1RTZEMwA=", "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\": \"trees and buildings\",\n      \"evidence\": \"visible trees and urban infrastructure\",\n      \"severity\": \"none\"\n    }\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"Non-dental image; dental concerns not applicable.\"\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-24T10:06:43.372858", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/5034/download", "media_mime_type": "image/jpeg"}, {"id": 18310, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUUwRUQ2QTBEN0QwQTczQzNBQgA=", "sender": "user", "message_type": "text", "content": "I want to talk to a human please norify him", "created_at": "2026-04-24T10:08:22.929146", "media_url": null, "media_mime_type": null}, {"id": 18311, "message_id": "bot_meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUUwRUQ2QTBEN0QwQTczQzNBQgA=_2220", "sender": "bot", "message_type": "text", "content": "Bien sûr 😊 J'ai notifié notre équipe et quelqu'un va vous contacter bientôt. Merci pour votre patience !", "created_at": "2026-04-24T10:08:44.433675", "media_url": null, "media_mime_type": null}, {"id": 18339, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTE5NjA2MERDQkUzNDJGNTI1QgA=", "sender": "user", "message_type": "text", "content": "Renotify him", "created_at": "2026-04-24T10:32:01.403964", "media_url": null, "media_mime_type": null}, {"id": 18342, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUNEQ0NCQjc1OTU4OUZCNEYzNQA=", "sender": "user", "message_type": "text", "content": "Renotify him", "created_at": "2026-04-24T10:37:07.983587", "media_url": null, "media_mime_type": null}, {"id": 18352, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUE4NEQ1NjYyOTA1MkU2NTY4NAA=", "sender": "user", "message_type": "text", "content": "Hi", "created_at": "2026-04-24T10:47:39.809552", "media_url": null, "media_mime_type": null}, {"id": 18353, "message_id": "bot_meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUE4NEQ1NjYyOTA1MkU2NTY4NAA=_4111", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 J'ai déjà notifié notre équipe, et ils vous contacteront bientôt. Si vous avez d'autres questions ou préoccupations, n'hésitez pas à me le faire savoir !", "created_at": "2026-04-24T10:47:53.518057", "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 1397 in training_review_items