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": 10787, "message_id": "ACAB57B07229100151C1540613528915", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-04-02T14:04:48.968109", "media_url": null, "media_mime_type": null}, {"id": 10788, "message_id": "bot_ACAB57B07229100151C1540613528915_7862", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-04-02T14:05:00.581720", "media_url": null, "media_mime_type": null}, {"id": 10789, "message_id": "ACD306FECA044E178D99537F7DA8792D", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-04-02T14:05:08.281574", "media_url": null, "media_mime_type": null}, {"id": 10790, "message_id": "bot_ACD306FECA044E178D99537F7DA8792D_4117", "sender": "bot", "message_type": "text", "content": "بارك الله فيكوم 😊", "created_at": "2026-04-02T14:05:20.226215", "media_url": null, "media_mime_type": null}, {"id": 10797, "message_id": "A514C5ADAE3A2D94A00814D9667C16B9", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"ماشي مشكل مرحبا بك، بلحق باقي ليك واحد 600 درهم كنتي قلتي ليا غادوز تخلصها ليا البارح وما دزتيش، صافي ديك الساعة إلى قدرتي شوف غير إمتى ودوز عندي باش تخلص ليا ديك 600 درهم ومرحبا بك ف أي وقت.\"\n\n**Latin Script:**\n\"Machi mouchkil marhba bik, bel-heqq baqa lik wahed 600 dh kounti goulti liya gha douz tkhalles-ha liya l-bareh o ma douztich. Safi dik sa3a ila qderti chouf ghir imta o douz 3andi bach tkhalles liya dik 600 dh o marhba bik f ay waqt.\"", "created_at": "2026-04-02T14:08:59.725499", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2585/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10798, "message_id": "AC85B9BEC366A846FACCC27131440869", "sender": "user", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Hhh Ina 600", "created_at": "2026-04-02T14:13:07.106600", "media_url": null, "media_mime_type": null}, {"id": 10799, "message_id": "AC730E2D47B18CCBEF41BDF670AADEB0", "sender": "user", "message_type": "text", "content": "Rah 3titik 1000 dh", "created_at": "2026-04-02T14:13:13.261865", "media_url": null, "media_mime_type": null}, {"id": 10800, "message_id": "bot_AC730E2D47B18CCBEF41BDF670AADEB0_4682", "sender": "bot", "message_type": "text", "content": "اهاه مرحبا، شكرا على التوضيح. غادي نبلغ الفريق ديالنا بالموضوع وإن شاء الله يتواصلوا معكوم باش يتأكدو من التفاصيل.", "created_at": "2026-04-02T14:13:34.659444", "media_url": null, "media_mime_type": null}, {"id": 10801, "message_id": "A5908EBDF9C25EDAFA0DF8C157162FA4", "sender": "bot", "message_type": "voice", "content": "[Voice message] هذا هو تفريغ المقطع الصوتي باللهجة المغربية:\n\n**\"سمحي ليا آ سيدي، تخلطت مع واحد السيد مع عثماني تا هو، عليها قلتها لك. ولكن كتقولي السبت، أنا عطيتك رونديفو السبت مع الوحدة.\"**", "created_at": "2026-04-02T14:13:52.734253", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2586/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10802, "message_id": "AC6AE3933DA2A315C2E53F83A437EB4B", "sender": "user", "message_type": "text", "content": "200 radio\n200 istichaara\n600 : netwayage", "created_at": "2026-04-02T14:13:53.046248", "media_url": null, "media_mime_type": null}, {"id": 10803, "message_id": "A5247EF5196029A005D923759B44F350", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-02T14:13:58.646531", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2587/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10804, "message_id": "bot_AC6AE3933DA2A315C2E53F83A437EB4B_9717", "sender": "bot", "message_type": "text", "content": "مرحبا الله اودي، شكرا بزاف على التوضيح ديالكوم. غادي نبلغ الفريق الطبي ديالنا بهاد التفاصيل وإن شاء الله يتواصلوا معكوم قريبا.", "created_at": "2026-04-02T14:14:14.488043", "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 648 in training_review_items