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": 40630, "message_id": "A5FB20079D3C0C8C2EA8E299917D83EF", "sender": "bot", "message_type": "text", "content": "Ok sf ghada n3mlk", "created_at": "2026-06-08T23:19:39.015047", "media_url": null, "media_mime_type": null}, {"id": 40901, "message_id": "3EB0199196F29C102344A2", "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 displays an illustrated or cartoon-like tooth character with a smiling face, black eyes, and eyebrows. The character is holding a small flip calendar or sign displaying a checkmark inside a square, suggesting confirmation. In the background, there appears to be a dental clinic setting with a dental chair that is out of focus. At the top of the image, there is a logo for 'Tanger Bay Dental Center,' featuring a stylized tooth with a wave design. Prominently, two banners with blue backgrounds contain text in French: the first says 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark, and the second says 'CHEZ TANGER BAY DENTAL CENTER.' The general color scheme is predominantly blue and white, with a clean and modern look.\",\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_findings\": \"\"\n\nUser message context: Salut *DERAAOUI Ferdaouss*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mercredi 10 juin 2026*\r\n🕘 Heure : *18: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-09T15:06:42.031418", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11339/download", "media_mime_type": "image/jpeg"}, {"id": 41078, "message_id": "3A0323DB9AADDB409AA7", "sender": "user", "message_type": "text", "content": "Anaa khsni doc haitam🙂kan ba9i mahayji sf hta yji o dik saea nchuf rendez-vous", "created_at": "2026-06-09T19:05:30.256737", "media_url": null, "media_mime_type": null}, {"id": 41090, "message_id": "A5326A54219175D573DCDC1F073FE10D", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic script and Latin script:\n\n**Arabic Script:**\n\"لا والو الدكتور هاد الساعة باقي مجاش. صافي وخا، أنا غان annuler le rendez-vous إن شاء الله غدا.\"\n\n**Latin Script (Darija/French):**\n\"La walou ed-docteur had sa'a baqi majach. Safi wakha, ana ghan annuler le rendez-vous incha'Allah ghedda.\"\n\n**English Translation (for context):**\n\"No, nothing, the doctor hasn't arrived yet. Okay, fine, I will cancel the appointment, God willing, for tomorrow.\"", "created_at": "2026-06-09T19:13:33.795369", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11383/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45348, "message_id": "3EB0CB5138BC9B500A84FA", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*DERAAOUI Ferdaouss*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 19 juin 2026* à *09: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لديكم موعد مع ** يوم *الجمعة 19 يونيو 2026* على الساعة *09:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-18T14:17:24.628565", "media_url": null, "media_mime_type": null}, {"id": 45377, "message_id": "3EB0F5704F5B8A1825BA15", "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 digital promotional graphic for Tanger Bay Dental Center. It shows a cartoon tooth character with a smiling face, holding a notepad displaying a large green check mark. The cartoon tooth is giving a 'thumbs up' gesture. In the background, an out-of-focus dental office is visible, including a dental chair and cabinetry. The upper part of the image contains text and a logo with a stylized tooth graphic and the words 'Tanger Bay Dental Center.' The main text in French reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark, and below that, 'CHEZ TANGER BAY DENTAL CENTER.' The color scheme is dominated by blue and white hues.\",\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_findings\": \"\"\n  },\n  \"text_visible\": [\n    \"TANGER BAY DENTAL\n\nUser message context: Salut *DERAAOUI Ferdaouss*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 19 juin 2026*\r\n🕘 Heure : *09: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-18T15:02:53.099646", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12557/download", "media_mime_type": "image/jpeg"}, {"id": 47845, "message_id": "3A1BFD1097D0E96BF0E7", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-06-24T14:18:58.695353", "media_url": null, "media_mime_type": null}, {"id": 47847, "message_id": "3AC0377E5D25A7A57065", "sender": "user", "message_type": "text", "content": "Anaa ead jit n tanja", "created_at": "2026-06-24T14:19:10.116598", "media_url": null, "media_mime_type": null}, {"id": 47849, "message_id": "3A26549DE9642820A342", "sender": "user", "message_type": "text", "content": "T9dar tchofli chi rendez-vous mea doc haitam", "created_at": "2026-06-24T14:19:29.921766", "media_url": null, "media_mime_type": null}, {"id": 47851, "message_id": "bot_3A26549DE9642820A342_6347", "sender": "bot", "message_type": "text", "content": "مرحبا Ferdaouss 😊 شكراً على تواصلك.", "created_at": "2026-06-24T14:20:30.674567", "media_url": null, "media_mime_type": null}, {"id": 47852, "message_id": "bot_3A26549DE9642820A342_3522", "sender": "bot", "message_type": "text", "content": "حسب الرسالة اللي عندي، كان عندك موعد مع الدكتور هيثم يوم الجمعة 19 يونيو 2026 مع 09:30، ولكن كتبتي أنك عاد جيتي لتانجا وكتسولي واش ممكن ناخدو لك موعد جديد.", "created_at": "2026-06-24T14:20:30.729084", "media_url": null, "media_mime_type": null}, {"id": 47853, "message_id": "bot_3A26549DE9642820A342_4630", "sender": "bot", "message_type": "text", "content": "باش نعاونك، واش ممكن تقولي ليا شنو نوع العلاج أو المشكل اللي عندك، وفوقاش الوقت اللي مناسبك إن شاء الله؟", "created_at": "2026-06-24T14:20:30.777158", "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 3974 in training_review_items