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": 14961, "message_id": "3EB03C6E5FCBEBD2961C96", "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\": \"This is a promotional or informational image. It features a digital illustration of a cartoon tooth character with a smiling face, eyebrows, and black eyes. The tooth is holding a small calendar or notepad with a large green checkmark and is giving a thumbs-up gesture. In the background, there is a blurred image of a dental clinic room with dental equipment and a dental chair. At the top of the image, there is a dental clinic logo featuring a stylized tooth shape and the words 'TANGER BAY DENTAL CENTER'. Below, there's a blue banner with white text saying 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and a checkmark, and another blue banner with the text 'CHEZ TANGER BAY DENTAL CENTER'. The atmosphere is welcoming, modern, and medical.\",\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 *EL FARZAZI BENTATOU Samar*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 14 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-13T15:04:40.051256", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3827/download", "media_mime_type": "image/jpeg"}, {"id": 15070, "message_id": "3EB0115F0118B48CAFE67E", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL FARZAZI BENTATOU Samar*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mardi 14 avril 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لديكم موعد مع ** يوم *الثلاثاء 14 أبريل 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T16:43:29.210336", "media_url": null, "media_mime_type": null}, {"id": 15118, "message_id": "A5693A9916B100780A944BB862F96B49", "sender": "bot", "message_type": "voice", "content": "[Voice message] السلام عليكم أختي، مزيان؟ بيخير؟ سمحي لي بالنسبة للـ rendez-vous غادي يكون عندك نهار لاربعاء إن شاء الله.", "created_at": "2026-04-13T18:02:50.699815", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3887/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15119, "message_id": "3AFCAA144ED907D6B3F1", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and English:\n\n**ان شاء الله أختي، شكراً بزاف وسمحي ليا بلي ما جيتش داك النهار، just، تال لارباع ان شاء الله، إلى بغا ربي.**\n\n**Transliteration (Latin Script):**\n*Inshallah khti, chokran bzaf w smhi lya bli ma jitsh dak nhar, just, tal l’arba’ inshallah, ila bgha rebi.*", "created_at": "2026-04-13T18:03:24.855883", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3888/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15137, "message_id": "A500753C6C3243CD1EC204D4C2C50214", "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:**\n\"Sam7i liya khti, ma 3ndk tachi mouchkil al hbiba dyali, marhba 3la rass wel 3ayn, wallah hta chi haja, 3ndk chi sou'al ay haja 3ayti liya.\"\n\n**English Translation (for context):**\n\"I'm sorry sister, no problem at all my dear. You are most welcome, it's my pleasure. Truly, if there is anything, or if you have any questions, anything at all, just call me.\"", "created_at": "2026-04-13T18:37:14.148674", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3895/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15619, "message_id": "3EB0DDE883D34D26878D6F", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL FARZAZI BENTATOU Samar*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 15 avril 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لديكم موعد مع ** يوم *الأربعاء 15 أبريل 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-14T14:45:57.945883", "media_url": null, "media_mime_type": null}, {"id": 15982, "message_id": "3A2435D410F54995C7B3", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-04-15T10:14:31.325053", "media_url": null, "media_mime_type": null}, {"id": 15983, "message_id": "3A537C93DE1957FC3866", "sender": "user", "message_type": "text", "content": "Ghan t3atl Shi 15 min", "created_at": "2026-04-15T10:14:40.523799", "media_url": null, "media_mime_type": null}, {"id": 15984, "message_id": "3AD38425CC3B13703EDA", "sender": "user", "message_type": "text", "content": "Wakha? X", "created_at": "2026-04-15T10:14:43.782355", "media_url": null, "media_mime_type": null}, {"id": 15985, "message_id": "bot_3AD38425CC3B13703EDA_9052", "sender": "bot", "message_type": "text", "content": "Merci Samar pour l’info ! Pas de souci, vous serez attendue même avec 15 minutes de retard إن شاء الله. À tout à l’heure 😊", "created_at": "2026-04-15T10:15:26.801765", "media_url": null, "media_mime_type": null}, {"id": 15998, "message_id": "3A7D35D227DD76D8DF86", "sender": "user", "message_type": "text", "content": "5 mins", "created_at": "2026-04-15T10:42:52.290821", "media_url": null, "media_mime_type": null}, {"id": 15999, "message_id": "bot_3A7D35D227DD76D8DF86_3034", "sender": "bot", "message_type": "text", "content": "Pas de problème Samar, vous pouvez venir même avec 5 minutes de retard. On vous attend 😊", "created_at": "2026-04-15T10:43:06.262573", "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 1194 in training_review_items