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": 13205, "message_id": "3EB087442B694566169FA3", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*JABIRI  Sanaa*\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 11 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لديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-09T15:51:01.986345", "media_url": null, "media_mime_type": null}, {"id": 13215, "message_id": "A588D89572B68AB73ECF5CABE0BFF838", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts, reflecting the Moroccan Darija and French used:\n\n### **Arabic Script:**\nالسلام عليكم، كيف تينة مزيانة؟ بخير؟ شوف نهار السبت إن شاء الله غيكون عندك راندي فو مع الحداش ونص. صافي؟\n\n### **Latin Script:**\nAssalamu alaykoum, kif tina mziana? Bekheer? Chof nhar sebt inchallah gha ykoun andek rendez-vous m'a l-hdach o nass. Safi?\n\n---\n**Translation (for context):**\n*Peace be upon you, how are you? Good? Look, this Saturday, God willing, you have an appointment at 11:30. Okay?*", "created_at": "2026-04-09T15:52:24.156385", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3381/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13225, "message_id": "3A515E80DBAB01391A15", "sender": "user", "message_type": "text", "content": "Ok c bon inchallah", "created_at": "2026-04-09T16:01:25.795163", "media_url": null, "media_mime_type": null}, {"id": 13640, "message_id": "3EB026239D33C8EBF051D5", "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 promotional or appointment confirmation graphic for Tanger Bay Dental Center. In the foreground, there is a cartoon-style smiling tooth character. The tooth is holding a small calendar or notebook with a large green check mark inside a box, indicating confirmation. The background shows a dental clinic environment, with a blurred dental chair, equipment, and cabinets to suggest the setting. At the top, there is a white dental logo and the text 'TANGER BAY DENTAL CENTER.' Below the logo, there is bold white and blue text on color blocks: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark, and 'CHEZ TANGER BAY DENTAL CENTER.' The overall color palette is light blue, white, and beige, reinforcing a clinical, friendly, and clean impression. No real people are visible; all characters are illustrated.\",\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\nUser message context: Salut *JABIRI  Sanaa*👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 11 avril 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-04-10T15:05:18.357791", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3503/download", "media_mime_type": "image/jpeg"}, {"id": 13673, "message_id": "3A233416C9A9EAD9413E", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-10T15:17:26.141305", "media_url": null, "media_mime_type": null}, {"id": 13886, "message_id": "3EB02B97D1307F1BB65DA3", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*JABIRI  Sanaa*\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 11 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لديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-11T09:32:46.821766", "media_url": null, "media_mime_type": null}, {"id": 13969, "message_id": "3EB0C2F6C1C11A8671FE4E", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *500,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-9000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-11T11:26:21.976672", "media_url": null, "media_mime_type": null}, {"id": 13970, "message_id": "3EB0CCD13DC2C5A0229249", "sender": "bot", "message_type": "document", "content": "2026041112260885.pdf", "created_at": "2026-04-11T11:26:50.560869", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3618/download", "media_mime_type": "application/pdf"}, {"id": 15449, "message_id": "3EB0E3A12A8961DF5C5A4A", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*JABIRI  Sanaa*\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 02 mai 2026* à *13: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لديكم موعد مع ** يوم *السبت 2 ماي 2026* على الساعة *13:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-14T11:09:25.524912", "media_url": null, "media_mime_type": null}, {"id": 15456, "message_id": "3A0674B4C45BDBDB04EE", "sender": "user", "message_type": "text", "content": "Bonjour, je serai en voyage le 02/05 je serai dipo a partir de 06/05", "created_at": "2026-04-14T11:18:26.185213", "media_url": null, "media_mime_type": null}, {"id": 15457, "message_id": "3A66B0A30E90947980BF", "sender": "user", "message_type": "text", "content": "Par contre j ai besoin de vous voir une braquet a tombé le lendemain de la visite", "created_at": "2026-04-14T11:18:28.769795", "media_url": null, "media_mime_type": null}, {"id": 15461, "message_id": "bot_3A66B0A30E90947980BF_3205", "sender": "bot", "message_type": "text", "content": "Merci pour votre message et votre précision. Je transmets votre demande à l’équipe pour reprogrammer votre rendez-vous après le 6 mai et signaler l’urgence concernant le bracket tombé. Ils vont vous contacter rapidement pour fixer une nouvelle date adaptée à votre disponibilité. \n\nBon voyage et à très bientôt !", "created_at": "2026-04-14T11:18:57.182805", "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 1128 in training_review_items