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": 44288, "message_id": "3EB0E22E29E7E049B8568C", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HOSNIA Abali*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 23 juin 2026* à *15: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لديكم موعد مع ** يوم *الثلاثاء 23 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-16T11:24:53.900651", "media_url": null, "media_mime_type": null}, {"id": 44290, "message_id": "AC6BD3082556CAA025476CB380C8920B", "sender": "user", "message_type": "text", "content": "شكرا لله يحفظك", "created_at": "2026-06-16T11:26:06.332685", "media_url": null, "media_mime_type": null}, {"id": 44291, "message_id": "bot_AC6BD3082556CAA025476CB380C8920B_3663", "sender": "bot", "message_type": "text", "content": "بارك الله فيكوم 🙏🏻", "created_at": "2026-06-16T11:26:18.347087", "media_url": null, "media_mime_type": null}, {"id": 46886, "message_id": "3EB05A7BE355F9E9EDB708", "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 promotional or informational graphic for 'Tanger Bay Dental Center.' It features a cartoon tooth character with a smiling face, holding a notepad with a large green checkmark, signaling confirmation. The background depicts a blurred dental office setup with a dental chair and equipment visible. At the top of the image, there is a logo resembling a tooth outline with the text 'Tanger Bay Dental Center' below it. Overlaid prominent text in French states 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark, and a second line adds 'CHEZ TANGER BAY DENTAL CENTER.' The atmosphere is bright, clean, and professional, utilizing shades of blue and white.\",\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 CENTER\",\n\nUser message context: Salut *HOSNIA Abali*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 23 juin 2026*\r\n🕘 Heure : *15: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-22T15:07:24.927204", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12989/download", "media_mime_type": "image/jpeg"}, {"id": 46903, "message_id": "3EB0EE9A69874B98063A20", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HOSNIA Abali*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 23 juin 2026* à *15: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لديكم موعد مع ** يوم *الثلاثاء 23 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-22T15:10:39.325836", "media_url": null, "media_mime_type": null}, {"id": 46904, "message_id": "3EB0F1EA988049462E9823", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HOSNIA Abali*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mardi 23 juin 2026* à *15: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لديكم موعد مع ** يوم *الثلاثاء 23 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-22T15:11:08.746510", "media_url": null, "media_mime_type": null}, {"id": 47450, "message_id": "AC0973B6B64B7E05D0A675E51F76815E", "sender": "user", "message_type": "text", "content": "🚔", "created_at": "2026-06-23T15:21:38.690676", "media_url": null, "media_mime_type": null}, {"id": 47451, "message_id": "bot_AC0973B6B64B7E05D0A675E51F76815E_4019", "sender": "bot", "message_type": "text", "content": "مرحبا! إذا كان عندك أي استفسار أو محتاج شي مساعدة بخصوص الموعد ديالك، أنا هنا نعاونك 😊 إذا وقع شي طارئ أو بغيت تغير أو تلغي الموعد، غير خبرني.", "created_at": "2026-06-23T15:21:57.701524", "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 3935 in training_review_items