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": 13696, "message_id": "AC2416B8D29BB330419E44A685FA8576", "sender": "user", "message_type": "text", "content": "La mab9alich", "created_at": "2026-04-10T16:08:34.029376", "media_url": null, "media_mime_type": null}, {"id": 13700, "message_id": "A5E7153B90D47A06686485ED8394F492", "sender": "bot", "message_type": "text", "content": "7ta tjibolna", "created_at": "2026-04-10T16:11:14.232831", "media_url": null, "media_mime_type": null}, {"id": 13701, "message_id": "ACC44040EA991316EF05BDE6B03B4BE4", "sender": "user", "message_type": "text", "content": "Wakha merhba", "created_at": "2026-04-10T16:11:31.370267", "media_url": null, "media_mime_type": null}, {"id": 13702, "message_id": "A57C82C42B8745C5E57EB57814156877", "sender": "bot", "message_type": "text", "content": "Chokran", "created_at": "2026-04-10T16:11:42.916669", "media_url": null, "media_mime_type": null}, {"id": 20286, "message_id": "AC0448D874D276343E4013DC23904350", "sender": "user", "message_type": "text", "content": "Ok demain Nchalah", "created_at": "2026-04-28T17:44:28.923074", "media_url": null, "media_mime_type": null}, {"id": 20287, "message_id": "AC4EB50E017DF6B107FAC5E5DC80885C", "sender": "user", "message_type": "text", "content": "Sbah", "created_at": "2026-04-28T17:44:29.283909", "media_url": null, "media_mime_type": null}, {"id": 20288, "message_id": "bot_AC4EB50E017DF6B107FAC5E5DC80885C_3482", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 واش عندكوم موعد محجوز معانا، ولا كتبغيو تحجزو واحد جديد؟", "created_at": "2026-04-28T17:44:43.306220", "media_url": null, "media_mime_type": null}, {"id": 20289, "message_id": "A57A2B3B592D8BA498071FF697047609", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-04-28T17:45:56.235086", "media_url": null, "media_mime_type": null}, {"id": 20848, "message_id": "A52B95F6EC8D0794B2A201939DF57844", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**\"ألو السلام السي الحسين، لاباس؟ مزيان؟ بخير؟ خايل الله وجد ليا لافاكتور ديال هاد الشهر هدا، غدا إن شاء الله باش نخلصوك فيها. شكراً.\"**\n\n**Transliteration (Latin script):**\n\"Alo, s-salam si Lhoucine, labas? Mezyan? Bikher? Khay-llah ouejed liya l-facture dyal had ch-her hada, ghedda inch'Allah bach n-khalssouk fiha. Choukran.\"", "created_at": "2026-04-29T17:15:49.102400", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5913/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 21725, "message_id": "AC844526A338F7592009630E4C455A76", "sender": "user", "message_type": "document", "content": "SITUATION MOIS AVRIL DR HAITHAM BOUTAIB.pdf", "created_at": "2026-05-01T16:51:56.915939", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/6158/download", "media_mime_type": "application/pdf"}, {"id": 21726, "message_id": "ACD4999A017BECCD3D784857F6511576", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script):\n\n**السلام عليكم، كي داير بيخير؟ كلشي مزيان؟ شوف، المهم ها هي لاسيتياسيون لي عندكم، ديك ساعة شوفي مع الطبيب باش ينقص ليا ديك صومفازو لي عطاني، صافي؟ ديك ساعة قوليها لو باش ينقص ليا من المونطو ويخلي لو غيست.**\n\n***\n\n**Transliteration (Latin Script):**\n\"Salam alikom, ki dayer bikhir? Kolshi mzyan? Shouf, mhm ha hiya la situation li endkom, dik sa'a shoufi m'a tbib bash ynqoss lya dik Somvazo li 'tani, safi? Dik sa'a goliha lo bash ynqoss lya mel monto wi khalli le reste.\"", "created_at": "2026-05-01T16:52:20.342695", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/6159/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 21730, "message_id": "bot_ACD4999A017BECCD3D784857F6511576_8013", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق ديال المحاسبة بالطلب ديالك و الرسائل الصوتية، وغادي يتواصلوا معاكوم في أقرب وقت إن شاء الله بخصوص الفاتورة وطلب نقص مبلغ Somvazo من المجموع 🙏🏻", "created_at": "2026-05-01T16:52:55.560086", "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 1648 in training_review_items