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": 7569, "message_id": "A56E139D3B360D69440B6E05A32253D0", "sender": "bot", "message_type": "text", "content": ".", "created_at": "2026-03-27T15:24:44.903146", "media_url": null, "media_mime_type": null}, {"id": 7571, "message_id": "A5346B409726278F1B6FA86880E9CB4E", "sender": "user", "message_type": "text", "content": "?", "created_at": "2026-03-27T15:24:57.795441", "media_url": null, "media_mime_type": null}, {"id": 7573, "message_id": "3EB0D8B4E1A2349B01EE06", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-27T15:25:23.548597", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1589/download", "media_mime_type": "image/jpeg"}, {"id": 7574, "message_id": "bot_A5346B409726278F1B6FA86880E9CB4E_1017", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 واش نقدر نعاونك بخصوص موعد، خدمة، ولا العنوان؟", "created_at": "2026-03-27T15:25:29.784902", "media_url": null, "media_mime_type": null}, {"id": 7575, "message_id": "A54C5D88A482A6F57362F4064671413D", "sender": "bot", "message_type": "text", "content": "<reply_to>[Image]</reply_to> شوف", "created_at": "2026-03-27T15:25:38.335676", "media_url": null, "media_mime_type": null}, {"id": 7576, "message_id": "A5EEA5A731873DA893018AD17F4F48F6", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-03-27T15:25:42.254046", "media_url": null, "media_mime_type": null}, {"id": 7577, "message_id": "A55586149F6D543D6639414C69AB0B76", "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:**\n\"Ana kandann huwa hada, hada lli ja nhar d ljumu'a ma'a ttmnya d l'achiya.\"\n\n**English Translation (for context):**\n\"I think it's this one, the one that came on Friday at 8 PM.\"", "created_at": "2026-03-27T15:25:44.721567", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1590/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7578, "message_id": "A51A38D81F415415A80CB5595104BE11", "sender": "bot", "message_type": "voice", "content": "[Voice message] وا شفتي هادي مكتوب زرهوني ماشي الزهواني.", "created_at": "2026-03-27T15:25:48.382276", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1591/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7612, "message_id": "3EB0D90F26730579AB77BA", "sender": "bot", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"dental_xray\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"A panoramic dental X-ray showing a full set of teeth, jaw bones, and surrounding structures. The image is clear and well-defined, displaying both upper and lower dental arches, root structures, and bone density. The X-ray shows a standard anatomical structure with visible teeth, roots, sinuses, and part of the nasal cavity.\",\n  \"dental_observations\": {\n    \"applicable\": true,\n    \"teeth_present\": \"all\",\n    \"teeth_condition\": [\n      {\n        \"location\": \"upper_right\",\n        \"observation\": \"Teeth appear intact with visible roots; no obvious decay or fractures noted.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"upper_left\",\n        \"observation\": \"Teeth appear intact with visible roots; no obvious decay or fractures noted.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"lower_right\",\n        \"observation\": \"Teeth appear intact; third molar partially visible.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\": \"lower_left\",\n        \"observation\": \"Teeth appear intact; third molar partially visible.\",\n        \"severity_signal\": \"none\"\n      },\n      {\n        \"location\":", "created_at": "2026-03-27T15:58:39.217888", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1601/download", "media_mime_type": "image/jpeg"}, {"id": 7613, "message_id": "3EB0EEAB9CBFFDDD582C62", "sender": "bot", "message_type": "text", "content": "HAYAT DAHMAN", "created_at": "2026-03-27T15:58:48.323614", "media_url": null, "media_mime_type": null}, {"id": 7614, "message_id": "A5ED808C99D0C34860C136A6DFBC453A", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-03-27T15:59:05.882780", "media_url": null, "media_mime_type": null}, {"id": 7615, "message_id": "bot_A5ED808C99D0C34860C136A6DFBC453A_2703", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻 واش نقدر نعاونكوم بشي حاجة أخرى؟", "created_at": "2026-03-27T15:59:33.534406", "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 288 in training_review_items