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": 7411, "message_id": "A56CEC2B4A24248F45181AAC45CEFD43", "sender": "bot", "message_type": "voice", "content": "[Voice message] وعليكم السلام، كلشي مزيان؟ بخير؟ هادشي لي متفقين عليه، اليوم مع السبعة.", "created_at": "2026-03-27T11:03:09.869010", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1530/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7422, "message_id": "AC0283DE02D17A3708E69C55343CB97C", "sender": "user", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Sf inxalah xokran", "created_at": "2026-03-27T12:23:51.606087", "media_url": null, "media_mime_type": null}, {"id": 7496, "message_id": "AC3F09E36A654C5F02E604881824B1F8", "sender": "user", "message_type": "text", "content": "Salam alikom", "created_at": "2026-03-27T14:49:22.316340", "media_url": null, "media_mime_type": null}, {"id": 7497, "message_id": "ACBA7851579E19A8DB41D2F8302B9BA6", "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 (Transliteration):**\n\"Khti, mzyana, bikhir? Gha ngoul lik, wach ne9dar had l-maw3id hada n-reddo tal t-tnin wlla t-tlat, hit ana gha nmchi 3end 3ziza, w tfhamini gha n-t3attal wlla chi haja, fhamtini?\"\n\n**English Translation (for context):**\n\"Sister, are you good? Fine? I wanted to tell you, can I push this appointment to Monday or Tuesday? Because I'm going to Aziza's [place], and you understand I might be late or something, you understand me?\"", "created_at": "2026-03-27T14:49:48.912099", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1560/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7499, "message_id": "A59CC4F735197369D5E42D843D889CF3", "sender": "bot", "message_type": "voice", "content": "[Voice message] السلام عليكم خالتي نزهة، مزيان؟ بخير؟ صافي، واخا، أنا غانقولها للطبيب.", "created_at": "2026-03-27T14:50:58.936814", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1561/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7565, "message_id": "AC8C253C634CC0F565E03978BD8B9F56", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**\"صافي الله يرحم والديك، شكرا بزاف، حيت بعيد بزاف والله العظيم ما قدرت.\"**\n\n**Transliteration (Latin script):**\n\"Safi allah yrham waldik, shukran bzzaf, hit b3id bzzaf wallahi l-3adim ma-qdert-ch.\"", "created_at": "2026-03-27T15:19:42.486282", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1588/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7566, "message_id": "bot_AC8C253C634CC0F565E03978BD8B9F56_5566", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، مرحبا! 😊\n\nفهمت، بغيتو تأجلو الموعد ديالكم للتنين أو التلات. غادي نبلغ الفريق باش يتواصلوا معاكم ويشوفوا شنو ممكن يديروا. شكرا بزاف على التوضيح. \n\nإذا كان عندكم شي استفسار آخر، حنا رهن الإشارة.", "created_at": "2026-03-27T15:20:21.854885", "media_url": null, "media_mime_type": null}, {"id": 8629, "message_id": "ACE09A73B99DBADF077673A5B942A65D", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-03-30T09:59:26.817306", "media_url": null, "media_mime_type": null}, {"id": 8630, "message_id": "AC10171AA5B43D0CAB10B178575D54C1", "sender": "user", "message_type": "voice", "content": "[Voice message] The audio is in Moroccan Darija. Here is the transcription:\n\n**Arabic Script:**\nوا سيفين، لاباس عليك؟ غير بغيت نقول ليك واش كاين الموعد اليوم، يا اليوم يا غدا. قول لي واش كاين الموعد اليوم نجي، ما كانش هي نجي غدا إن شاء الله.\n\n**Latin Script:**\n\"Wa Safin, labas 3lik? Ghir bghit ngoullik wash kayn l'mou3id liyoum, ya liyoum ya ghedda. Goulia wash kayn l'mou3id liyoum nji, makanch hya nji ghedda inshallah.\"\n\n**English Translation (for context):**\n\"Hey Safin, how are you? I just wanted to ask you if there is an appointment today, either today or tomorrow. Tell me if there is an appointment today and I’ll come; if not, then I'll come tomorrow, God willing.\"", "created_at": "2026-03-30T09:59:38.269782", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1881/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8631, "message_id": "bot_AC10171AA5B43D0CAB10B178575D54C1_7998", "sender": "bot", "message_type": "text", "content": "عندنا اليوم الاثنين على الساعة 09:00 أو 09:30، أو غدا الثلاثاء على الساعة 09:30 أو 10:00. شنو الوقت اللي مناسبك سيف الدين؟ 😊", "created_at": "2026-03-30T10:00:00.914322", "media_url": null, "media_mime_type": null}, {"id": 8757, "message_id": "ACBE60DF37941D7C2A1BD486749C9E8F", "sender": "user", "message_type": "text", "content": ".", "created_at": "2026-03-30T11:06:37.328446", "media_url": null, "media_mime_type": null}, {"id": 8758, "message_id": "bot_ACBE60DF37941D7C2A1BD486749C9E8F_7901", "sender": "bot", "message_type": "text", "content": "مرحبا بيك سيف الدين 😊\n\nوقت ما كنتي جاهز، غير قولي شنو الوقت اللي مناسبك من الأوقات اللي عطيتك، ونأكد ليك الموعد إن شاء الله.", "created_at": "2026-03-30T11:06:53.947454", "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 455 in training_review_items