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": 5123, "message_id": "A553A38B89D5B24319D481FE282B2DA9", "sender": "user", "message_type": "voice", "content": "[Voice message] وعليكم السلام أختي. أنا نديرو إن شاء الله.", "created_at": "2026-03-16T10:02:16.665027", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/908/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 5124, "message_id": "bot_A553A38B89D5B24319D481FE282B2DA9_3036", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة الصوتية بالضبط. واش تقدر توضح ليا شنو قصدك؟", "created_at": "2026-03-16T10:02:31.600106", "media_url": null, "media_mime_type": null}, {"id": 5134, "message_id": "A54DBE48C57FEB061551A2FA5BFCC716", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"السلام عليكم، كيف داير أسيدي؟ لاباس؟ بخير؟ مزيان؟ صافي غدا إن شاء الله نفكرك، وبالنسبة للأربعاء آخر نهار حيت راك عارف العطلة د العيد.\"\n\n**Latin Script (Transcription):**\n\"Salamu Alaykum, kif dayr a sidi? Labas? Bikher? Mezyan? Safi ghda inshAllah nfkrek, w binisba l'erba3 akher nhar hitach rak 3arf l'3otla d l'3id.\"", "created_at": "2026-03-16T10:25:48.927550", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/912/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10297, "message_id": "A5BD727DDCEE213596F12548CDF3756D", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"blur\"]\n  },\n  \"description\": \"The image shows a printed receipt or payment document from 'ria', a money transfer service. The document appears to contain details relating to a money transfer, including the sender and beneficiary's names, addresses, transaction numbers, amounts, and agent details. The upper left side shows the sender's details, the center contains beneficiary and service point information, and the right side highlights transaction information, including a PIN, transaction number, method of delivery (Retrait), recipient, agent details, received amount, conversion rates, and total cash sent. Some areas are highlighted in pink. The text is primarily in French. The document is photographed on someone's lap with a car's steering wheel visible, indicating it was likely taken inside a vehicle.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"other_findings\": null\n  },\n  \"text_visible\": [\n    \"ria\",", "created_at": "2026-04-01T17:18:35.358187", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2474/download", "media_mime_type": "image/jpeg"}, {"id": 10298, "message_id": "A59FE8EFC534AA9DDF214EF53D946C09", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a hand holding a stack of 50 euro bills in the foreground. Behind the money, there is a printed document/paper. The document contains text in French and appears to be related to a financial transaction, referencing a payment institution (Ria Payment Institution, EP, S.A.U.). The document displays transaction details, client information, and some highlighted or color-marked sections (such as a pink highlight over numbers). The partial text visible also includes a phone number, a transaction number, an address in Antwerp, Belgium, and references to payment information and monetary figures. The photo appears to be taken inside a car, evidenced by the blurred dashboard and the word 'AIRBAG' impressed on the visible part of the dashboard.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",\n    \"periapical_areas\": \"\",\n    \"other_findings\": \"\"\n  },\n  \"text_visible\": [\n    \"Ria Payment Institution, EP", "created_at": "2026-04-01T17:18:53.239039", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2475/download", "media_mime_type": "image/jpeg"}, {"id": 10299, "message_id": "A5324364DB4B57D6C6670D240C6D1F60", "sender": "user", "message_type": "image", "content": "[Image analysis] ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"moderate\",\n    \"issues\": [\"blur\", \"partial_view\"]\n  },\n  \"description\": \"The image is taken from inside a car, showing a highway/road with at least two lanes and a concrete median barrier on the right side. The photo is oriented forward through the windshield with part of the car's dashboard and steering wheel visible at the bottom. On the dashboard, an illuminated speedometer is displayed, showing a speed of 102 (likely km/h). There is moderate reflection and glare, possibly from the sun, particularly on the left side of the image. The road ahead is clear, with only a few cars visible—one car is directly in front in the same lane, and another is farther ahead. The sky is partly cloudy with a mix of light and darker clouds, and the sun appears to be low, perhaps early morning or late afternoon. The surroundings include trees and vegetation on both sides, with a sign and billboard visible in the distance but not readable. The temperature shown on the dashboard reads 13°C, and the time appears to be 06:56.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,", "created_at": "2026-04-01T17:19:00.727579", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2476/download", "media_mime_type": "image/jpeg"}, {"id": 15834, "message_id": "A5722511A0C2BBC9682C70137DBC41F6", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-14T20:20:55.409520", "media_url": null, "media_mime_type": null}, {"id": 15835, "message_id": "A5FFBB7D2F6F6E200573DA2EC017BD5A", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، كنت ديرت التيليفون مع الدكتور رياض، قالي فوقاش ما يكون عندك شي وقت وتكون في طنجة دير لي التيليفون، دابا بغيت نقول لك أنا جاي لطنجة، واحد الساعة نكون في طنجة، غدا، غدا، غدا مع 11، 12 عندي البابور نرجع لإسبانيا، نقدر نجي غدا مع الصباح ولا اليوم إلا خدام عاد، عندو شي بلاصة، السلام عليكم.", "created_at": "2026-04-14T20:21:14.601520", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4141/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15836, "message_id": "bot_A5FFBB7D2F6F6E200573DA2EC017BD5A_1325", "sender": "bot", "message_type": "text", "content": "فهمتكوم، ولكن أنا assistant virtuel وماعنديش دراية بلي واقع برا هاد المحادثة أو المكالمات مع الدكتور. بعثنا طلبكوم للفريق وغادي يتواصلوا بيكوم إن شاء الله باش يرتبو معاكوم الموعد على حساب les disponibilités.\n\nإلى محتاجين شي حاجة مستعجلة أو بغيتو تتواصلو مباشرة مع العيادة، هاد هو الرقم: +212 660-022-263", "created_at": "2026-04-14T20:22:01.012376", "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 1176 in training_review_items