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": 34017, "message_id": "bot_2ABBB640C44B2E8D8775_9043", "sender": "bot", "message_type": "text", "content": "Merci beaucoup Fatima pour l’information et pour votre confiance. Vous êtes la bienvenue, l’équipe vous attend إن شاء الله ! 😊\n\nN’hésitez pas à nous contacter si besoin.", "created_at": "2026-05-22T13:59:57.805980", "media_url": null, "media_mime_type": null}, {"id": 34130, "message_id": "A5F9784C587B65B1F96E230AE8C5C73C", "sender": "bot", "message_type": "text", "content": ".", "created_at": "2026-05-22T15:16:37.235803", "media_url": null, "media_mime_type": null}, {"id": 34278, "message_id": "A5DF10B6F9490D207305080028C21F8D", "sender": "bot", "message_type": "voice", "content": "[Voice message] هذا هو تفريغ المقطع الصوتي باللهجة المغربية:\n\n\"السلام عليكم فاطمة الزهراء، شوفي غدا إن شاء الله تقريبا من فوق الجوج عملي بالك مع التليفون حنا غنعيطولك في آخر ساعة، صافي؟\"", "created_at": "2026-05-22T18:10:44.781812", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9775/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 34294, "message_id": "3EB0B6971EF2B67FB9A10E", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*LAHRICHE Fatima ezzahra*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *samedi 23 mai 2026* à *12:15* .\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لديكم موعد مع ** يوم *السبت 23 ماي 2026* على الساعة *12:15*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-22T18:28:00.753164", "media_url": null, "media_mime_type": null}, {"id": 34316, "message_id": "3EB053D3F387AC2C3DD68A", "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 graphic design scene related to a dental clinic. The main focus is a smiling cartoon tooth character holding a small calendar or notepad that displays a large green checkmark. The tooth character is giving a thumbs up and has large cartoon eyes and a mouth. In the background, there is a dental chair and dental equipment, suggesting a clinic setting, but it is out of focus. The top of the image contains a blue gradient background with the logo of 'TANGER BAY DENTAL CENTER' which includes a stylized tooth outline. Text in the center of the image, highlighted by blue bars, reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark and 'CHEZ TANGER BAY DENTAL CENTER'. The setting is clean, bright, and welcoming.\",\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_find\n\nUser message context: Salut *LAHRICHE Fatima ezzahra*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 23 mai 2026*\r\n🕘 Heure : *12:15*\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-05-22T18:33:14.224660", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9781/download", "media_mime_type": "image/jpeg"}, {"id": 34623, "message_id": "3EB0B4D576A1D4CF404F5F", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*LAHRICHE Fatima ezzahra*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 26 mai 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لديكم موعد مع ** يوم *الثلاثاء 26 ماي 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-23T11:58:55.940605", "media_url": null, "media_mime_type": null}, {"id": 35319, "message_id": "A54FA868278F900F6F485999D9A92076", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script) with the French loanwords included:\n\n**Transcription (Arabic Script):**\n\n\"السلام عليكم فاطمة الزهراء، كيف نتي مزيانة؟ بخير؟ الصحة لاباس؟ فاطمة الزهراء بغيت نقولك بلي غدا إن شاء الله ما غانكونوش خدامين، دونك الـ **rendez-vous** غادي يرجع حتى لمورا العيد، صافي؟ مورا العيد أنا غاندخل ونعيط لك إن شاء الله يا ربي.\"\n\n**Transcription (Latin Script/Chat Alphabet):**\n\n\"Salam oualaikoum Fatima Zahra, kif nti mzyana? bikhir? seha labas? Fatima Zahra bghit ngoulik beli ghadda inshallah ma ghankounouch khaddamine, donc l'**rendez-vous** ghadi yrje' hta lmoura l'aid, safi? moura l'aid ana ghandkhoul o n'ayet lik inshallah ya rabbi.\"", "created_at": "2026-05-25T13:23:02.343777", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9958/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 35330, "message_id": "2AFEF5FEAEAF638186F0", "sender": "user", "message_type": "voice", "content": "[Voice message] وي، د المورا العيد. ما تقوليهاش، إينا نهار غادي تبداو؟ بارسكو قول ليه، قول ليه هاداك... الضرسات هادوك الجوجات لي دار ليهوم جوى واحد، دار ليهوم كراون واحد راه je me sens pas à l'aise. بارسكو كتدخل الماكلة تمايا، ما كنعرفش كيفاش ننقي et tout، فضروري خاصني... خاصو يلقى ليا شي حل.", "created_at": "2026-05-25T14:01:08.373063", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9962/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 35331, "message_id": "A5124F9F7C0DB9D4F32F5C632EBB359A", "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 (Phonetic):**\nFatima Zahra, ki derti meziane? Bekhir? Da7ktini melli goulti li awili 3la mour el eid. Wakha safi, ana ghadi ngoulha lo, o nerja3 nradd 3lik, safi? Bye.", "created_at": "2026-05-25T14:02:09.825570", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9963/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 35335, "message_id": "2A866DA158AAA4C40508", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-05-25T14:05:01.798428", "media_url": null, "media_mime_type": null}, {"id": 37480, "message_id": "2A55A4351A16E368965A", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-06-01T11:53:08.983585", "media_url": null, "media_mime_type": null}, {"id": 37483, "message_id": "bot_2A55A4351A16E368965A_2884", "sender": "bot", "message_type": "text", "content": "Bonjour Fatima 😊 Merci pour votre retour. Si vous avez besoin de quoi que ce soit ou souhaitez fixer un nouveau rendez-vous, n’hésitez pas à me le dire !", "created_at": "2026-06-01T11:54:16.443789", "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 2980 in training_review_items