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": 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}, {"id": 10774, "message_id": "A513BD6DC7808D7EB90670B8C55F4CF4", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script):\n\n**السلام عليكم سيدي التازي، مزيان؟ بخير؟ الصحة لاباس؟ عيطت ليك على حساب كنكونفيرمي معاك على حساب الرونديفو د غدا وصافي.**\n\n**Transliteration (Latin script):**\n*Salam oualikom Sidi Tazi, mzyan? bikhir? seha labess? ayet lik 3la hsab kan confirmer m3ak 3la hsab l-rendez-vous d ghda w safi.*", "created_at": "2026-04-02T13:44:49.345553", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2581/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10777, "message_id": "3AB7E7BE56D83159E16D", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n\"Ouais, salam. Ouais, c'est confirmé pour demain inchallah.\"", "created_at": "2026-04-02T13:48:41.597847", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2582/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10778, "message_id": "bot_3AB7E7BE56D83159E16D_8109", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، تم التأكيد على الموعد ديالكوم غدا إن شاء الله 😊 مرحبا بيكوم!", "created_at": "2026-04-02T13:49:15.931289", "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 640 in training_review_items