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": 3928, "message_id": "3EB0157FD797EB56A96B79", "sender": "user", "message_type": "text", "content": "salut ma chèrie kif tina mziana", "created_at": "2026-03-13T11:49:15.891934", "media_url": null, "media_mime_type": null}, {"id": 3929, "message_id": "bot_3EB0157FD797EB56A96B79_4552", "sender": "bot", "message_type": "text", "content": "بارك الله فيك، نتوما بخير؟ 😊 كيف نقدر نعاونك اليوم؟", "created_at": "2026-03-13T11:49:26.293415", "media_url": null, "media_mime_type": null}, {"id": 3930, "message_id": "3EB0A1EEBF44EB1EC8B529", "sender": "user", "message_type": "text", "content": "barad sardto wahed l'empreinte pour aujourd'hui?", "created_at": "2026-03-13T11:49:36.631878", "media_url": null, "media_mime_type": null}, {"id": 3931, "message_id": "bot_3EB0A1EEBF44EB1EC8B529_4026", "sender": "bot", "message_type": "text", "content": "واخا، باش نقدر نعاونك، واش ممكن تقولي الإسم الكامل ديالك والوقت اللي مناسبك اليوم باش نبلغ الفريق؟ 😊", "created_at": "2026-03-13T11:49:46.986615", "media_url": null, "media_mime_type": null}, {"id": 4109, "message_id": "A5120B4CA59C357D7F3F716DADAD0F55", "sender": "bot", "message_type": "text", "content": "Full zircone", "created_at": "2026-03-13T14:22:40.961858", "media_url": null, "media_mime_type": null}, {"id": 4110, "message_id": "A5D9881B90F8062098659D2DE0CCFD76", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-13T14:22:53.475850", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/584/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10590, "message_id": "2A720898C5AC445C38AC", "sender": "user", "message_type": "text", "content": "Sf ghatjon wajda mea 2", "created_at": "2026-04-02T10:57:30.205666", "media_url": null, "media_mime_type": null}, {"id": 10592, "message_id": "2A1A066445E0709097A2", "sender": "user", "message_type": "text", "content": "Hta la couronne", "created_at": "2026-04-02T10:57:37.304105", "media_url": null, "media_mime_type": null}, {"id": 10593, "message_id": "A55EDA83E8E12C49BE31A92CB1A926B6", "sender": "bot", "message_type": "text", "content": "Ol", "created_at": "2026-04-02T10:57:45.030243", "media_url": null, "media_mime_type": null}, {"id": 10597, "message_id": "bot_2A1A066445E0709097A2_4764", "sender": "bot", "message_type": "text", "content": "فهمتك، ولكن أنا غير مجرد مساعد آلي وماعنديش دراية بلي واقع برا هاد المحادثة. بعثنا طلبك للفريق وغادي يتواصلوا بيك إن شاء الله 🙏🏻", "created_at": "2026-04-02T10:57:51.243280", "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 609 in training_review_items