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": 38960, "message_id": "A5A748DEA0DE31D7C120F353DD3F42B3", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-04T16:10:32.462226", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10837/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 38967, "message_id": "3AF99DBDC38B5948BD93", "sender": "user", "message_type": "text", "content": "Chnou ndiro?", "created_at": "2026-06-04T16:21:28.584002", "media_url": null, "media_mime_type": null}, {"id": 39019, "message_id": "A5CFEAF3119B941088718333D82E9F12", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-04T17:38:09.317755", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10865/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39020, "message_id": "3A05C1670A38A62F173E", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-04T17:40:19.006665", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10866/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39021, "message_id": "3AD282D2BE175DF7F39B", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-04T17:40:32.136259", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10867/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39022, "message_id": "A51FCABC504EC623E611FCCB114312E0", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-04T17:41:30.189758", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10868/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39023, "message_id": "3A6B6429AE88655B78EA", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-04T17:42:35.377520", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10869/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39025, "message_id": "A551A43F303E59136CBB86D9C7715FF1", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-04T17:54:35.571634", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10870/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43745, "message_id": "4A773F45C1D6A82117EA", "sender": "user", "message_type": "document", "content": "22670518.pdf", "created_at": "2026-06-15T14:43:32.109746", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12051/download", "media_mime_type": "application/pdf"}, {"id": 43746, "message_id": "4A1F35364779A164ED55", "sender": "user", "message_type": "document", "content": "Document(1).pdf", "created_at": "2026-06-15T14:43:51.627071", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12052/download", "media_mime_type": "application/pdf"}, {"id": 43748, "message_id": "3AB457A73F30664A9FA7", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio:\n\n\"Oui, سلام، لاباس؟ كلشي مزيان؟ عفاك حتى تعطي هادشي للطبيب باش يشرح pourquoi كايقولو en double emploi، واش les dents ولا شنو؟ المهم حتى تشوف مع الدوكتور وقوليا. ميرسي.\"", "created_at": "2026-06-15T14:50:00.950596", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12053/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43752, "message_id": "bot_3AB457A73F30664A9FA7_423", "sender": "bot", "message_type": "text", "content": "فهمتكوم، ولكن أنا غير مجرد مساعد آلي وماعنديش دراية بلي واقع برا هاد المحادثة. بعثنا طلبكوم للفريق وغادي يتواصلوا بيكوم إن شاء الله 🙏🏻", "created_at": "2026-06-15T14:50:21.713063", "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 3629 in training_review_items