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": 14694, "message_id": "ACD4BB1DC6E3D438A12FE078D60AEB74", "sender": "user", "message_type": "text", "content": "In chae alah", "created_at": "2026-04-13T09:18:04.529661", "media_url": null, "media_mime_type": null}, {"id": 14788, "message_id": "AC40C41A8345A12C2BA7EE740AC95B69", "sender": "user", "message_type": "text", "content": "Had simana in chae alah radi nakhdam sba7", "created_at": "2026-04-13T11:37:26.365378", "media_url": null, "media_mime_type": null}, {"id": 14789, "message_id": "ACA3AD485B0142FBF68F8E9BCFD8EBB6", "sender": "user", "message_type": "text", "content": "Ila kant chi 7aja moura 2", "created_at": "2026-04-13T11:37:36.063433", "media_url": null, "media_mime_type": null}, {"id": 14790, "message_id": "ACE1998CD3D30C49426BDB3DF3D453E9", "sender": "user", "message_type": "text", "content": "3 hakak", "created_at": "2026-04-13T11:37:39.751152", "media_url": null, "media_mime_type": null}, {"id": 14791, "message_id": "A5C89644DED6F4761B6AC2A0E760C0B8", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n**Arabic script:**\nوصافي أ أشرف، نشوفو شي غونديفو ف العشية إذن، ياك؟\n\n**Latin script:**\nW safi a Achraf, nchoufo chi rdv f l3chiya idan, yak?", "created_at": "2026-04-13T11:37:41.097373", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3792/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 14792, "message_id": "A5F307DFC0CFD7DC28D2C1EA66D9E1DF", "sender": "bot", "message_type": "voice", "content": "[Voice message] صافي، واخا أشرف، أنا غانقولها للدكتور ونرد عليك.", "created_at": "2026-04-13T11:37:48.260419", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3793/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 14793, "message_id": "AC260CE0B0A116949A4F5308D625D2F9", "sender": "user", "message_type": "text", "content": "Ayah", "created_at": "2026-04-13T11:37:49.141701", "media_url": null, "media_mime_type": null}, {"id": 14795, "message_id": "AC994B9CBA8A9B6A25BE19F186D40E3B", "sender": "user", "message_type": "text", "content": "Safi wakha lah yjazik bekher", "created_at": "2026-04-13T11:37:59.576375", "media_url": null, "media_mime_type": null}, {"id": 14822, "message_id": "A52186572449303FA3434E5AFF6422B9", "sender": "bot", "message_type": "text", "content": "Marhbaa", "created_at": "2026-04-13T12:17:10.134395", "media_url": null, "media_mime_type": null}, {"id": 15527, "message_id": "A5E51B058B574F50598F6B02EEA3E28A", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nالسلام عليكم أشرف، كي داير؟ لاباس عليك أشرف؟ نمشيو مع الستة ديال اليوم يا غدا يا بعدو، المهم قول ليا.\n\n**Latin Script:**\nSalam o alaykoum Achraf, ki dayer? Labas 3lik Achraf? Nemchiw m3a l-setta d lyouma ya ghedda ya be3dou, mohim goul liya.", "created_at": "2026-04-14T13:29:21.961861", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4036/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15529, "message_id": "AC6F78844225B26EB0EAE7668257A443", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\n\"السلام، كيدايرة بيخير؟ الله يحفظك، الله يجازيك بخير. حتى لستة؟ لا بزاف، ستة والله إلا بزاف بالله. علاش تلاتة ما مناسباش؟ تلاتة للربعة ما مناسباش؟ وتا لستة عرفتي الضلام تما كيف كيكون، ونحط الموتور تما برا، عرفتي كيف غا... واش غايبقا ولا ما غايبقاش؟\"\n\n**Latin Script (Darija Chat):**\n\n\"السلام، kidayra bikhir? Allah yhafdak, Allah yjazik bikhir. Htta l-setta? La bzzaf, setta wallah ila bzzaf billah. 3lash tlata ma mnasbash? Tlata l-rab3a ma mnasbash? Wa ta l-setta 3rfti dlam tma kif kikoun, w n7tt l-moteur tma berra, 3rfti kif gha... wash ghaybqa wlla ma ghaybqash?\"\n\n**Context/Translation (for clarity):**\nThe speaker is greeting a woman and discussing a meeting time. He feels that 6:00 PM is too late because it gets dark, and he is worried about leaving his motorcycle outside, fearing it might get stolen. He suggests meeting between 3:00 PM and 4:00 PM instead.", "created_at": "2026-04-14T13:40:21.810544", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4038/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15530, "message_id": "bot_AC6F78844225B26EB0EAE7668257A443_6478", "sender": "bot", "message_type": "text", "content": "شكرا بارك الله فيك على التوضيح 😊\n\nبالنسبة للموعد، فهمت أنكم كتفضلو الوقت بين 3 و 4 العصر وماشي مع الستة حيت كيولي الضلام وكاين مشكل ديال الموتور برا.\n\nغادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم باش يشوفو واش ممكن يبرمجو الموعد فهاد الوقت اللي اقترحتيو إن شاء الله 🙏🏻\n\nوقتما حتاجيتيو شي حاجة أخرى، حنا رهن الاشارة.", "created_at": "2026-04-14T13:42:01.586142", "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 1134 in training_review_items