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": 40720, "message_id": "3EB048B6D27E1698F653F3", "sender": "bot", "message_type": "text", "content": "Bonjour BRIKI AYMANE (51519) , Centre dentaire Dr DINANI Hicham vous informe que votre travail est prêt veuillez nous appeler dur le 0537860203 pour prendre rendez-vous svp, Merci.", "created_at": "2026-06-09T10:31:29.890251", "media_url": null, "media_mime_type": null}, {"id": 40721, "message_id": "3EB0B55EAAB0A89CCF7612", "sender": "bot", "message_type": "text", "content": "Bonjour BRIKI AYMANE (51519) , Centre dentaire Dr DINANI Hicham vous informe que votre travail est prêt veuillez nous appeler dur le 0537860203 pour prendre rendez-vous svp, Merci.", "created_at": "2026-06-09T10:31:38.586947", "media_url": null, "media_mime_type": null}, {"id": 40769, "message_id": "2A85D31FA65A38EDDEF8", "sender": "user", "message_type": "text", "content": "Vous pouvez m’envoyer mon rendez-vous s’il vous plaît", "created_at": "2026-06-09T11:53:33.631982", "media_url": null, "media_mime_type": null}, {"id": 40782, "message_id": "ACBC4B35D285BC9F8C3DFC64C5EF5CE8", "sender": "bot", "message_type": "voice", "content": "[Voice message] السلام عليكم Monsieur Ayman، ça va؟ كلشي مزيان؟\n\nكان عندك normalement rendez-vous فـ le mois 4، le 8 avril، وعييت ما نتصل بك ما جاوبتينيش. المهم ما عليناش، غادي نديرو rendez-vous إن شاء الله الأربعاء الجاية إن شاء الله، غادي تكون ديك الساعة la date فيها le 17، le 17 في الصباح إن شاء الله، le 17 مع الـ 11، c’est bon؟ \n\nle 17 مع الـ 11 إن شاء الله، تجي عفاك وإلا ما كنتيش غادي تجي ولا، أعلمني قبل باش نعرف، نعرف زعما نعطي chance لـ patient آخر اللي ديجا كاينين فـ la liste d’attente.", "created_at": "2026-06-09T12:19:50.062880", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/11313/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40783, "message_id": "AC74D591C59A88892A2ACB5E17B55995", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (mixed with French):\n\n**Arabic Script:**\nولكن خاصك أوبليجي تجي حيت تعطلتي، خاصنا نشوفو لانبلون فين كاين باش ميكون شي ريسك ولا شي حاجة.\n\n**Latin Script:**\n\"Walakin khassk obligé tji hit t3atalti, khassna nchoufou l’implant fin kayn bach maykoun chi risque wala chi haja.\"\n\n**English Translation (for context):**\n\"But you absolutely must come because you're late; we need to see where the implant is so there isn't any risk or anything.\"", "created_at": "2026-06-09T12:19:57.744335", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/11314/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40787, "message_id": "2A65160D1A3EBFC71D5D", "sender": "user", "message_type": "text", "content": "Bien reçu 18/06/2026", "created_at": "2026-06-09T12:21:51.211703", "media_url": null, "media_mime_type": null}, {"id": 40788, "message_id": "ACAD7DF5EDFC5C42E7AFF7FA687E738E", "sender": "bot", "message_type": "text", "content": "17/06", "created_at": "2026-06-09T12:22:07.944613", "media_url": null, "media_mime_type": null}, {"id": 40790, "message_id": "2ABB6B7C23125896B6EC", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-09T12:22:15.320702", "media_url": null, "media_mime_type": null}, {"id": 44583, "message_id": "3EB05398739FCD53A30214", "sender": "bot", "message_type": "image", "content": "Bonjour BRIKI AYMANE (51519)\r\nVous avez Rendez Vous avec Dr DINANI Hicham le mercredi 17 juin 2026 à 11:45 .\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 على الساعة 11:45. في حالة وجود عائق.\r\nيرجى الاتصال بمكتب الاستقبال لتحديد موجد آخر.\r\nشكرا لتفهمكم\r\n05 37 86 02 03", "created_at": "2026-06-16T17:05:01.594985", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/12269/download", "media_mime_type": "image/jpeg"}, {"id": 44602, "message_id": "2ACD3F76A1222033B3D0", "sender": "user", "message_type": "text", "content": "No demain nchlah kyn ana", "created_at": "2026-06-16T17:11:11.775796", "media_url": null, "media_mime_type": null}, {"id": 44605, "message_id": "bot_2ACD3F76A1222033B3D0_5607", "sender": "bot", "message_type": "text", "content": "مرحبا AyMane 😊 شكرا على التأكيد، غادي نكونو في انتظارك غدا إن شاء الله على الساعة 11:45. مرحبا بيكوم!", "created_at": "2026-06-16T17:11:41.473905", "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 3688 in training_review_items