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": 8625, "message_id": "AC51EE8A728CF377BD64F1C96AF0E8B4", "sender": "user", "message_type": "voice", "content": "[Voice message] The transcription of the audio is as follows:\n\n**Arabic Script:**\n\"السلام عليكم، ça va؟ لاباس؟ بخير؟ الحمد لله، شكراً بزاف مرة أخرى.\"\n\n**Latin Script (Transliteration):**\n\"Assalamou alaykoum, ça va ? Labas ? Bikher ? Alhamdoulillah, choukran bzaf mra khera.\"", "created_at": "2026-03-30T09:33:50.586044", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1880/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8626, "message_id": "bot_AC51EE8A728CF377BD64F1C96AF0E8B4_695", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، نتوما بخير؟ 😊 إذا احتاجيتو شي حاجة أخرى أو عندكوم أي سؤال على الراديو أو العلاج، حنا رهن الاشارة.", "created_at": "2026-03-30T09:34:23.243032", "media_url": null, "media_mime_type": null}, {"id": 8627, "message_id": "AC491B2A7BA43D3B331CA81606C49FB0", "sender": "user", "message_type": "text", "content": "شكرا", "created_at": "2026-03-30T09:34:39.609706", "media_url": null, "media_mime_type": null}, {"id": 8628, "message_id": "bot_AC491B2A7BA43D3B331CA81606C49FB0_1757", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-03-30T09:34:50.647500", "media_url": null, "media_mime_type": null}, {"id": 8731, "message_id": "A5505EE5B20EE460A243EB919CDC8696", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**\"شوف هاد الفوطو بانوراميك كتقصار لمدة ست شهور، زعما سوا كمل معانا ولا مشى لعند شي طبيب آخر، إيلا طلب لو الراديو كيعطيه هادا بلا ما يعدل واحد آخر.\"**\n\n**Phonetic Transcription (Latin Script):**\n\"Shouf had l-photo panoramique kat-qsar l-mouddat stt ch-hor, za3ma swa kemmel m3ana wlla mcha l-3nd chi tbib akhor, ila tleb lou l-radio kay-3tih hada bla ma y3adel wahed akhor.\"", "created_at": "2026-03-30T10:45:34.623626", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1912/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8732, "message_id": "A5AAEBF5654878974A62B95884A1359A", "sender": "bot", "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:**\nIla khassatkom chi haja, qoloha li bach n3emmerha lkom.\n\n**Translation (for context):**\n\"If you need anything, tell me so I can fill it out for you.\"", "created_at": "2026-03-30T10:45:39.104331", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1913/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8736, "message_id": "3EB09901622C9C8BA13743", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-03-30T10:48:50.518603", "media_url": null, "media_mime_type": null}, {"id": 8737, "message_id": "3EB0BCE28AA3BC584DD3BF", "sender": "bot", "message_type": "document", "content": "2026033011480998.pdf", "created_at": "2026-03-30T10:49:03.489664", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1916/download", "media_mime_type": "application/pdf"}, {"id": 8739, "message_id": "ACE59E8582ADD28515E4EB474D6196E8", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script:**\n\"صفاء أختي بغيت نسولك غير على.. على l'mutuelle. آه كاينة. يقدر يدوزها لك في أي وقت ياك؟\"\n\n**Latin Script:**\n\"Safae khti bghit nswlk ghir 3la.. 3la l'mutuelle. Ah kyna. Y9der idowzha lik f ay we9t yak?\"\n\n**Translation (for context):**\n\"Safae, my sister, I just wanted to ask you about... about the insurance (mutuelle). Ah, it exists. He can process it for you at any time, right?\"", "created_at": "2026-03-30T10:54:14.066672", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1918/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8740, "message_id": "A5EB9AE224DD19F563748EC341C7FC92", "sender": "bot", "message_type": "voice", "content": "[Voice message] شنو باقا بين يديك؟", "created_at": "2026-03-30T11:00:42.110509", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1919/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8741, "message_id": "ACEEE97586828ECDF76D4063F626AA68", "sender": "user", "message_type": "voice", "content": "[Voice message] And the Genesis.", "created_at": "2026-03-30T11:00:57.523565", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1920/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8743, "message_id": "bot_ACEEE97586828ECDF76D4063F626AA68_8353", "sender": "bot", "message_type": "text", "content": "شنو بالضبط بغيتو تعرفو على l'mutuelle؟ واش كتهضرو على remboursement ولا شي إجراء آخر؟ وضحو ليا باش نقدر نعاونكوم أكثر.", "created_at": "2026-03-30T11:01:47.228874", "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 452 in training_review_items