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": 8710, "message_id": "bot_3A568A74768E519B6D42_1772", "sender": "bot", "message_type": "text", "content": "تم تسجيل طلبك، أسامة 😊 الفريق غادي يتاصلوا بيك باش يأكدو الموعد على حساب les disponibilités. واش هاد الرقم اللي كتهضرو به هو اللي كيتاصلوا به معاك؟", "created_at": "2026-03-30T10:26:15.370882", "media_url": null, "media_mime_type": null}, {"id": 8711, "message_id": "3A33F5B8E706068FF505", "sender": "user", "message_type": "text", "content": "Yes 👍🏻", "created_at": "2026-03-30T10:26:33.371853", "media_url": null, "media_mime_type": null}, {"id": 8712, "message_id": "bot_3A33F5B8E706068FF505_307", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، غادي يتاصلوا بيك قريبا إن شاء الله 😊 إذا كان عندك أي سؤال آخر، مرحبا بك!", "created_at": "2026-03-30T10:26:43.795883", "media_url": null, "media_mime_type": null}, {"id": 11586, "message_id": "3EB0D984DF1DB06141CBBA", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: Unrelated (this is not a dental photo, x-ray, document, ID, or prescription).\n\n(b) Dental-specific visual description: Not applicable, as this is not a dental-related image. The image displays an illustrated person using a phone with a large calendar on a mobile device and a paper calendar in the background.\n\n(c) Visible text (OCR):\n- CALENDAR\n- Appointment Booking\n\n(d) Flag: No diagnostic terms, no mention of conditions, and no treatment recommendations present. The image appears to relate to scheduling or calendar use, not dental or medical context.\n\nUser message context: Bonjour BENMALEK OUSSAMA\r\nVous avez Rendez Vous avec Dr DINANI Hicham le samedi 04 avril 2026 à 09:30 .\r\nEn cas d'empêchement, veuillez contactre la réception pour prendre un autre Rendez Vous.\r\nMerci pour votre attention.\r\n \r\nمرحبًا\r\n  \r\nلديكم موعد مع الدكتور ديناني هشام يوم السبت 4 أبريل 2026 على الساعة 09:30. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-03T17:05:00.443787", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/2861/download", "media_mime_type": "image/jpeg"}, {"id": 11884, "message_id": "3EB0FA814BAE5B0086A51D", "sender": "bot", "message_type": "text", "content": "Bonjour BENMALEK OUSSAMA\r\nVous avez Rendez Vous avec Dr DINANI Hicham le samedi 11 avril 2026 à 12:00 .\r\nEn cas d'empêchement, veuillez contactre la réception pour prendre un autre Rendez Vous.\r\nMerci pour votre attention.\r\n \r\nمرحبًا\r\n  \r\nلديكم موعد مع الدكتور ديناني هشام يوم السبت 11 أبريل 2026 على الساعة 12:00. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-04T11:40:45.261569", "media_url": null, "media_mime_type": null}, {"id": 13731, "message_id": "3EB08C7D4A9A8EFACF23A2", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: Unrelated (this image does not appear to be a dental photo, x-ray, document, ID, or prescription).\n\n(b) Not applicable (not a dental image).\n\n(c) Visible text (OCR):\n- \"CALENDAR\"\n- \"Appointment Booking\"\n\n(d) Flag: This image shows an illustration of a person using a mobile device with a large calendar and appointment booking screen. There are no dental elements, and no diagnostic or treatment statements are made.\n\nUser message context: Bonjour BENMALEK OUSSAMA\r\nVous avez Rendez Vous avec Dr DINANI Hicham le samedi 11 avril 2026 à 12:00 .\r\nEn cas d'empêchement, veuillez contactre la réception pour prendre un autre Rendez Vous.\r\nMerci pour votre attention.\r\n \r\nمرحبًا\r\n  \r\nلديكم موعد مع الدكتور ديناني هشام يوم السبت 11 أبريل 2026 على الساعة 12:00. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-10T17:01:10.109631", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3535/download", "media_mime_type": "image/jpeg"}, {"id": 16984, "message_id": "3EB017ECEF4FCC76DDF608", "sender": "bot", "message_type": "image", "content": "Bonjour BENMALEK OUSSAMA\r\nVous avez Rendez Vous avec Dr DINANI Hicham le vendredi 17 avril 2026 à 18:15 .\r\nEn cas d'empêchement, veuillez contactre la réception pour prendre un autre Rendez Vous.\r\nMerci pour votre attention.\r\n \r\nمرحبًا\r\n  \r\nلديكم موعد مع الدكتور ديناني هشام يوم الجمعة 17 أبريل 2026 على الساعة 18:15. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-16T17:04:32.274297", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4568/download", "media_mime_type": "image/jpeg"}, {"id": 17057, "message_id": "3A7C9B9392527461BC3E", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-04-17T10:29:02.435972", "media_url": null, "media_mime_type": null}, {"id": 17058, "message_id": "3AEE365C2FC7894639B9", "sender": "user", "message_type": "text", "content": "Je veux reporter mon rendez-vous pour le samedi prochain", "created_at": "2026-04-17T10:29:22.528925", "media_url": null, "media_mime_type": null}, {"id": 17060, "message_id": "bot_3AEE365C2FC7894639B9_3396", "sender": "bot", "message_type": "text", "content": "Votre demande de report pour samedi prochain est bien enregistrée, l'équipe va vous contacter pour confirmer le nouveau rendez-vous إن شاء الله 🙏🏻", "created_at": "2026-04-17T10:29:34.092542", "media_url": null, "media_mime_type": null}, {"id": 17061, "message_id": "3AEF6C2184E874A3C027", "sender": "user", "message_type": "text", "content": "J’ai des contraintes de travail", "created_at": "2026-04-17T10:29:37.406200", "media_url": null, "media_mime_type": null}, {"id": 17062, "message_id": "bot_3AEF6C2184E874A3C027_3977", "sender": "bot", "message_type": "text", "content": "Merci pour la précision. Votre demande de report à samedi prochain, en raison de contraintes de travail, a bien été transmise à l’équipe. Ils vont vous recontacter très bientôt إن شاء الله 🙏🏻", "created_at": "2026-04-17T10:29:49.839731", "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 1279 in training_review_items