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": 45361, "message_id": "A560AF8F68D29DCC24883025BD9391FC", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-18T14:40:18.725452", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12548/download", "media_mime_type": "video/mp4"}, {"id": 45362, "message_id": "A5A350BB59FFC7C16B057EB56EE95B9C", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-18T14:40:33.724055", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12549/download", "media_mime_type": "video/mp4"}, {"id": 45364, "message_id": "A582B1A16B3AF2DABACAA47E29CCEA66", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-18T14:43:03.531850", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12550/download", "media_mime_type": "video/mp4"}, {"id": 45365, "message_id": "A5E6E8EAE1DD8E825358AEBD52979024", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-18T14:43:05.599110", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12551/download", "media_mime_type": "video/mp4"}, {"id": 45366, "message_id": "A546E08A72C925C4065E137A26BF38B3", "sender": "bot", "message_type": "text", "content": "https://temu.to/k/e7uw35giu5l", "created_at": "2026-06-18T14:43:12.177939", "media_url": null, "media_mime_type": null}, {"id": 45374, "message_id": "3EB03B5AA4D4286B9436A1", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *3600,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-06-18T15:01:46.701955", "media_url": null, "media_mime_type": null}, {"id": 45375, "message_id": "3EB0F59BF6256D2F1FD6D4", "sender": "bot", "message_type": "document", "content": "2026061816005053.pdf", "created_at": "2026-06-18T15:02:03.750578", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12555/download", "media_mime_type": "application/pdf"}, {"id": 48561, "message_id": "A531A36959B7E60A4BB5A543B5E9EDCA", "sender": "bot", "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 (Transcription):**\nالسلام عليكم فاطمة الزهراء، كيف تينا مزيانة؟ بخير؟ صحة لاباس؟ كلشي بخير؟ سمحي لي فاطمة الزهراء عيطتي لي ياك؟ قولي هانا الغزالة.\n*As-salamu alaykum Fatima-Zahra, kif tina mzyana? Bikhir? Seha labas? Kolchi bikhir? Smehli Fatima-Zahra iyti li yak? Qoli ha ana lghazala.*\n\n**Notes on the dialect:**\nThe speaker is using a **Northern Moroccan dialect** (indicated by the use of \"كيف تينا\" / *kif tina* instead of the more general \"كيف دايرة\" / *kif dayra*).", "created_at": "2026-06-25T15:45:44.411139", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13512/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 49109, "message_id": "3AF3FED1DDC9924B3E67", "sender": "user", "message_type": "text", "content": "Salam hbiba", "created_at": "2026-06-26T16:11:20.395098", "media_url": null, "media_mime_type": null}, {"id": 49110, "message_id": "3ACFCA622CC9C6C15C24", "sender": "user", "message_type": "text", "content": "Stp envoie moi la facture de Yasine", "created_at": "2026-06-26T16:11:26.254771", "media_url": null, "media_mime_type": null}, {"id": 49111, "message_id": "3A2C170584097964FCFA", "sender": "user", "message_type": "text", "content": "Dakchi lisayb lih tbeb f darsa", "created_at": "2026-06-26T16:11:36.877674", "media_url": null, "media_mime_type": null}, {"id": 49115, "message_id": "bot_3A2C170584097964FCFA_2673", "sender": "bot", "message_type": "text", "content": "فهمتكوم، ولكن أنا غير مجرد مساعد آلي وماعنديش دراية بلي واقع برا هاد المحادثة. بعثنا طلبكوم للفريق وغادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-26T16:13:34.658989", "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 4039 in training_review_items