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": 45933, "message_id": "3AA0748B7730555FB472", "sender": "user", "message_type": "text", "content": "merci", "created_at": "2026-06-19T22:53:19.733704", "media_url": null, "media_mime_type": null}, {"id": 46942, "message_id": "3A38BDBFDA8001054614", "sender": "user", "message_type": "text", "content": "je peut ravoir un rendez vous s’il vous plais", "created_at": "2026-06-22T15:59:53.248341", "media_url": null, "media_mime_type": null}, {"id": 46943, "message_id": "bot_3A38BDBFDA8001054614_653", "sender": "bot", "message_type": "text", "content": "Merci pour votre message !", "created_at": "2026-06-22T16:00:06.211144", "media_url": null, "media_mime_type": null}, {"id": 46944, "message_id": "bot_3A38BDBFDA8001054614_5566", "sender": "bot", "message_type": "text", "content": "Votre demande de nouveau rendez-vous a bien été transmise à l’équipe, ils vont vous contacter pour fixer la date qui vous conviendra.", "created_at": "2026-06-22T16:00:06.334341", "media_url": null, "media_mime_type": null}, {"id": 46945, "message_id": "bot_3A38BDBFDA8001054614_9163", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-22T16:00:06.373624", "media_url": null, "media_mime_type": null}, {"id": 47509, "message_id": "3EB054A244C61DD6415EA7", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Lounes*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 25 juin 2026* à *12: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لديكم موعد مع ** يوم *الخميس 25 يونيو 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-23T17:03:44.355028", "media_url": null, "media_mime_type": null}, {"id": 47874, "message_id": "3EB0E607DE4E724432318A", "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 image appears to be a promotional or confirmation graphic for a dental clinic. It features a cartoon tooth with a smiling face, holding up a calendar or clipboard with a large green check mark, signifying confirmation. The background shows a blurred-out dental chair and clinic setting. At the top, there is a logo with a stylized tooth and the text 'TANGER BAY DENTAL CENTER'. Below that, two bold blue banners read: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER'. The overall color palette is light blue, white, and beige, creating a friendly and reassuring atmosphere.\",\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    \"VOT\n\nUser message context: Salut *BRAHIMI Lounes*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 25 juin 2026*\r\n🕘 Heure : *12: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-24T15:03:08.161359", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13279/download", "media_mime_type": "image/jpeg"}, {"id": 48055, "message_id": "3A9AA03DB46999482C3C", "sender": "user", "message_type": "text", "content": "oui", "created_at": "2026-06-24T16:58:31.226867", "media_url": null, "media_mime_type": null}, {"id": 48982, "message_id": "3AE94E4CAFE45F056EF5", "sender": "user", "message_type": "text", "content": "bonjours vous pouvez me rappeler la date du prochain rendez vous s’il vous plais", "created_at": "2026-06-26T12:21:51.139222", "media_url": null, "media_mime_type": null}, {"id": 48983, "message_id": "bot_3AE94E4CAFE45F056EF5_8553", "sender": "bot", "message_type": "text", "content": "Bonjour Brahimi Lounes !", "created_at": "2026-06-26T12:22:08.602657", "media_url": null, "media_mime_type": null}, {"id": 48984, "message_id": "bot_3AE94E4CAFE45F056EF5_4147", "sender": "bot", "message_type": "text", "content": "Votre prochain rendez-vous est prévu le jeudi 25 juin 2026 à 12h00 avec Dr Oussama Mouallem, au Centre Dentaire Tanger Bay.", "created_at": "2026-06-26T12:22:08.647577", "media_url": null, "media_mime_type": null}, {"id": 48985, "message_id": "bot_3AE94E4CAFE45F056EF5_5153", "sender": "bot", "message_type": "text", "content": "Si vous avez besoin de modifier ou d’annuler, n’hésitez pas à me le dire !", "created_at": "2026-06-26T12:22:08.685938", "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 4030 in training_review_items