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": 35759, "message_id": "3A14997A327F16673FF4", "sender": "user", "message_type": "text", "content": "Nhar lkhmis", "created_at": "2026-05-27T04:12:15.095925", "media_url": null, "media_mime_type": null}, {"id": 35873, "message_id": "A505E0BE4684D5C7B9AFD54CFA4BE7E1", "sender": "bot", "message_type": "text", "content": "Oui marha bik", "created_at": "2026-05-27T19:55:45.945892", "media_url": null, "media_mime_type": null}, {"id": 35874, "message_id": "A5C7528DF4C3629BA1962C246D0EBD92", "sender": "bot", "message_type": "text", "content": "Ms par rdv", "created_at": "2026-05-27T19:55:48.372534", "media_url": null, "media_mime_type": null}, {"id": 35882, "message_id": "3AC80904CDB0C904958D", "sender": "user", "message_type": "text", "content": "Ghada f 9 d sbah ??", "created_at": "2026-05-27T20:29:59.957628", "media_url": null, "media_mime_type": null}, {"id": 35902, "message_id": "A554786D2A0418C2A861A7C46FB0C61F", "sender": "bot", "message_type": "text", "content": "Tji youma", "created_at": "2026-05-27T21:06:32.269596", "media_url": null, "media_mime_type": null}, {"id": 35903, "message_id": "A54DFAC1638906A187103304E946A3AF", "sender": "bot", "message_type": "text", "content": "Db xwiya", "created_at": "2026-05-27T21:06:34.715425", "media_url": null, "media_mime_type": null}, {"id": 35910, "message_id": "3A2CE44E5A6CC39C2642", "sender": "user", "message_type": "text", "content": "Khadam daba ghansali hta l 6 d sbah", "created_at": "2026-05-27T21:29:10.227374", "media_url": null, "media_mime_type": null}, {"id": 35931, "message_id": "3ABEBCFA6A152BFA8D67", "sender": "user", "message_type": "text", "content": "??", "created_at": "2026-05-27T23:25:04.207945", "media_url": null, "media_mime_type": null}, {"id": 35934, "message_id": "3AE082A3C669978D1F23", "sender": "user", "message_type": "text", "content": "Ghatkuno f dik 7 d sbah fathin?", "created_at": "2026-05-27T23:39:52.618798", "media_url": null, "media_mime_type": null}, {"id": 35935, "message_id": "A5B4BD283873013E1BB86A1C41BE113D", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"سمح ليا عافاك، بغيت نقول ليك بلي كنخدمو بـ rendez-vous. إلى كان عندك زعما شي حريق ولا شي حاجة، كتعيط تاخد rendez-vous عاد باش تجي إن شاء الله يا ربي. مرحبا بيك.\"\n\n**Latin Script:**\n\"Smah liya afak, bghit ngoul lik belli kan khdmou b rendez-vous. Ila kan andek zaama chi hriq oula chi haja, kat ayet takhod rendez-vous aad bach tji in sha Allah ya rabi. Marhba bik.\"\n\n**Translation (for context):**\n\"Excuse me please, I wanted to tell you that we work by appointment. If you have any pain or anything, you call to take an appointment before coming, God willing. You're welcome.\"", "created_at": "2026-05-27T23:41:23.906961", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10083/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 36271, "message_id": "3AF82A1D803506F8571D", "sender": "user", "message_type": "text", "content": "Slm katkuno daba fathin?", "created_at": "2026-05-29T00:36:13.419082", "media_url": null, "media_mime_type": null}, {"id": 36272, "message_id": "bot_3AF82A1D803506F8571D_5487", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 دابا حنا مسدودين، كنخدمو من الاثنين حتى الجمعة من 09:00 حتى 19:00، والسبت من 09:00 حتى 14:00. واش بغيتو نحجزو ليكوم consultation؟", "created_at": "2026-05-29T00:36:51.261988", "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 2872 in training_review_items