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": 43352, "message_id": "2AF36617429999ED9D69", "sender": "user", "message_type": "text", "content": "شكرا", "created_at": "2026-06-14T23:19:21.934891", "media_url": null, "media_mime_type": null}, {"id": 43353, "message_id": "bot_2AF36617429999ED9D69_5001", "sender": "bot", "message_type": "text", "content": "العفو، مرحبا بك ديما! 😊 إذا احتجتي أي مساعدة أخرى أنا هنا.", "created_at": "2026-06-14T23:19:33.337262", "media_url": null, "media_mime_type": null}, {"id": 43423, "message_id": "A52B846D283C4D5FFF170955460D89C0", "sender": "bot", "message_type": "voice", "content": "[Voice message] Of course! Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"السلام عليكم ياسين، لاباس بخير؟ والغالب العشية عندي عامرة، نشوف ليك شي نهار فالسيمانة الأخرى وصافي.\"\n\n**Latin Script (Darija):**\n\"Salam alaykum Yassine, labas bikhir? W l-ghalib l'chiya 3endi 3amra, nchouf lik chi nhar f s-simana l-khra w safi.\"\n\n**English Translation (for context):**\n\"Peace be upon you Yassine, are you doing well? Most likely my evening is full (busy). I'll look for another day for you next week and that’s it.\"", "created_at": "2026-06-15T08:51:33.310971", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11957/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43484, "message_id": "2A32202D3ED1C05A070F", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، خولة كي دايرة لاباس؟ مزيانة بخير؟ كي دايرة مع الصحة؟ لاباس عليك؟\nالله يجازيك بخير.\nصافي واخا، واخا، نشوفو غدا إن شاء الله.\nإلى كانت، إلى كانت شي ساعة عندكم غدا إن شاء الله،\nحيت اليوم عندي شي خدمة غير زيراتني شوية.\nصافي؟", "created_at": "2026-06-15T10:02:51.026079", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11978/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43498, "message_id": "A5DF071D8D032BE4589D31147591D9FF", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio:\n\n**Arabic Script:**\nالسلام سي عبد الغني، كيداير؟ لاباس عليك؟ بخير؟ عرفتي ما كنسمعكش مرة.\n\n**Latin Script (Transliteration):**\n\"Salam Si Abdelghani, kidayer? Labas alik? Bikhir? Arafti ma kansma'kch marra.\"", "created_at": "2026-06-15T10:09:27.849022", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11984/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43502, "message_id": "3EB01B8097D23E1D7BB96C", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELGHANI Elfarissi*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *11:30* .\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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-15T10:09:52.538835", "media_url": null, "media_mime_type": null}, {"id": 44897, "message_id": "3EB0C8C9BA3389B32930EB", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELGHANI Elfarissi*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *11:30* .\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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-17T15:00:52.295468", "media_url": null, "media_mime_type": null}, {"id": 44909, "message_id": "3EB0672B6F8449F723D6CE", "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 cartoon-like smiling tooth with expressive eyes, eyebrows, and a big smile. The tooth is holding a calendar or notepad with a large green check mark, and is giving a thumbs-up gesture. In the blurred background, there appears to be a dental clinic room with a dental chair clearly visible. At the top of the image is the logo and text 'TANGER BAY DENTAL CENTER' with a stylized tooth illustration. Below, there is a prominent blue banner with white text that reads, 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (Your appointment is confirmed), with a check mark icon, followed by another blue bar with the text, 'CHEZ TANGER BAY DENTAL CENTER.' The overall color scheme is blue and white, evoking a clinical and welcoming atmosphere. No real dental or medical images are included.\",\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    \"\n\nUser message context: Salut *ABDELGHANI Elfarissi*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 18 juin 2026*\r\n🕘 Heure : *11:30*\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-17T15:03:38.690533", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12385/download", "media_mime_type": "image/jpeg"}, {"id": 44978, "message_id": "2A287FCE9E85CE1F6FD7", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-17T18:35:50.385865", "media_url": null, "media_mime_type": null}, {"id": 45171, "message_id": "3EB020B99161FA3FA33DDD", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ABDELGHANI Elfarissi*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 22 juin 2026* à *12: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لديكم موعد مع ** يوم *الأثنين 22 يونيو 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-18T11:42:47.909989", "media_url": null, "media_mime_type": null}, {"id": 46857, "message_id": "2AC625770B3C95BB4DF1", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، كيدايرة بخير؟ مزيان؟ عفاك رسلي ليا الـ rendez-vous نهار لاربّع، وأكدي ليا مع الطبيب، مع العشية إن شاء الله نرجع عندو، حيت قالي خاصك ترجع عندي العشية.", "created_at": "2026-06-22T14:58:32.890211", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12979/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 46858, "message_id": "bot_2AC625770B3C95BB4DF1_6336", "sender": "bot", "message_type": "text", "content": "مرحبا! 😊 باش نتأكد من طريقة كتابة الإسم، واخا تكتبوه ليا؟ وأيضا واش ممكن تقولي لي شنو السبب ديال الزيارة نهار الأربعاء مع العشية؟", "created_at": "2026-06-22T14:59:17.841957", "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 3878 in training_review_items