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": 7705, "message_id": "3AB812BBFB897DD1BEB4", "sender": "user", "message_type": "text", "content": "U khlas", "created_at": "2026-03-27T18:15:25.068205", "media_url": null, "media_mime_type": null}, {"id": 7707, "message_id": "bot_3AB812BBFB897DD1BEB4_2579", "sender": "bot", "message_type": "text", "content": "سمح ليا، أنا غير assistant ديال الاستقبال وماعنديش دراية بهاد الموضوع. واش تبغي نبلغ دكتور Ayoub باش يتاصل بيك مباشرة؟", "created_at": "2026-03-27T18:15:44.834626", "media_url": null, "media_mime_type": null}, {"id": 7708, "message_id": "3AEF486038066F2E7D06", "sender": "user", "message_type": "text", "content": "Iwa daba hta nrja3 mara maja o salam", "created_at": "2026-03-27T18:15:44.985806", "media_url": null, "media_mime_type": null}, {"id": 7709, "message_id": "bot_3AEF486038066F2E7D06_248", "sender": "bot", "message_type": "text", "content": "واخا، إلى رجعتي وحتجتي شي حاجة أخرى، رهن الإشارة ديالك. نهارك مبروك! 😊", "created_at": "2026-03-27T18:15:53.169731", "media_url": null, "media_mime_type": null}, {"id": 7710, "message_id": "3ADD6CCDBEEFB8CBCB70", "sender": "user", "message_type": "text", "content": "Hitach dik warqa khssni nhoza mn xarika makaba3chi maxi bhal cnss", "created_at": "2026-03-27T18:16:18.777575", "media_url": null, "media_mime_type": null}, {"id": 7712, "message_id": "bot_3ADD6CCDBEEFB8CBCB70_2579", "sender": "bot", "message_type": "text", "content": "سمح ليا، أنا غير assistant ديال الاستقبال وماعنديش دراية بهاد الموضوع. واش تبغي نبلغ دكتور Ayoub باش يتاصل بيك مباشرة؟", "created_at": "2026-03-27T18:16:30.946531", "media_url": null, "media_mime_type": null}, {"id": 7713, "message_id": "3AA9A4666BBB901C0574", "sender": "user", "message_type": "text", "content": "Wjdtili l facturation nji moraha?", "created_at": "2026-03-27T18:16:31.343494", "media_url": null, "media_mime_type": null}, {"id": 7715, "message_id": "bot_3AA9A4666BBB901C0574_2579", "sender": "bot", "message_type": "text", "content": "سمح ليا، أنا غير assistant ديال الاستقبال وماعنديش دراية بهاد الموضوع. واش تبغي نبلغ دكتور Ayoub باش يتاصل بيك مباشرة؟", "created_at": "2026-03-27T18:16:43.964025", "media_url": null, "media_mime_type": null}, {"id": 7721, "message_id": "A59D2A5E124ECAC0C692311E26030BE2", "sender": "bot", "message_type": "text", "content": "Okk", "created_at": "2026-03-27T18:49:24.478393", "media_url": null, "media_mime_type": null}, {"id": 7730, "message_id": "A5D8956FF1CAD7EE4F9F9BEF0784D2EC", "sender": "bot", "message_type": "image", "content": "[Image analysis] (a) This appears to be a document.\n\n(b) Not applicable.\n\n(c) Visible text includes:\n\n```\nDr. EL OUAZZANI AYOUB \nChirurgien Dentiste\nSoins - Chirurgie - Prothèse \nOrthodontie - Implantologie \nRadiologie\n\nCENTRE DENTAIRE \n\nLISTE DES PAIEMENTS\nPatient(e) : CHOULLI HAFSA\n\nDate                  Mode règlement         Montant réglé \n15/03/2026            Espèce                 950,00 €\n14/03/2026            Espèce                 4 000,00 €\n13/03/2026            Espèce                 1 800,00 €\n12/03/2026            Espèce                 600,00 €\n12/03/2026            Espèce                 250,00 €\n31/05/2025            Espèce                 200,00 €\n17/04/2025            Espèce                 800,00 €\n17/04/2025            Espèce                 250,00 €\n\nLes honoraires       8 500,00 € \nTotal payé           8 850,00 €\nAvance               350,00 €\n\nPlace Mohammed V n°4 Ksar el-kebir (au dessus du Café Riyad)\nTél : 06 64 29 24 23 - 05 39 91 86 97\n```\n\n(d) Flag:", "created_at": "2026-03-27T18:56:40.373972", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/1616/download", "media_mime_type": "image/jpeg"}, {"id": 7801, "message_id": "3ABBBA567DBD12838EF1", "sender": "user", "message_type": "text", "content": "Devis jdid dyal 12/03 ?", "created_at": "2026-03-27T22:21:35.927582", "media_url": null, "media_mime_type": null}, {"id": 7802, "message_id": "bot_3ABBBA567DBD12838EF1_2579", "sender": "bot", "message_type": "text", "content": "سمح ليا، أنا غير assistant ديال الاستقبال وماعنديش دراية بهاد الموضوع. واش تبغي نبلغ دكتور Ayoub باش يتاصل بيك مباشرة؟", "created_at": "2026-03-27T22:21:54.628067", "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 335 in training_review_items