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": 42411, "message_id": "A50D4CEBA4303DBDF09FA09FB9469031", "sender": "bot", "message_type": "text", "content": "Ok merci", "created_at": "2026-06-12T08:37:42.440044", "media_url": null, "media_mime_type": null}, {"id": 43582, "message_id": "AC407B255615B7FD3B5BF299DD59CA86", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**\"السلام عليكم، بخير؟ لاباس؟ مزيان؟ الحمد لله، هاديك لافاكتور نجيبها ولا باقي؟\"**\n\n**Transliteration (Latin Script):**\n\"Salam o alaikum, bekhir? Labas? Mzyane? Hamdollah... hadik la facture njibha wala baqi?\"\n\n**Translation (for context):**\n\"Peace be upon you, are you well? Is everything fine? Good? Praise be to God... regarding that invoice, should I bring it or not yet?\"", "created_at": "2026-06-15T10:55:17.167777", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12007/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43583, "message_id": "bot_AC407B255615B7FD3B5BF299DD59CA86_9405", "sender": "bot", "message_type": "text", "content": "لي فهمت، كتسول واش خاصك تجيب معاك la facture ولا باقي؟ الصراحة أنا مجرد مساعد آلي (روبو) وماعنديش تفاصيل الملف ديالكوم. غادي نبلغ الفريق الطبي ديالنا باش يجاوبوكوم مباشرة إن شاء الله.", "created_at": "2026-06-15T10:57:11.667975", "media_url": null, "media_mime_type": null}, {"id": 43609, "message_id": "A51064B8A7EC6205A22E93FCA1A63AC9", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n### **Arabic Script**\nصافي جيب ليا لافاكتور باش نخلصك، صافي. المهم صيفطها ليا مع أي واحد، أولا صيفطها ليا... فين ما، خليها ليا فـ لاريسيبسيون باش نخلصك.\n\n### **Latin Script (Darija/French)**\nSafi jib liya la facture bach nkhelsek, safi. L'mohim siftha liya m'a ay wahed, awla siftha liya... fin ma, khalliha liya f'la réception bach nkhelsek.\n\n---\n**Translation (for context):**\n*\"Okay, bring me the invoice so I can pay you, okay. Anyway, send it to me with anyone, or send it... wherever, just leave it for me at the reception so I can pay you.\"*", "created_at": "2026-06-15T11:25:40.105910", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12018/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43610, "message_id": "AC9BE3C7A928A5BEB917DEA8D63A4624", "sender": "user", "message_type": "voice", "content": "[Voice message] صافي مرحبا، ديك ساعة نصيفطك مع الدري ديال الزاج اللي غيجي يضرب الزاج تما، يجي يحط ديك ساعة تما. الله ييسر.", "created_at": "2026-06-15T11:30:27.688367", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12019/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43620, "message_id": "A570491D58917E861AA1B4DEB509FD8E", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-06-15T11:36:14.568171", "media_url": null, "media_mime_type": null}, {"id": 44657, "message_id": "A5309636E3DD4AA43B81DAE3DB41BEE1", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"سلام، كيدايرة، بيخير، الصحة لاباس؟ شوف، فوقاش غاتجي مورا ف الصوما (Soma)؟ راه عندي واجدين. المهم، تݣول ليهم باش لفلوس نعطيهم.\"\n\n**Latin Script (Phonetic):**\n\"Salam, kidayra? Bikhir? Sahha labas? Chouf, fouqach tji moura f Soma? Rah andi wajdin. Mohim, t'goul lihom bach le-flous n'atihom.\"\n\n**English Translation (for context):**\n\"Hello, how are you? Fine? Is your health good? Look, when are you coming by/to Soma? I have them ready. Anyway, tell them so I can give [them] the money.\"", "created_at": "2026-06-16T18:23:50.760986", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12301/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44661, "message_id": "AC7E259069987DC435E0602CB7390052", "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\n**Latin Script:**\nSafi ghda in shaa Allah ndouz l'andek in shaa Allah.\nIn shaa Allah ya rabi.", "created_at": "2026-06-16T18:28:02.397788", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12303/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44662, "message_id": "ACF153F151200E107CBF8EE60986C0ED", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n**Arabic Script:**\nسلام بخير؟ هانية؟ الأمور مزيانة؟ كلشي بخير؟ صافي غدا إن شاء الله نبان هنا، نبان ندوز عندك نجيب ليك الفاكتورة في يدي و نجي إن شاء الله يا ربي.\n\n**Latin Script:**\nSalam bikhir? Haniya? Amour maziana? Kolchi bikhir? Safi ghedda inshallah nban hna, nban ndouz andek njib lik l-faktoura f yeddi ou nji inshallah ya rabi.", "created_at": "2026-06-16T18:28:21.954854", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12304/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44716, "message_id": "A5401CD2626B199A0C4D2F32CC14CBFF", "sender": "bot", "message_type": "text", "content": "Sf", "created_at": "2026-06-17T08:47:48.256906", "media_url": null, "media_mime_type": null}, {"id": 47057, "message_id": "AC377B513F7A73F0C580939C60C90027", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-06-22T18:33:34.151018", "media_url": null, "media_mime_type": null}, {"id": 47058, "message_id": "bot_AC377B513F7A73F0C580939C60C90027_9630", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، أنا assistant ديال Centre Dentaire Tanger Bay وأنا هنا رهن الإشارة ديالكوم. واخا تقولولي شنو محتاجين 😊", "created_at": "2026-06-22T18:34:26.370717", "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 3895 in training_review_items