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": 46189, "message_id": "3A38DB5B84D314FECE55", "sender": "user", "message_type": "text", "content": "salam foqash kan rendezvous pour l extraction dent sagesse", "created_at": "2026-06-20T15:15:40.343445", "media_url": null, "media_mime_type": null}, {"id": 46190, "message_id": "3A4197D3118BE0244F8C", "sender": "user", "message_type": "text", "content": "ana nsit", "created_at": "2026-06-20T15:15:47.380433", "media_url": null, "media_mime_type": null}, {"id": 46289, "message_id": "A5587127DFA18493127D6C09BFF8EC8B", "sender": "bot", "message_type": "voice", "content": "[Voice message] صافي سي مزيان، شفتي؟ صافي دابا راني غادي نقول لك فوقاش شنو كاين، غدا إن شاء الله نقول لك.", "created_at": "2026-06-21T12:33:07.038002", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12824/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 46292, "message_id": "3A2C730B049183DBB596", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in both Arabic script (most common for Darija) and Latin script:\n\n**Arabic Script:**\n\"وخا شكرا عافاك، إيوا إلا قدرتي تصيفط ليا شي بلانينغ (planning) فوقاش خاصني ناكل هاد الدوا كولو.\"\n\n**Latin Script (Darija transliteration):**\n\"Wakha chokran 3afak, ewa ila qderti tsift liya chi planning foqach khassni nakoul had dwa kollou.\"\n\n**Translation (for context):**\n\"Okay, thank you please. If you could send me a schedule/planning of when I should take all this medicine.\"", "created_at": "2026-06-21T12:58:15.635206", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12825/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 46317, "message_id": "A586D079B93979D17FE72BFC1736BFE8", "sender": "bot", "message_type": "voice", "content": "[Voice message] غدا إن شاء الله أنا غادي نرد عليك، صافي؟", "created_at": "2026-06-21T13:23:32.065981", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12828/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 46319, "message_id": "3A828816C2D1E07377FF", "sender": "user", "message_type": "text", "content": "saf chokran", "created_at": "2026-06-21T13:27:25.880204", "media_url": null, "media_mime_type": null}, {"id": 46717, "message_id": "3EB0829CF82847316EE7E1", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*JAWAD  BOUYAZZIM*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 25 juin 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لديكم موعد مع ** يوم *الخميس 25 يونيو 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-22T13:09:52.997493", "media_url": null, "media_mime_type": null}, {"id": 46777, "message_id": "3A3BD440C3B83639B852", "sender": "user", "message_type": "text", "content": "foqash nkhod dwa", "created_at": "2026-06-22T13:42:54.721473", "media_url": null, "media_mime_type": null}, {"id": 46781, "message_id": "bot_3A3BD440C3B83639B852_538", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 بالنسبة للدوا، الدكتور غالباً غادي يشرح ليكوم شنو خاصكوم تاخدو وكيفاش تستعملوه من بعد الفحص فالعيادة.", "created_at": "2026-06-22T13:43:53.399753", "media_url": null, "media_mime_type": null}, {"id": 46782, "message_id": "bot_3A3BD440C3B83639B852_7768", "sender": "bot", "message_type": "text", "content": "إذا عطاكوم وصفة أو دوا بعد الموعد، تقدر تشريه مباشرة من الصيدلية.", "created_at": "2026-06-22T13:43:53.448380", "media_url": null, "media_mime_type": null}, {"id": 46783, "message_id": "bot_3A3BD440C3B83639B852_2483", "sender": "bot", "message_type": "text", "content": "إذا عندكوم شي سؤال خاص بالدوا أو واش خاصكوم تشريه قبل الموعد، من الأفضل تنتظر حتى تشوف الدكتور باش يعطيكوم التعليمات المناسبة لحالتكوم.", "created_at": "2026-06-22T13:43:53.493558", "media_url": null, "media_mime_type": null}, {"id": 46784, "message_id": "bot_3A3BD440C3B83639B852_4099", "sender": "bot", "message_type": "text", "content": "إذا محتاج توضيح أكثر أو عندكوم شي سؤال آخر، مرحبا بيكوم!", "created_at": "2026-06-22T13:43:53.531840", "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 3868 in training_review_items