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": 15427, "message_id": "bot_3A2D65E9D9EFCDA541AE_6133", "sender": "bot", "message_type": "text", "content": "Bonjour Rym 😊\n\nVotre dernier rendez-vous confirmé était le samedi 11 avril 2026 à 10:00 avec Dr Alami Mustapha. Pour connaître la date de votre prochain rendez-vous ou en fixer un nouveau, l’équipe va vérifier et vous recontactera rapidement إن شاء الله.\n\nالفريق غادي يتواصلوا معاكوم إن شاء الله باش يعطيوكوم التفاصيل.", "created_at": "2026-04-14T10:51:00.288877", "media_url": null, "media_mime_type": null}, {"id": 15445, "message_id": "3EB0EF07E529D2EC097FD8", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HADDIOUI Rym *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 18 avril 2026* à *10: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* على الساعة *10:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-14T11:06:47.300733", "media_url": null, "media_mime_type": null}, {"id": 15450, "message_id": "3EB0FD0726FD879DD69942", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HADDIOUI Rym *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 25 avril 2026* à *10: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لديكم موعد مع ** يوم *السبت 25 أبريل 2026* على الساعة *10:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-14T11:13:29.357851", "media_url": null, "media_mime_type": null}, {"id": 15454, "message_id": "3ADC28DFE2AD288E188D", "sender": "user", "message_type": "text", "content": "Il n y a pas de date plus proche ?", "created_at": "2026-04-14T11:17:14.408141", "media_url": null, "media_mime_type": null}, {"id": 15455, "message_id": "A5E6CAAEB0BA25B0710950CF92F5FE91", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"أه ريم، كيف نتينا مزيانة؟ بخير، الصحة لاباس؟ ريم، دكتور هاد السيمانة مايكونش، 18 فالشهر، 25 فالشهر غيكون، أنا خديتلك رانديفو فيه.\"\n\n**Latin Script:**\n\"Ah Rim, kif ntina mziyana? Bikhir, seha labas? Rim, docteur had simana ma-ykounsh, 18 f-shher, 25 f-shher ghay-koun, ana khdit-lek rendez-vous fih.\"", "created_at": "2026-04-14T11:18:01.158842", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4012/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15681, "message_id": "3AEAFE9F5B4F17CEAB18", "sender": "user", "message_type": "text", "content": "Ook inchaallah", "created_at": "2026-04-14T15:34:41.779571", "media_url": null, "media_mime_type": null}, {"id": 18455, "message_id": "3EB0D3053BE2A8E28395DD", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HADDIOUI Rym *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 25 avril 2026* à *10: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لديكم موعد مع ** يوم *السبت 25 أبريل 2026* على الساعة *10:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-24T12:20:39.888288", "media_url": null, "media_mime_type": null}, {"id": 18634, "message_id": "3EB0A28CC069CABE31BC8E", "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 brightly lit dental office setting with a dental chair and equipment visible in the background. In the foreground, there is a large, cartoon-style tooth character with a smiling face, holding a calendar or appointment card that displays a green check mark. The tooth character is also giving a thumbs up gesture. At the top of the image, the logo and name 'Tanger Bay Dental Center' are present, with a stylized tooth icon. There are blue banners with French text confirming an appointment. The image has a clean, welcoming, and promotional appearance.\",\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    \"other_findings\": null\n  },\n  \"text_visible\": [\n    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL\n\nUser message context: Salut *HADDIOUI Rym *👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 25 avril 2026*\r\n🕘 Heure : *10: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-24T15:03:45.799546", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5163/download", "media_mime_type": "image/jpeg"}, {"id": 18635, "message_id": "3A098E43A2286A3C8D1C", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-24T15:04:00.877786", "media_url": null, "media_mime_type": null}, {"id": 21137, "message_id": "3AD414CE21BA8468A09A", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-04-30T09:47:29.147511", "media_url": null, "media_mime_type": null}, {"id": 21138, "message_id": "3A33C928F339CFD3D674", "sender": "user", "message_type": "text", "content": "Fu9ach eandi le rendez-vous jay stp ?", "created_at": "2026-04-30T09:47:50.321550", "media_url": null, "media_mime_type": null}, {"id": 21139, "message_id": "bot_3A33C928F339CFD3D674_9450", "sender": "bot", "message_type": "text", "content": "Bonjour Rym 😊\n\nعندكِ rendez-vous prochain إن شاء الله يوم السبت 25 أبريل 2026 على الساعة 10:30 صباحاً chez Tanger Bay Dental Center.\n\nإذا احتجتي أي توضيح آخر أنا هنا!", "created_at": "2026-04-30T09:48:03.394664", "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 1606 in training_review_items