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": 14031, "message_id": "3EB0F0E478130EE5E5E2BE", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*LINA AGHOUTANE*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 avril 2026* à *10:15* .\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*LINA*\r\nلديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *10:15*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-11T12:33:52.943560", "media_url": null, "media_mime_type": null}, {"id": 14221, "message_id": "3EB0E92C4CE501F39A1B53", "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 digitally created, cartoon-style tooth character with a smiling face, holding a notepad with a green checkmark. The background is a blurred dental office scene, including a dental chair and cabinetry. The upper area features the logo for Tanger Bay Dental Center (a stylized tooth with the words 'TANGER BAY DENTAL CENTER' below it). There are two blue banners with white text, with the top banner reading 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and the lower one 'CHEZ TANGER BAY DENTAL CENTER'. The overall color scheme is soft blue and white, conveying a clean and welcoming dental environment.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"unclear\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"unclear\",\n    \"alignment\": \"unclear\",\n    \"calculus_plaque\": \"unclear\",\n    \"periapical_areas\": \"unclear\",\n    \"other_findings\": \"\"\n  },\n  \"text_visible\": [\n    \"TANGER BAY\n\nUser message context: Salut *LINA AGHOUTANE*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *lundi 13 avril 2026*\r\n🕘 Heure : *10:15*\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-12T00:26:46.233760", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3669/download", "media_mime_type": "image/jpeg"}, {"id": 14628, "message_id": "3EB009DD2D326178E87D0C", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*LINA AGHOUTANE*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 avril 2026* à *10:15* .\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*LINA*\r\nلديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *10:15*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T08:12:54.123690", "media_url": null, "media_mime_type": null}, {"id": 14667, "message_id": "A50DD2808E043593213821D043233479", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-13T08:57:07.545942", "media_url": null, "media_mime_type": null}, {"id": 14768, "message_id": "3EB0425EB47E395FE3F0F8", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *900,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-13T11:08:23.957417", "media_url": null, "media_mime_type": null}, {"id": 14769, "message_id": "3EB00FF87B4CF86ABE4779", "sender": "bot", "message_type": "document", "content": "2026041312081771.pdf", "created_at": "2026-04-13T11:08:43.963348", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3788/download", "media_mime_type": "application/pdf"}, {"id": 14804, "message_id": "3AA76468546CB00B90D4", "sender": "user", "message_type": "text", "content": "Svp pdf de la radio", "created_at": "2026-04-13T12:02:54.259537", "media_url": null, "media_mime_type": null}, {"id": 14808, "message_id": "bot_3AA76468546CB00B90D4_5290", "sender": "bot", "message_type": "text", "content": "Bonjour Lina 😊 Je comprends que vous souhaitez recevoir le PDF de votre radio. Je transmets immédiatement votre demande à l’équipe pour qu’ils vous l’envoient dans les plus brefs délais إن شاء الله 🙏🏻", "created_at": "2026-04-13T12:03:18.658092", "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 1055 in training_review_items