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": 8788, "message_id": "ACC395A233431DCDDD6129F69FE7F7B7", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"صافي وشكراً، أصلاً إي دابا تصلتي بيا كنت عاد غنسقسيك. صافي، صافي شكراً، إن شاء الله يا ربي.\"\n\n**Latin Script (Darija):**\n\"Safi ou chokran, aslan i dabba tassalti biya kont 3ad gha nsaqsik. Safi, safi chokran, insha'Allah ya rabi.\"\n\n**English Translation (for context):**\n\"Okay, thank you. Actually, now that you called me, I was just about to ask you. Okay, okay, thank you, God willing, oh Lord.\"", "created_at": "2026-03-30T11:22:54.016377", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1935/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8793, "message_id": "bot_ACC395A233431DCDDD6129F69FE7F7B7_5873", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم، وأي وقت محتاجين شي حاجة حنا رهن الإشارة إن شاء الله 😊", "created_at": "2026-03-30T11:23:58.602235", "media_url": null, "media_mime_type": null}, {"id": 9927, "message_id": "A5866DEF66BE2FEEC59C37F1754C997C", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Arabic script (which is commonly used for Moroccan Darija) and a Latin script version for clarity:\n\n### **Arabic Script:**\nالسلام عليكم مدام، كيف صبحتي مزيانة؟ بخير، الصحة لاباس؟ بالنسبة للدوسي ديالك غادي يكمل معانا، صافي تفاهمنا مع كابيني أوراغ (Cabinet Aouragh) باش نتوما تكملو معانا إن شاء الله يا ربي.\n\n### **Latin Script (Transcription):**\n\"Assalamu alaykum madam, kif sbahti mzyana? Bekhir, ssiha labass? Benesba l’dossier dyalek ghadi ykemmel m3ana, safi tfahemna m3a cabinet Aouragh bash ntouma tkemmlou m3ana inshallah ya rbi.\"\n\n### **Translation (for context):**\n\"Peace be upon you Madam, how are you doing this morning? Fine? Is your health good? Regarding your file, it will continue with us; we have reached an agreement with Cabinet Aouragh so that you [all] will continue with us, God willing.\"", "created_at": "2026-04-01T09:19:39.941874", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2340/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9935, "message_id": "ACF0A0D8A64A23FFA75BD4CEAD6C3EDD", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Arabic script:\n\n**صباح الخير، لاباس؟ لاباس؟ الحمد لله. صافي أوكي. يعني نجي عندك نتينا باش تعمري ديك الورقة نتاع CNSS ياك؟ ونشوف الطبيب.**\n\n***\n\nAnd here is the transcription using Latin script (for better clarity on the pronunciation):\n\n**Sbah l'khir, labas? Labas? L'hamdullah. Safi okay. Ya'ni nji 'andek ntina bach t'ammri dik l-werqa nta' CNSS, yak? W-nchouf t-tbib.**", "created_at": "2026-04-01T09:33:48.540703", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2342/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9939, "message_id": "A5A4CC24A2A25820E4FFAF4E33A204DA", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio:\n\n\"يجي عندي أنا مرحبا به، شوف هو كان دار extraction و خصني نشوف لو شي rendez-vous ديال contrôle شي ربع ساعة، شي وقيت يكون مسالي، قولي باش نشوف لو rendez-vous باش يشوفو الطبيب زعما كيفاش بقى.\"", "created_at": "2026-04-01T09:39:38.325601", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2343/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9946, "message_id": "ACDB6087BD6288C4A4C926F97A6DDE5E", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"صافي وخا، أنا غادي نشوف شي وقيتة حيتاش مزيرة هاد ليام بالخدمة، ونشوف شي وقيتة، إيوا نشدكم إن شاء الله، إيوا صافي تهلاو.\"\n\n**Latin Script:**\n\"Safi wakha, ana ghadi nchouf chi weqita hitach mzira had lyam b l-khedma, o nchouf chi weqita, iwa nchedkom incha'allah, iwa safi t-hallaw.\"", "created_at": "2026-04-01T09:46:22.552473", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2345/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9976, "message_id": "A5279CB6A901269B2B8D2CA78C20629C", "sender": "bot", "message_type": "voice", "content": "[Voice message] سعداتك، مرحبا بك، مرحبا على الراس والعين.", "created_at": "2026-04-01T10:04:50.618626", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2353/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10838, "message_id": "AC5F801C4FE88E473BD5975D2B4D8DD0", "sender": "user", "message_type": "voice", "content": "[Voice message] بالتأكيد، إليك التفريغ النصي للمقطع الصوتي:\n\n\"السلام عليكم، لاباس؟ بخير؟ مزيان؟ واخا، شوف، غدا يجي عندكم راجلي مع الخمسة ونص إن شاء الله.\"", "created_at": "2026-04-02T14:27:57.592132", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2601/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10840, "message_id": "A559B9539F689F5254FB030742A01DFF", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-02T14:28:30.092000", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2602/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10842, "message_id": "bot_AC5F801C4FE88E473BD5975D2B4D8DD0_9855", "sender": "bot", "message_type": "text", "content": "شكرا بزاف على التواصل ديالكوم وعلى التفاصيل. غدا مع الخمسة ونص غادي نستقبلو راجلكوم إن شاء الله، ومرحبا بيه في أي وقت. إذا احتاجيتو شي حاجة أخرى أو بغيتو تبدلو الوقت، غير خبرونا 😊", "created_at": "2026-04-02T14:28:46.099948", "media_url": null, "media_mime_type": null}, {"id": 10846, "message_id": "AC06873FE197E2CE67A9F18EB870D696", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nلا، معودتش عيطت لي مور ديك شي، كانت عيطت لي وقالت لي هدا، بلحق لبارح نتينا قلتي لي غادي زعما يكمل معاكم، معرفتش، المهم تأكد وديك ساعة قولي شنو كاين، المهم هو بغا غدا فالخمسة ونص وصافي.\n\n**Latin Script:**\nLa, ma-3awdtsh 3iyytat li mor dik shi, kant 3iyytat li w-qalt li hada, bel-haqq l-bareh ntina qlti li ghadi za3ma ykemmel m3akom, ma-3raftsh, mohim t'aked u-dik sa3a qoli shnu kayn, mohim huwa bgha ghedda fel-khmsa u-ness u-safi.\n\n**English Translation (for context):**\n\"No, she didn't call me again after that; she had called me and told me this, but yesterday you told me that he would supposedly continue with you. I don't know. Anyway, confirm and then tell me what’s going on. Anyway, he wants tomorrow at 5:30 and that's it.\"", "created_at": "2026-04-02T14:29:30.980191", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2604/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10857, "message_id": "bot_AC06873FE197E2CE67A9F18EB870D696_2946", "sender": "bot", "message_type": "text", "content": "فهمتكوم، ولكن أنا غير مجرد مساعد آلي وماعنديش دراية بلي واقع برا هاد المحادثة. بعثنا طلبكوم للفريق وغادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-04-02T14:30:11.990027", "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 659 in training_review_items