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": 8276, "message_id": "A550C86000FBECD976C4EF476DE00B18", "sender": "bot", "message_type": "text", "content": "<reply_to>Salam alikom</reply_to> Alaikom salam", "created_at": "2026-03-29T12:22:22.018447", "media_url": null, "media_mime_type": null}, {"id": 8279, "message_id": "3EB065BA09F98FC1C974E0", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio, respecting the code-switching between Moroccan Darija and French:\n\n**Arabic Script:**\n\"Oui، سلام عليكم. عافاك جاوبوني l'assurance، عطاوني l'accord. واش ممكن عافاك تحسبو ليا داك الثمن اللي غادي يرجعو ليا؟ D'accord؟ وفـ la facture ديرو le montant total زعما عادي. وواش نقدر نجي ما بين لاربعا والجمعة ناخد rendez-vous؟ شكرا.\"\n\n**Latin Script (Phonetic):**\n\"Oui, salam aleykoum. Afak jawbouni l'assurance, 3taouni l'accord. Wash momkin afak t7asbou liya dak taman li ghadi yraj3ou liya? D'accord? W f la facture diro le montant total, za3ma 3adi. W wash n9dar nji ma bin l-arba3 w l-jam3a nakhod rendez-vous? Shokran.\"", "created_at": "2026-03-29T12:29:15.618656", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1804/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8280, "message_id": "A580127257B9D471CE3C4831B484A413", "sender": "bot", "message_type": "voice", "content": "[Voice message] ألو سيدي لاباس عليك مزيان؟ صافي واخا أملك، أنا غدا نرد عليك إن شاء الله.", "created_at": "2026-03-29T12:33:14.742937", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1805/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8282, "message_id": "3EB0AA0810F88EEA3BA5BB", "sender": "user", "message_type": "text", "content": "inchallah\nchokran", "created_at": "2026-03-29T12:36:51.197966", "media_url": null, "media_mime_type": null}, {"id": 9263, "message_id": "A56723D539F70DC4DD812543D04D5187", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nالسلام عليكم، كيف دايرة لاباس؟ مزيان، بخير؟ وقتاش بغيتي تاخد الـ rendez-vous باش ناخد الـ rendez-vous؟\n\n**Latin Script:**\nSalam alaykoum, kif dayra labas? Mezyan, bikhir? Wqtach bghiti takhoud rendez-vous bach nakhoud l-rendez-vous?", "created_at": "2026-03-31T09:43:56.836295", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2124/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9264, "message_id": "3AA35C53ED98B31BDA38", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script:**\nآه، وخا نتجمعوا فالعشية مع التلاتة ونص.\n\n**Latin Script (Darija):**\nAh, wakha ntjma3ou fl-3chiya m3a t-tlata w nuss.\n\n**Translation (for context):**\n\"Ah, okay, we'll meet in the afternoon at 3:30.\"", "created_at": "2026-03-31T09:48:42.328364", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2125/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9265, "message_id": "A507A0FC7A5260D7C978C43AE1895943", "sender": "bot", "message_type": "voice", "content": "[Voice message] ألو ألو سيدي، عندي عُمر جوايه فالعشية، لقاتني عندك الخمسة فالعشية مع التلاتة ونص خاوية.", "created_at": "2026-03-31T09:58:18.010553", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2126/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 9266, "message_id": "3EB0AD9FB9115697162F83", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ZAATER Basma*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 03 avril 2026* à *17:30* .\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لديكم موعد مع ** يوم *الجمعة 3 أبريل 2026* على الساعة *17:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-31T10:00:05.992578", "media_url": null, "media_mime_type": null}, {"id": 10499, "message_id": "3EB0C7E5355230D57B46CB", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ZAATER Basma*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 03 avril 2026* à *17:30* .\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لديكم موعد مع ** يوم *الجمعة 3 أبريل 2026* على الساعة *17:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-02T09:30:21.674599", "media_url": null, "media_mime_type": null}, {"id": 10746, "message_id": "A5E2D01A6B2A52921D83AAEABAD217D8", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-02T13:26:33.988924", "media_url": null, "media_mime_type": null}, {"id": 10770, "message_id": "3A9554AE4C07E1A3FFC6", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-04-02T13:37:03.792648", "media_url": null, "media_mime_type": null}, {"id": 10771, "message_id": "bot_3A9554AE4C07E1A3FFC6_9654", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 مرحبا بيكوم، إذا محتاجين أي مساعدة بخصوص الموعد ديالكم أو شي استفسار آخر، أنا هنا رهن الإشارة ديالكوم!", "created_at": "2026-04-02T13:38:02.645864", "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 639 in training_review_items