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": 18038, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBYzRUIwOTJDRTlBQUMzQ0U2Njc2NEY0AA==", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"analysis_version\": \"1.0\",\n  \"image_quality\": {\n    \"score\": 90,\n    \"issues\": []\n  },\n  \"visible_domain\": \"non_dental\",\n  \"observations\": [\n    {\n      \"feature\": \"textual content\",\n      \"evidence\": \"Messages and user interface from a messaging app\",\n      \"severity\": \"none\"\n    }\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"Image content is non-dental.\"\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-23T17:31:44.778963", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/4958/download", "media_mime_type": "image/jpeg"}, {"id": 18039, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBYzRUIwNEIwQjgxMDNBMzJGRjBCMEM3AA==", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"analysis_version\": \"1.0\",\n  \"image_quality\": {\n    \"score\": 90,\n    \"issues\": []\n  },\n  \"visible_domain\": \"non_dental\",\n  \"observations\": [\n    {\n      \"feature\": \"person\",\n      \"evidence\": \"image of a person speaking\",\n      \"severity\": \"none\"\n    },\n    {\n      \"feature\": \"background equipment\",\n      \"evidence\": \"medical or office equipment visible\",\n      \"severity\": \"none\"\n    }\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"image does not relate to dental concerns\"\n  },\n  \"recommended_questions\": [],\n  \"needs_additional_inputs\": {\n    \"value\": false,\n    \"requested\": []\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-23T17:31:45.406288", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/4959/download", "media_mime_type": "image/jpeg"}, {"id": 18249, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQTlCMjYyQ0Y3RTVBMzcyREMyOAA=", "sender": "bot", "message_type": "text", "content": "Hiiiii", "created_at": "2026-04-24T09:14:31.508469", "media_url": null, "media_mime_type": null}, {"id": 18251, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQTFDODFDOEJCRjI4OUQzQUMyQwA=", "sender": "bot", "message_type": "text", "content": "Vc", "created_at": "2026-04-24T09:14:56.901227", "media_url": null, "media_mime_type": null}, {"id": 18252, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQTM5ODg4NjgzREQwQkJBRkFENQA=", "sender": "bot", "message_type": "text", "content": "Jj", "created_at": "2026-04-24T09:15:00.047371", "media_url": null, "media_mime_type": null}, {"id": 18253, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQTcyMkNGRjFCQkIwREJBNEJFQQA=", "sender": "bot", "message_type": "text", "content": "[Owner sent audio]", "created_at": "2026-04-24T09:15:04.701510", "media_url": null, "media_mime_type": null}, {"id": 18255, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQUFGQzZCRjMxQ0ZDQjcyMkVENAA=", "sender": "bot", "message_type": "text", "content": "Tiititititgi", "created_at": "2026-04-24T09:15:12.369834", "media_url": null, "media_mime_type": null}, {"id": 18256, "message_id": "meta_echo_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgARGBQyQTY5N0JDNkFFREYxQjI5NzAyNAA=", "sender": "bot", "message_type": "text", "content": "[Owner sent image]", "created_at": "2026-04-24T09:15:21.325214", "media_url": null, "media_mime_type": null}, {"id": 18258, "message_id": "owner_media_2740d721371e4a49aafae2ea44b0f1a0", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script:** أجي لهنا، أجي لهنا.\n**Latin Script:** Aji l hna, aji l hna.\n\n**(English Translation: Come here, come here.)**", "created_at": "2026-04-24T09:15:34.487958", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/5020/download", "media_mime_type": "video/webm"}, {"id": 18259, "message_id": "owner_media_8fe9d1a009dc42eda98557e1f8951779", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"analysis_version\": \"1.0\",\n  \"image_quality\": {\n    \"score\": 70,\n    \"issues\": [\"angle_limited\", \"partial_view\"]\n  },\n  \"visible_domain\": \"non_dental\",\n  \"observations\": [\n    {\n      \"feature\": \"portrait\",\n      \"evidence\": \"image shows a person's face from the shoulders up\",\n      \"severity\": \"none\"\n    }\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"image does not show dental aspects\"\n  },\n  \"recommended_questions\": [\n    \"What exactly concerns you most (color, alignment, pain, gums, other)?\",\n    \"How long has this been present?\",\n    \"Any pain, bleeding, swelling, fever, trauma, or sensitivity?\"\n  ],\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-24T09:15:54.953096", "media_url": "/api/v1/chatbots/38/knowledge-bases/media/files/5021/download", "media_mime_type": "image/png"}, {"id": 18261, "message_id": "meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUYwQjA4RDlEQTRFMjExNkFBRAA=", "sender": "user", "message_type": "text", "content": "Si lmanfaroti", "created_at": "2026-04-24T09:16:35.613516", "media_url": null, "media_mime_type": null}, {"id": 18262, "message_id": "bot_meta_950052238199168_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQUYwQjA4RDlEQTRFMjExNkFBRAA=_4925", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة بالضبط. واش تقدر توضح ليا شنو قصدك أو كيفاش نقدر نعاونك؟", "created_at": "2026-04-24T09:17:13.070240", "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 1392 in training_review_items