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": 11845, "message_id": "3EB07D03D11507C83BB49F", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*QUECHICHI Safae*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 06 avril 2026* à *09: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لديكم موعد مع ** يوم *الأثنين 6 أبريل 2026* على الساعة *09:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-04T10:29:14.958932", "media_url": null, "media_mime_type": null}, {"id": 11881, "message_id": "3AD18A419999A90DCE66", "sender": "user", "message_type": "text", "content": "Bonjour merci d’annuler mon rdv", "created_at": "2026-04-04T11:29:08.155628", "media_url": null, "media_mime_type": null}, {"id": 12311, "message_id": "3EB0C88A5E314019B4912A", "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 stylized, cartoon-like tooth character in the foreground. The tooth has a smiling face, raised eyebrows, and is giving a thumbs up with one hand while holding a spiral calendar with a large green check mark on it. In the background, there is a blurred dental clinic setting, including a dental chair and what seems to be clinical equipment. At the top, there is a logo of a tooth with the text 'Tanger Bay Dental Center.' Below the logo, there is prominent French text indicating that an appointment is confirmed, followed by the name 'Chez Tanger Bay Dental Center.' The color palette is predominantly blue and white, conveying a clinical and welcoming environment. No real teeth or medical features are visible; the setting is clearly intended as a promotional or informational graphic, not a clinical photo.\",\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\nUser message context: Salut *QUECHICHI Safae*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *lundi 06 avril 2026*\r\n🕘 Heure : *09: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-04-05T10:37:53.838529", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3093/download", "media_mime_type": "image/jpeg"}, {"id": 12702, "message_id": "A575FA5A120DA802F953CA5AC2D74418", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Latin script:**\n\"Safi, salam Safae, kif nti mzyana? Bikhir? Safi, foqash nakhod le rendez-vous wahed akhor?\"\n\n**Arabic script:**\n\"صافي، سلام صفاء، كيف نتي مزيانة؟ بخير؟ صافي، فوقاش ناخذ le rendez-vous واحد آخر؟\"\n\n**English Translation (for context):**\n\"Okay, hi Safae, how are you, fine? Good? Okay, when should I take another appointment?\"", "created_at": "2026-04-08T16:47:19.419054", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3241/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 12770, "message_id": "3A0CDC31F8327129C3DA", "sender": "user", "message_type": "text", "content": "Ana jbartini msafera a khti tanreja3 w ncontactik bach nakhod rdv akhor", "created_at": "2026-04-08T18:10:28.520352", "media_url": null, "media_mime_type": null}, {"id": 12771, "message_id": "bot_3A0CDC31F8327129C3DA_8542", "sender": "bot", "message_type": "text", "content": "Bonjour Safae 😊 Pas de souci, l'annulation de votre rendez-vous du lundi 06 avril à 09:00 est bien prise en compte.\n\nQuand vous serez de retour, n'hésitez pas à nous recontacter pour fixer un nouveau rendez-vous إن شاء الله. Bon voyage et à très bientôt chez Centre Dentaire Tanger Bay !", "created_at": "2026-04-08T18:10:57.683549", "media_url": null, "media_mime_type": null}, {"id": 12779, "message_id": "3A221E38BB2DAB3E47F2", "sender": "user", "message_type": "text", "content": "Merci 🙏🏻", "created_at": "2026-04-08T18:36:49.772814", "media_url": null, "media_mime_type": null}, {"id": 12780, "message_id": "bot_3A221E38BB2DAB3E47F2_9288", "sender": "bot", "message_type": "text", "content": "Avec plaisir, Safae 🙏🏻 Bon séjour et à bientôt !", "created_at": "2026-04-08T18:37:04.225846", "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 868 in training_review_items