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": 45767, "message_id": "bot_3A0DD9F99C9F56A49339_65", "sender": "bot", "message_type": "text", "content": "Notre équipe va vous contacter très prochainement pour vous proposer un créneau précis et confirmer le rendez-vous إن شاء الله 🙏🏻", "created_at": "2026-06-19T16:48:34.601381", "media_url": null, "media_mime_type": null}, {"id": 46447, "message_id": "3EB00FCE9956A60D6F0EAB", "sender": "bot", "message_type": "text", "content": "BONJOUR MME NADIA", "created_at": "2026-06-22T08:48:06.652048", "media_url": null, "media_mime_type": null}, {"id": 46449, "message_id": "3EB06418817FB56238EA60", "sender": "bot", "message_type": "text", "content": "RDV DE MME ZOHRA DEMAIN MARDI LE 23 JUIN A 17.45", "created_at": "2026-06-22T08:49:41.216955", "media_url": null, "media_mime_type": null}, {"id": 47169, "message_id": "3A0613A7221441E36C72", "sender": "user", "message_type": "text", "content": "Bonjour,\nMerci, mais n’y a pas de place plutôt, car c’est un peu trad pour elle, essaie entre 14h-16h SvP!", "created_at": "2026-06-23T00:08:03.304684", "media_url": null, "media_mime_type": null}, {"id": 47281, "message_id": "3EB0200279E8E6AFE41B8D", "sender": "bot", "message_type": "text", "content": "TU PEUX VENIR A 15.30", "created_at": "2026-06-23T10:02:12.586533", "media_url": null, "media_mime_type": null}, {"id": 47328, "message_id": "3EB0475A5BFFBC41FA0464", "sender": "bot", "message_type": "text", "content": "??", "created_at": "2026-06-23T11:11:27.936838", "media_url": null, "media_mime_type": null}, {"id": 47397, "message_id": "3AB05B82A54C28A547D4", "sender": "user", "message_type": "text", "content": "Demain à 16h, elle est disponible SVP confirmer rapidement vu le décalage horaire", "created_at": "2026-06-23T12:57:01.142691", "media_url": null, "media_mime_type": null}, {"id": 47465, "message_id": "AC24D126F9D3D9CD9DB4AB41F4680AAA", "sender": "bot", "message_type": "voice", "content": "[Voice message] اه نادية صفا؟ لباس؟ كلشي على خير؟\nنورمالمون حنا الطابليط ما كنكونوش هازينها كل ساعة راكي عارفة كنكونو خدامين مع لي باسيون داكشي علاش.\nنورمالمون صيفطي ليا النمرة ديال الوالدة أنا ديك ساعة نتواصل معاها بور لو غونديفو.\nغدا إن شاء الله فالعشية حنا عندنا من تلاتة ونص حتى لسبعة فالكابيني ولكن صون غونديفو فيكس، يعني ما كنخدموش بلي غونديفو فيكس.\nيعني إلا بغات تجي مع الربعة غتجي، إلا لقات دي باسيون قدامها غادي تساينهم.\nحنا من تلاتة ونص حتى لسبعة فالكابيني.", "created_at": "2026-06-23T15:38:17.085903", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/13150/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47466, "message_id": "AC04820633764A084DE3D366993DF9E6", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in both Latin and Arabic scripts, capturing the mix of Moroccan Darija and French:\n\n### **Latin Script:**\n\"Sinon sifeṭ li had n-nemra dyalha, walla sifeṭ li son numéro dyalha, n3eyyeṭ liha w nakhoud men 3endha l-me3loumat w nconfirmer m3aha l-rendez-vous.\"\n\n### **Arabic Script:**\n\"سينو صيفط ليا هاد النمرة ديالها، ولا صيفط ليا son numéro ديالها، نعيط ليها وناخد من عندها المعلومات ونكونفيرمي معاها l-rendez-vous.\"\n\n***\n\n**Translation (for context):**\n\"Otherwise, send me this number of hers, or send me her number, I'll call her and get the information from her and confirm the appointment with her.\"", "created_at": "2026-06-23T15:38:24.273413", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/13151/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47549, "message_id": "3A68627CA00B9AE79DE8", "sender": "user", "message_type": "text", "content": "Merci pour votre réponse, je comprends. Voix son numéro mais vaut mieux lui donner plutôt un Rv fixe +212 6 13 83 01 20", "created_at": "2026-06-23T20:53:07.895201", "media_url": null, "media_mime_type": null}, {"id": 48142, "message_id": "3A9C0F7D2878C1083ACF", "sender": "user", "message_type": "text", "content": "Bonjour,\nJe viens de parler avec ma mère, elles fait sa visite.\nPeux-tu STP me dire les traitements que Dr va faire et combien ?", "created_at": "2026-06-24T17:48:26.903623", "media_url": null, "media_mime_type": null}, {"id": 48144, "message_id": "bot_3A9C0F7D2878C1083ACF_174", "sender": "bot", "message_type": "text", "content": "Notre équipe va vérifier et vous recontacter très bientôt إن شاء الله 🙏🏻", "created_at": "2026-06-24T17:48:58.218518", "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 3990 in training_review_items