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": 11680, "message_id": "2A31A1610A06C70D8B73", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija (Arabic script):\n\n**آه، أوكي، صافي. تال السيمانة اللي موراها، حتى يجي دكتور هيثم سعدة، نجي عندك إن شاء الله. هاني درت بحال إلا غنجي عندك، غنجي عندك بالسبت حيتاش هاد السيمانة ما عندي كيفاش ندير.**\n\n### Transcription in Latin Script (Arabizi):\n\"Ah, okay, safi. Tal simana li mouraha, hta yji Dr. Haitham Saada, nji 'andek insha'Allah. Hani dert bhal ila ghan ji 'andek, ghan nji 'andek b-sebt hitach had simana ma 'andi kifach ndir.\"", "created_at": "2026-04-03T19:47:36.006455", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2906/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11683, "message_id": "A597C95C0667B56813F5673156B57094", "sender": "bot", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Sf ok marhbabik", "created_at": "2026-04-03T20:15:06.400261", "media_url": null, "media_mime_type": null}, {"id": 18449, "message_id": "3EB07276E0E07F9573928B", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*CHOUKRI RIFI Abdeilah*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *samedi 25 avril 2026* à *11: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* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-24T12:19:12.927182", "media_url": null, "media_mime_type": null}, {"id": 18477, "message_id": "2A09F5406EEF81F58354", "sender": "user", "message_type": "text", "content": "<reply_to>Bonjour \r\n*CHOUKRI RIFI Abdeilah*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *samedi 25 avril 2026* à *11:00* .\r\nEn cas d'empêchement, ve...</reply_to> 👍🏻", "created_at": "2026-04-24T12:29:35.438583", "media_url": null, "media_mime_type": null}, {"id": 18637, "message_id": "3EB072F1BECFAEE71BE3F2", "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 graphic, likely for social media, for Tanger Bay Dental Center. The upper part displays a logo featuring a stylized tooth and the text 'TANGER BAY DENTAL CENTER.' Below, there is a large blue banner with the French text 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (your appointment is confirmed) followed by a green checkmark. A secondary banner states 'CHEZ TANGER BAY DENTAL CENTER.' In the foreground, there is an animated character in the shape of a tooth, smiling and holding a desk calendar or notepad displaying a large green checkmark. The background is softly blurred but suggests a dental office setting with a dental chair and typical clinical environment.\",\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\nUser message context: Salut *CHOUKRI RIFI Abdeilah*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 25 avril 2026*\r\n🕘 Heure : *11: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-24T15:04:25.551842", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5165/download", "media_mime_type": "image/jpeg"}, {"id": 18654, "message_id": "2AB3C4FDA78A356D3FF9", "sender": "user", "message_type": "text", "content": "Oui hanji ghada nchalah", "created_at": "2026-04-24T15:15:17.939462", "media_url": null, "media_mime_type": null}, {"id": 19132, "message_id": "3EB05E2025EC7BC6C66810", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-760,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-25T11:23:43.044173", "media_url": null, "media_mime_type": null}, {"id": 19134, "message_id": "3EB0F568515CD3B0DE45B1", "sender": "bot", "message_type": "document", "content": "2026042512233796.pdf", "created_at": "2026-04-25T11:23:55.839336", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5344/download", "media_mime_type": "application/pdf"}, {"id": 19135, "message_id": "3EB0A58C03AB0BD09F99BF", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1000,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-760,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-25T11:24:34.472767", "media_url": null, "media_mime_type": null}, {"id": 19137, "message_id": "3EB03CB9BE954138788244", "sender": "bot", "message_type": "document", "content": "2026042512242911.pdf", "created_at": "2026-04-25T11:24:51.233861", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5345/download", "media_mime_type": "application/pdf"}, {"id": 21671, "message_id": "2ABD556B45315899B141", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (mixed with French):\n\n**Arabic Script:**\nالسلام عليكم شيماء، بخير مزيان؟ أ شيماء على حسب غدا زعما واش غايبقى نفس الـ **rendez-vous** ولا عا خصني نعاود نشبر **rendez-vous** ولا كيفاش؟\n\n**Latin Script:**\nAssalamu alaykum Chaimaa, bikhir mzian? A Chaimaa 3la hsab ghedda za3ma wash ghaybqa nefs l-**rendez-vous** walla 3a khassni n3awd nchebbar **rendez-vous** walla kifash?", "created_at": "2026-05-01T14:21:52.098673", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/6139/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 21672, "message_id": "bot_2ABD556B45315899B141_4669", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله شيماء 😊\n\nبالنسبة لسؤالك على موعد غدا: الطلب ديالك وصل للفريق ولكن الموعد مزال ما تأكدش — غادي يتواصلوا معاكوم إن شاء الله باش يعطيوكوم الجواب النهائي 🙏🏻\n\nيلا كان عندك أي سؤال آخر أنا هنا نعاونكوم!", "created_at": "2026-05-01T14:22:36.315487", "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 1639 in training_review_items