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": 14767, "message_id": "bot_ACB1FE47D481DF8E5726066C1679CC11_3624", "sender": "bot", "message_type": "text", "content": "مرحبا مريم 😊 شكرا على التوضيح.\n\nباش نتأكد من كلشي، الموعد اللي كان عندك هو نهار الخميس 9 أبريل مع الرابعة، ودابا كتبغي تبدليه للأربعاء 8 أبريل مع الرابعة، صحيح؟\n\nغادي نبلغ الفريق بطلب تغيير الموعد، وغادي يتواصلوا معاكوم باش يأكدو لكوم التغيير إن شاء الله.\n\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-04-13T11:06:56.239887", "media_url": null, "media_mime_type": null}, {"id": 14770, "message_id": "3EB095170C8947CDA261F6", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*CHATT MARIAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 16 avril 2026* à *16: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لديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T11:10:21.705607", "media_url": null, "media_mime_type": null}, {"id": 16213, "message_id": "3EB063E145F78F1FA835CE", "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-style anthropomorphic tooth character with eyes, eyebrows, and a mouth, giving a thumbs up and holding a small spiral-bound calendar with a green checkmark. The background shows a blurred image of a dental chair and clinical office, indicating a dental clinic setting. At the top, there is the Tanger Bay Dental Center logo, which includes a stylized tooth design and text. The main text, centered and highlighted in blue banners, reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check emoji, followed underneath by 'CHEZ TANGER BAY DENTAL CENTER.' The overall color palette is blue, white, and beige, giving a clean and inviting appearance. There are no real teeth, patients, or clinical findings visible in the image.\",\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\nUser message context: Salut *CHATT MARIAM*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 16 avril 2026*\r\n🕘 Heure : *16: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-15T15:05:36.785072", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4267/download", "media_mime_type": "image/jpeg"}, {"id": 16237, "message_id": "3EB0CB0EC1EC688B093911", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*CHATT MARIAM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 16 avril 2026* à *16: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لديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-15T15:21:18.331279", "media_url": null, "media_mime_type": null}, {"id": 16385, "message_id": "ACBBA69E3288989722CB954D19F9F073", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-15T16:53:19.682514", "media_url": null, "media_mime_type": null}, {"id": 16386, "message_id": "bot_ACBBA69E3288989722CB954D19F9F073_7388", "sender": "bot", "message_type": "text", "content": "شكرا بزاف مريم على التأكيد ديالك 😊\n\nالموعد ديالك مع الدكتور هيثم بوطيب نهار الخميس 16 أبريل مع الرابعة غادي يبقى محفوظ إن شاء الله. يلا احتاجيتي شي حاجة أو وقع شي تغيير، تواصلي معانا في أي وقت.\n\nمرحبا بيكوم!", "created_at": "2026-04-15T16:53:37.372818", "media_url": null, "media_mime_type": null}, {"id": 16805, "message_id": "3EB0962FBCE2B891DC85FE", "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-16T14:36:03.051017", "media_url": null, "media_mime_type": null}, {"id": 16806, "message_id": "3EB00F345330A29FFE8A43", "sender": "bot", "message_type": "document", "content": "2026041615355671.pdf", "created_at": "2026-04-16T14:36:14.792285", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4488/download", "media_mime_type": "application/pdf"}, {"id": 16808, "message_id": "3EB08A78F6D87E5BFE3CC7", "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-16T14:36:31.858577", "media_url": null, "media_mime_type": null}, {"id": 16809, "message_id": "3EB09BED336CB31A082511", "sender": "bot", "message_type": "document", "content": "2026041615355671.pdf", "created_at": "2026-04-16T14:36:47.543763", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4489/download", "media_mime_type": "application/pdf"}, {"id": 17503, "message_id": "AC88886DFB51D261D554DD897A5658BD", "sender": "user", "message_type": "text", "content": "السلام عليكم", "created_at": "2026-04-22T16:45:17.510198", "media_url": null, "media_mime_type": null}, {"id": 17504, "message_id": "bot_AC88886DFB51D261D554DD897A5658BD_4812", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-04-22T16:45:29.171325", "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 1343 in training_review_items