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": 13099, "message_id": "A5F0A6A4FD501F7B99F8FF9C760A7580", "sender": "bot", "message_type": "voice", "content": "[Voice message] ألو ألو، هاهي عندي الكاميرا، إييه والله، سعداتك كانت خاوية، عطيتها لك.", "created_at": "2026-04-09T13:04:48.776257", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3340/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13111, "message_id": "3A80895AF36C22B5BDEA", "sender": "user", "message_type": "text", "content": "Ghda ?", "created_at": "2026-04-09T13:22:13.613280", "media_url": null, "media_mime_type": null}, {"id": 13112, "message_id": "3A36671F0017D718E850", "sender": "user", "message_type": "text", "content": "Ola b3do", "created_at": "2026-04-09T13:22:18.257068", "media_url": null, "media_mime_type": null}, {"id": 13113, "message_id": "A5C49A9DADC36AC2A822F8C037FA434A", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic script:**\n\"آه غندوز عندك نهار السبت الصباح مع الـ11 إلا بغيتي.\"\n\n**Latin script:**\n\"Ah, ghandouz 3andek nhar sebt sba7 m3a l-hdech ila bghiti.\"", "created_at": "2026-04-09T13:23:18.868293", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3344/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13125, "message_id": "3A526B1F3D12EBAAD5AA", "sender": "user", "message_type": "text", "content": "Ahh safe sbt f sbah parfait", "created_at": "2026-04-09T13:28:06.497741", "media_url": null, "media_mime_type": null}, {"id": 13126, "message_id": "3EB077CF014E5EE47F6A9B", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*AMZIL Amina*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 11 avril 2026* à *11: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*AMZIL*\r\nلديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-09T13:28:39.668744", "media_url": null, "media_mime_type": null}, {"id": 13383, "message_id": "3A49504E5090E8E333C6", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in a mix of Moroccan Darija and French:\n\n\"السلام، صافا؟ غي سمحي لي وصافي غانأنولي عاوتاني الـ rendez-vous، عندي واحد la session مع العشرة، دونك في الرميلات، وما غانسالي حتى لـ 12. هاه، خليوها حتى لشي نهار آخور، أولا يلا كنتو كتفتحو النهار كامل، j'pense pas كتفتحو النهار كامل نهار السبت، دونك نخليوها حتى لشي نهار آخور حتى لنهار لثنين والّا في لعشية.\"", "created_at": "2026-04-09T18:23:22.852451", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3429/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13384, "message_id": "A5731E58277346ABF95BB0F4353ABCE6", "sender": "bot", "message_type": "text", "content": "Sf wakha marhba", "created_at": "2026-04-09T18:24:26.139847", "media_url": null, "media_mime_type": null}, {"id": 13636, "message_id": "3EB07463EDE0A7EEBF4ED1", "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 is a promotional graphic featuring an animated, cartoon-style tooth character. The tooth is smiling, giving a thumbs up, and holding a notepad with a green checkmark. In the background is a blurred scene that appears to be a modern dental office, with a dental chair and some equipment visible. At the top, the logo 'TANGER BAY DENTAL CENTER' is present, consisting of stylized lines forming a tooth shape and the text beneath it. Two prominent blue banners include French text confirming an appointment at the clinic.\",\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    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n\nUser message context: Salut *AMZIL Amina*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 11 avril 2026*\r\n🕘 Heure : *11:00*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.", "created_at": "2026-04-10T15:04:43.636297", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3501/download", "media_mime_type": "image/jpeg"}, {"id": 13662, "message_id": "3EB0D4BCEF7E6751137AF2", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*AMZIL Amina*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 11 avril 2026* à *11: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*AMZIL*\r\nلديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-10T15:12:31.120667", "media_url": null, "media_mime_type": null}, {"id": 13758, "message_id": "3A35856B0290454008D6", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-04-10T17:39:17.866760", "media_url": null, "media_mime_type": null}, {"id": 13759, "message_id": "bot_3A35856B0290454008D6_3942", "sender": "bot", "message_type": "text", "content": "مرحبا Amina، شكراً على التواصل ديالك. شفت الرسالة ديالك بخصوص تغيير الموعد حيث عندك التزام آخر، والفريق ديالنا بلغ أنه مرحبا وأي تغيير ممكن.\n\nيلا بغيتِ تبدلي الموعد، قولي ليا غير الوقت أو النهار اللي مناسبك أكثر (مثلاً الاثنين أو شي نهار آخر فالعشية)، وغادي نبلغ الفريق إن شاء الله.\n\nواخا تقولي لي شنو الوقت اللي مريح ليك؟", "created_at": "2026-04-10T17:40:18.186588", "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 940 in training_review_items