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": 45381, "message_id": "3EB0E3599C55EF70EFE4F3", "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 features a digital illustration of a smiling cartoon tooth character with expressive eyes, eyebrows, and a mouth. The character is holding a spiral-bound notepad with a large green checkmark drawn on it and showing a thumbs-up gesture. In the background, there is a blurred depiction of a dental clinic, including a dental chair and several dental instruments, with a generally blue and beige color palette. At the top of the image is the logo of 'TANGER BAY DENTAL CENTER,' which incorporates an abstract tooth design. Two blue banners are displayed at the top section of the image with white text; the upper banner says, 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark symbol, and the lower banner reads, 'CHEZ TANGER BAY DENTAL CENTER.'\",\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\nUser message context: Salut *ACHRAYH Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 19 juin 2026*\r\n🕘 Heure : *15: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-06-18T15:04:22.827857", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12561/download", "media_mime_type": "image/jpeg"}, {"id": 45388, "message_id": "ACEF10BFCADD4840D5D1DCF6EC8DFF39", "sender": "user", "message_type": "text", "content": "Merci beaucoup", "created_at": "2026-06-18T15:06:38.461972", "media_url": null, "media_mime_type": null}, {"id": 45735, "message_id": "3EB085DEFD3B9390E51BFC", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ACHRAYH Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 26 juin 2026* à *15: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* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-19T16:05:39.727742", "media_url": null, "media_mime_type": null}, {"id": 47732, "message_id": "A5901E7BCFE904AB71123BCBA9706F06", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here's the transcription of the audio in Moroccan Darija:\n\n\"السلام عليكم محمد، كي نتينا مزيان؟ بخير؟ الصحة لاباس؟ محمد بغيت نقولك، تقدر تجي نهار الجمعة ف الصباح، حيت الدكتور ما غيكونش الجمعة ف العشية.\"", "created_at": "2026-06-24T11:32:33.144016", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13228/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47734, "message_id": "AC265C78B26A83243109BF40388F331C", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic script and Latin script (Darija):\n\n**Arabic Script:**\nأهلاً، كيف صْبحتي؟ لاباس عليك؟ مزيان؟ كولشي بخير؟ إيه، شمن ساعة ف الصباح مثلاً؟\n\n**Latin Script:**\nAhlan, kif sbehti? Labas 3lik? Mezyan? Kolchi bikhir? Eh, chmen sa3a f sbah matalan?", "created_at": "2026-06-24T11:35:10.461672", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13229/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47735, "message_id": "A5C56D0D0AF6B1243B6E860BE4370F60", "sender": "bot", "message_type": "voice", "content": "[Voice message] نهار الجمعة إن شاء الله مع الـ 11، مزيانة؟", "created_at": "2026-06-24T11:37:06.642309", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13230/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47736, "message_id": "ACA893F926D8044005FFBC9C270327CE", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure, here is the transcription of the audio:\n\n**Arabic script:**\n\"شوف، ونقدرو نأجلو الموعد نتاع نهار لرباع لي ماجي.\"\n\n**Latin script:**\n\"Shouf, o nqdrou n'ajjlou l-maw'id nta' nhar l-reb'a li maji.\"\n\n**English translation (for context):**\n\"Look, and we can postpone the appointment of next Wednesday.\"", "created_at": "2026-06-24T11:43:04.025771", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13231/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47737, "message_id": "3EB0B6A7250E9F90D2BC1D", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ACHRAYH Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 26 juin 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**\r\nلديكم موعد مع ** يوم *الجمعة 26 يونيو 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-24T11:43:10.919080", "media_url": null, "media_mime_type": null}, {"id": 47739, "message_id": "AC4C90A7B58A493BB8113B91EA4F4021", "sender": "user", "message_type": "text", "content": "?", "created_at": "2026-06-24T11:55:15.910159", "media_url": null, "media_mime_type": null}, {"id": 48372, "message_id": "3EB0328CE469B3FAABB717", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ACHRAYH Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 01 juillet 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**\r\nلديكم موعد مع ** يوم *الأربعاء 1 يوليوز 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-25T09:58:57.839098", "media_url": null, "media_mime_type": null}, {"id": 48447, "message_id": "AC78243AF85E71E615C2783FC60F5210", "sender": "user", "message_type": "text", "content": "Merci beaucoup", "created_at": "2026-06-25T12:28:41.532277", "media_url": null, "media_mime_type": null}, {"id": 48448, "message_id": "bot_AC78243AF85E71E615C2783FC60F5210_5526", "sender": "bot", "message_type": "text", "content": "Avec plaisir, à bientôt 😊", "created_at": "2026-06-25T12:29:14.385948", "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 4004 in training_review_items