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": 16201, "message_id": "A545438A9AA077E886B564DDECFB3275", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-15T14:52:06.879250", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4255/download", "media_mime_type": "video/mp4"}, {"id": 16202, "message_id": "A5B05FF5F34AD86B65EA14C45EC70FDF", "sender": "bot", "message_type": "video", "content": "sardolo hta had videos o khbeoohm endkom", "created_at": "2026-04-15T14:52:06.982801", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4256/download", "media_mime_type": "video/mp4"}, {"id": 16203, "message_id": "A5EEEA450BEE7BA863CAE5AFE29929FA", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-15T14:52:07.096231", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4257/download", "media_mime_type": "video/mp4"}, {"id": 16220, "message_id": "3EB0AC4A08D6600175DFFC", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *400,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-15T15:07:25.825684", "media_url": null, "media_mime_type": null}, {"id": 16221, "message_id": "3EB0A72BB4A80DB22BDFA6", "sender": "bot", "message_type": "document", "content": "2026041516054269.pdf", "created_at": "2026-04-15T15:07:47.501329", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4272/download", "media_mime_type": "application/pdf"}, {"id": 16222, "message_id": "3EB0CE6FEACDEF04C87E80", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *400,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-15T15:08:14.400254", "media_url": null, "media_mime_type": null}, {"id": 16223, "message_id": "3EB07A0FB7ED95ADC5DD35", "sender": "bot", "message_type": "document", "content": "2026041516062699.pdf", "created_at": "2026-04-15T15:08:35.025666", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4273/download", "media_mime_type": "application/pdf"}, {"id": 16273, "message_id": "A569A3E7E7281EC936E9D963BA395FCE", "sender": "bot", "message_type": "text", "content": "Salam", "created_at": "2026-04-15T15:45:19.686495", "media_url": null, "media_mime_type": null}, {"id": 16274, "message_id": "A57AA4E047F78E6C0CD84DBDD2975E80", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a digital or cartoon illustration of a smiling anthropomorphic tooth giving a thumbs-up gesture. The tooth has large, round, black eyes, dark eyebrows, and a wide smile with a visible tongue. The background features a blurred dental clinic setting with a dental chair and some equipment, suggesting a welcoming and clean environment. The logo of 'Tanger Bay Dental Center' with a stylized tooth graphic is present at the top, and a blue banner at the bottom includes a slogan in French.\",\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    \"TANGER BAY DENTAL CENTER\",\n    \"Votre satisfaction est notre priorité\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"The image\n\nUser message context: 🌟🌟🌟🌟🌟 Si vous êtes satisfait(e), vous pouvez nous aider en laissant un avis sur Google ici :\r\n👉 [https://g.page/r/CcEiqTIh1WiuEBE/review]\r\n\r\nNous espérons que votre visite chez nous s’est bien passée. Votre confort reste notre priorité.\r\n\r\n✅ Si quelque chose ne vous a pas satisfait, répondez simplement à ce message et nous trouverons une solution.", "created_at": "2026-04-15T15:45:43.631841", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4291/download", "media_mime_type": "image/jpeg"}, {"id": 16580, "message_id": "3EB0AB7EB2A57CBB106234", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BENJELLOUN Mouad *\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 20 avril 2026* à *14:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الأثنين 20 أبريل 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-16T09:18:01.252017", "media_url": null, "media_mime_type": null}, {"id": 17436, "message_id": "3A93F3EE79FE885A0BAD", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in a mix of Moroccan Darija and French:\n\n\"السلام عليكم مدام شيماء، لباس؟ كلشي بخير؟ المهم، معاك معاذ بن جلون. غير على ديك الـ **rendez-vous** ديال نهار الجمعة مع الـ 4 د العشية، بغيتك تـ **annuler**ـيه. دابا الجمعة أنا كاملة ماشي **disponible** نهار كامل. المهم، إلا غدا الخميس بانت شي ساعة خاوية ولا شي حاجة، تقدر تتصل بيا وتقولها ليا. **Sinon** السيمانة اللي ماجية، عطيني شي نهار فالسيمانة اللي ماجية وديك الساعة أنا نشوف الـ **emploi** ديالي ونرد عليك. شكراً، يلاه بسلامة.\"", "created_at": "2026-04-22T16:05:53.856784", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4717/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 17441, "message_id": "bot_3A93F3EE79FE885A0BAD_7548", "sender": "bot", "message_type": "text", "content": "واخا Mouad، غادي نبلغ الفريق بطلبك لإلغاء موعد الجمعة مع 16:00 حيث ماشي متاح، وطلبك بخصوص شي ساعة خاوية الخميس أو موعد جديد الأسبوع الجاي. الفريق غادي يتواصلوا معاك إن شاء الله.\n\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-04-22T16:06:25.222504", "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 1337 in training_review_items