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": 15144, "message_id": "bot_A59F8F88BE242030B4D638658E088FA0_8444", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 واخا تعطيني الإسم الكامل ديالك؟", "created_at": "2026-04-13T19:09:26.483806", "media_url": null, "media_mime_type": null}, {"id": 15145, "message_id": "A5C7CC747283B14B37C9A12452B32916", "sender": "user", "message_type": "text", "content": "سناء الخقوني", "created_at": "2026-04-13T19:09:40.107265", "media_url": null, "media_mime_type": null}, {"id": 15146, "message_id": "bot_A5C7CC747283B14B37C9A12452B32916_5188", "sender": "bot", "message_type": "text", "content": "شكرا سناء الخقوني 😊 واش ممكن تقولي ليا واش كتفضلي شي وقت معين غدا؟ وصافي غادي نبلغ الفريق إن شاء الله. شنو الوقت اللي مناسبك؟", "created_at": "2026-04-13T19:09:53.459029", "media_url": null, "media_mime_type": null}, {"id": 15147, "message_id": "A516FCA76BE56B5A304F9D7432506ADD", "sender": "user", "message_type": "text", "content": "مع 11.30 او 12", "created_at": "2026-04-13T19:10:17.638934", "media_url": null, "media_mime_type": null}, {"id": 15151, "message_id": "bot_A516FCA76BE56B5A304F9D7432506ADD_4140", "sender": "bot", "message_type": "text", "content": "شكرا سناء الخقوني، وصل الطلب ديالك وغادي نبلغ الفريق باش يتواصلوا معاك ويأكدو الوقت اللي طلبتي إن شاء الله 😊\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-04-13T19:10:35.598987", "media_url": null, "media_mime_type": null}, {"id": 15152, "message_id": "A5A92234CC6B1F3015229FD88D38878B", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French:\n\n**Arabic Script:**\n\"سلام عليكم مدام سناء، كي دايرة مزيان؟ بخير؟ الصحة لاباس؟ مدام سناء غدا إن شاء الله في الصباح نرد عليك على حساب الرونديفو.\"\n\n**Latin Script (Transliteration):**\n\"Salamu Alaykom Madame Sanae, ki dayra mezian? Bekhir? Seha labas? Madame Sanae ghedda inchallah f sbe7 nrod 3lik 3la hsab r-rendez-vous.\"\n\n**English Translation (for context):**\n\"Peace be upon you, Madame Sanae. How are you doing? Are you well? Is your health good? Madame Sanae, tomorrow morning, God willing, I will get back to you regarding the appointment.\"", "created_at": "2026-04-13T19:11:09.473460", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3896/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15153, "message_id": "A57B810AAB6CC9C086A77460A93BB36D", "sender": "user", "message_type": "text", "content": "صافي واخا ان شاء الله", "created_at": "2026-04-13T19:11:31.432997", "media_url": null, "media_mime_type": null}, {"id": 15512, "message_id": "A54A526DDC8F1FFCD68D8AE7C1F3FC19", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script and Latin script) and French:\n\n**Arabic Script:**\nسلام، كيدايرة لاباس؟ بخير؟ الصحة لاباس؟ دابا مابقيتيش بغيتي rendez-vous ناخذوا ليك؟ غدا مع شمن ساعة كتنعسي؟\n\n**Latin Script:**\nSalam, kidayra labas? Bikhir? Seha labas? Daba mabaqitich bghiti rendez-vous nakhedou lik? Ghada m3a chmen sa3a katne3ssi?\n\n**Translation (for context):**\n\"Hello, how are you? Is everything okay? Good? Is your health okay? So, you no longer want me to get an appointment for you? Tomorrow, what time do you go to sleep?\"", "created_at": "2026-04-14T12:04:26.019695", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4028/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15950, "message_id": "A56F09524F7C61EE89F624C7DFAE3D4A", "sender": "bot", "message_type": "voice", "content": "[Voice message] صباح الخير، كي صبحتي مزيان؟ بخير؟ الصحة لاباس؟ سناء، آه، كنت بغيت ناخذ رُونديفو (RDV) وقُلت ليك لبارح زعما فوقاش ناخذ الرُّونديفو ما رديتيش عليا، شوفي شي وقت كيناسبك وقوليه ليا باش ناخذ الرُّونديفو.", "created_at": "2026-04-15T09:08:51.165064", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4167/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16682, "message_id": "A5B9A0988D65C38D6D00FC021640F5BD", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-16T11:47:15.805881", "media_url": null, "media_mime_type": null}, {"id": 16788, "message_id": "A5344CB098AD996E3E462C233192BB71", "sender": "user", "message_type": "text", "content": "سلام انا غنأجل ان شا الله", "created_at": "2026-04-16T14:05:56.386193", "media_url": null, "media_mime_type": null}, {"id": 16792, "message_id": "bot_A5344CB098AD996E3E462C233192BB71_5346", "sender": "bot", "message_type": "text", "content": "واخا سناء، بلغنا الفريق وغادي يتواصلوا بيك إن شاء الله 🙏🏻 يلا بغيتي تحددي موعد جديد فالمستقبل، غير تواصلي معانا وقتما بغيتي.", "created_at": "2026-04-16T14:06:35.675482", "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 1266 in training_review_items