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": 44692, "message_id": "ACD91C144E8499D5E4C788B1B4051126", "sender": "user", "message_type": "text", "content": "C ferier vous travaillez?", "created_at": "2026-06-16T20:42:23.971986", "media_url": null, "media_mime_type": null}, {"id": 44693, "message_id": "bot_ACD91C144E8499D5E4C788B1B4051126_9623", "sender": "bot", "message_type": "text", "content": "Oui, le mercredi 17 juin 2026, le Centre Dentaire Dr DINANI Hicham sera ouvert normalement l'après-midi. Les horaires habituels sont de 09h30 à 18h00 du lundi au jeudi.", "created_at": "2026-06-16T20:42:47.516460", "media_url": null, "media_mime_type": null}, {"id": 44694, "message_id": "bot_ACD91C144E8499D5E4C788B1B4051126_596", "sender": "bot", "message_type": "text", "content": "Vous pouvez donc venir à votre rendez-vous comme prévu.", "created_at": "2026-06-16T20:42:47.557627", "media_url": null, "media_mime_type": null}, {"id": 44695, "message_id": "AC40F6AECC0C6C8D9150CCE4111C1227", "sender": "user", "message_type": "text", "content": "15 h ?", "created_at": "2026-06-16T20:44:44.007581", "media_url": null, "media_mime_type": null}, {"id": 44696, "message_id": "bot_AC40F6AECC0C6C8D9150CCE4111C1227_2631", "sender": "bot", "message_type": "text", "content": "Oui, mercredi 17 juin 2026, le cabinet sera bien ouvert à partir de 15h00 jusqu’à 18h00. Vous pouvez venir l’après-midi à partir de cette heure-là, selon l’ordre d’arrivée.", "created_at": "2026-06-16T20:44:55.961793", "media_url": null, "media_mime_type": null}, {"id": 44697, "message_id": "AC0BE9F2462025E6B34B7BF44175C4F0", "sender": "user", "message_type": "text", "content": "Ok merci", "created_at": "2026-06-16T20:45:11.358550", "media_url": null, "media_mime_type": null}, {"id": 44698, "message_id": "bot_AC0BE9F2462025E6B34B7BF44175C4F0_6923", "sender": "bot", "message_type": "text", "content": "Avec plaisir 😊 Si vous avez d’autres questions, n’hésitez pas !", "created_at": "2026-06-16T20:45:30.963394", "media_url": null, "media_mime_type": null}, {"id": 49734, "message_id": "3EB0590EA5FC361B0D5C22", "sender": "bot", "message_type": "image", "content": "Bonjour EL IDRISSI RAWIYA\r\nVous avez Rendez Vous avec Dr DINANI Hicham le mercredi 01 juillet 2026  l'après-midi .\r\nselon l'ordre d'arrivéé\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لديكم موعد مع الدكتور ديناني هشام يوم الأربعاء 1 يوليوز 2026  بعد الزوال .حسب أسبقية الوصول\r\n في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-06-30T17:01:21.526749", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/13917/download", "media_mime_type": "image/jpeg"}, {"id": 49793, "message_id": "AC9B6D184E3AA3A4A3F8E2B2031348C8", "sender": "user", "message_type": "text", "content": "السلام عليكم\nاطلب التاجيل للاربعاء 8 يوليوز", "created_at": "2026-06-30T19:27:50.081756", "media_url": null, "media_mime_type": null}, {"id": 49795, "message_id": "bot_AC9B6D184E3AA3A4A3F8E2B2031348C8_2671", "sender": "bot", "message_type": "text", "content": "واخا بلغنا الفريق وغادي يتواصلوا بيكوم إن شاء الله باش يأكدو لكوم الموعد الجديد أو يقترحو عليكوم وقت مناسب 🙏🏻", "created_at": "2026-06-30T19:28:05.341870", "media_url": null, "media_mime_type": null}, {"id": 49796, "message_id": "AC6FFF1234A1CC4788B09C81791E013A", "sender": "user", "message_type": "text", "content": "شكرا", "created_at": "2026-06-30T19:28:22.716312", "media_url": null, "media_mime_type": null}, {"id": 49797, "message_id": "bot_AC6FFF1234A1CC4788B09C81791E013A_7204", "sender": "bot", "message_type": "text", "content": "العفو، مرحبا في أي وقت! إذا احتجتي أي مساعدة أخرى أنا رهن الإشارة.", "created_at": "2026-06-30T19:28:34.008104", "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 4118 in training_review_items