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": 9005, "message_id": "3EB0D69E9A402DBECBAC8D", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: This appears to be an illustration related to appointment scheduling. It is not a dental photo, x-ray, document, ID, or prescription.\n\n(b) Not applicable as this is not a dental image.\n\n(c) Visible text (OCR):\n- \"CALENDAR\"\n- \"Appointment Booking\"\n\n(d) Flag: No diagnostic terms, conditions, or treatment recommendations used. This image is unrelated to dental clinical observation.\n\nUser message context: Bonjour Charafi Ghariba\r\nVous avez Rendez Vous avec Dr DINANI Hicham le mardi 31 mars 2026 à 17: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لديكم موعد مع الدكتور ديناني هشام يوم الثلاثاء 31 مارس 2026 على الساعة 17:15. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-03-30T17:06:28.358480", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/2010/download", "media_mime_type": "image/jpeg"}, {"id": 9009, "message_id": "AC249451468DFE66D4FA50F33E2B4CB9", "sender": "user", "message_type": "text", "content": "Merci bcp", "created_at": "2026-03-30T17:06:58.405267", "media_url": null, "media_mime_type": null}, {"id": 14413, "message_id": "3EB091DB280DF02D478379", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: This appears to be an unrelated image (not a dental photo, x-ray, document, ID, or prescription). It is an illustration.\n\n(b) Observations: The image shows an illustrated person holding a smartphone in front of a calendar. There is also a large smartphone screen displaying a digital calendar and appointment booking information. The scene suggests scheduling or booking, with no dental structures or clinical content visible.\n\n(c) Visible text (OCR):\n- \"CALENDAR\"\n- \"Appointment Booking\"\n\n(d) Flag: \n- No diagnostic terms used.\n- No suggestion of conditions or recommendations for treatment.\n- This image is non-medical and not related to dental presentation.\n\nUser message context: Bonjour Charafi Ghariba\r\nVous avez Rendez Vous avec Dr DINANI Hicham le lundi 13 avril 2026 à 17: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لديكم موعد مع الدكتور ديناني هشام يوم الأثنين 13 أبريل 2026 على الساعة 17:00. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-12T17:03:39.376568", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3714/download", "media_mime_type": "image/jpeg"}, {"id": 17149, "message_id": "3EB07510F436381BD27590", "sender": "bot", "message_type": "image", "content": "Bonjour Charafi Ghariba\r\nVous avez Rendez Vous avec Dr DINANI Hicham le lundi 20 avril 2026 à 16: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لديكم موعد مع الدكتور ديناني هشام يوم الأثنين 20 أبريل 2026 على الساعة 16:00. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-04-19T17:03:30.761990", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4610/download", "media_mime_type": "image/jpeg"}, {"id": 17179, "message_id": "ACA5E760E2A7F03B131599C51DC205A9", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-04-19T17:28:09.396668", "media_url": null, "media_mime_type": null}, {"id": 17180, "message_id": "bot_ACA5E760E2A7F03B131599C51DC205A9_9753", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيك 😊 واش كاين شي حاجة أخرى نقدر نعاونكوم بها؟", "created_at": "2026-04-19T17:28:27.791084", "media_url": null, "media_mime_type": null}, {"id": 17181, "message_id": "ACE6BE9C8095B636D28F22A704A545A7", "sender": "user", "message_type": "text", "content": "لا شكراا 😊", "created_at": "2026-04-19T17:29:01.108985", "media_url": null, "media_mime_type": null}, {"id": 17182, "message_id": "bot_ACE6BE9C8095B636D28F22A704A545A7_675", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، وقتما حتاجيتيو شي حاجة حنا رهن الاشارة 😊 نهاركم مبروك!", "created_at": "2026-04-19T17:29:12.496842", "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 1307 in training_review_items