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": 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}, {"id": 8744, "message_id": "ACB1B1092328BEB6F4F62F23302D4861", "sender": "user", "message_type": "text", "content": "Oui remboursement", "created_at": "2026-03-30T11:02:36.260645", "media_url": null, "media_mime_type": null}, {"id": 8745, "message_id": "bot_ACB1B1092328BEB6F4F62F23302D4861_5226", "sender": "bot", "message_type": "text", "content": "Merci pour la précision. بالنسبة للـ remboursement مع l'mutuelle، عادةً كيعطيوكوم facture détaillée après le traitement، وكتقدرو تدفعوها مباشرة لشركة التأمين ديالكوم باش تسترجعو جزء من المصاريف حسب التغطية ديالكم.\n\nواش محتاجين تفاصيل على الوثائق المطلوبة أو طريقة تقديم الطلب؟", "created_at": "2026-03-30T11:02:49.290028", "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 453 in training_review_items