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": 11056, "message_id": "3AEDFCAA2830AC44892C", "sender": "user", "message_type": "text", "content": "Hta nhar tnin onji inxllah", "created_at": "2026-04-02T18:46:40.858068", "media_url": null, "media_mime_type": null}, {"id": 11057, "message_id": "bot_3AEDFCAA2830AC44892C_1914", "sender": "bot", "message_type": "text", "content": "مرحبا حفصة! نهار الاثنين إن شاء الله غادي نكونو في انتظارك. إلا كنتي بغيت تحجزي موعد أو محتاجة شي حاجة أخرى، قولي لي باش نعاونك. نهارك مبروك! 😊", "created_at": "2026-04-02T18:46:55.839161", "media_url": null, "media_mime_type": null}, {"id": 11070, "message_id": "3A90BB29D02D419CF7CE", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-04-02T19:24:48.807167", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/2706/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11072, "message_id": "A54B68C39FA684FF1D45F9AA8584E9EE", "sender": "bot", "message_type": "voice", "content": "[Voice message] هنا غنبقاو، نهار يولد خاه، نهار يولد خاه، ها حفصة فوقاش تشرف، نو ماشي مشكل، خديت تا نهار التنين ويلة.", "created_at": "2026-04-02T19:25:08.217181", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/2707/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11073, "message_id": "3A105DC89E39EAF2BB56", "sender": "user", "message_type": "text", "content": "Hhhhhhhhhhhhh", "created_at": "2026-04-02T19:25:32.087494", "media_url": null, "media_mime_type": null}, {"id": 11074, "message_id": "3A1BB5DD0B949369668C", "sender": "user", "message_type": "text", "content": "Sf inxllah", "created_at": "2026-04-02T19:25:41.283412", "media_url": null, "media_mime_type": null}, {"id": 11076, "message_id": "3ABED4D429FD555A70AE", "sender": "user", "message_type": "text", "content": "Ja m3aj dk nhar xibi hsn mn ghoz", "created_at": "2026-04-02T19:25:56.108099", "media_url": null, "media_mime_type": null}, {"id": 11077, "message_id": "3AF54A6C9F50EC922037", "sender": "user", "message_type": "text", "content": "😍", "created_at": "2026-04-02T19:25:58.090370", "media_url": null, "media_mime_type": null}, {"id": 11078, "message_id": "A5C30E382754FAE21C850AF1B39BEFB3", "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 (Darija):**\n\"Wili safi ghir dji w aji w ghamdi 3winatek lghzala, rabi ykhalik, chokran bzaf.\"", "created_at": "2026-04-02T19:26:27.515809", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/2709/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 11079, "message_id": "3A76B6FB345A156F5548", "sender": "user", "message_type": "text", "content": "Sf khoyti", "created_at": "2026-04-02T19:26:44.263516", "media_url": null, "media_mime_type": null}, {"id": 12777, "message_id": "3AE75290A6C2D6E04C95", "sender": "user", "message_type": "text", "content": "Hy", "created_at": "2026-04-08T18:28:40.114322", "media_url": null, "media_mime_type": null}, {"id": 12778, "message_id": "bot_3AE75290A6C2D6E04C95_4709", "sender": "bot", "message_type": "text", "content": "مرحبا حفصة! 😊 وقتما كنتي جاهزة تجي مرحبا بك. إذا كنتي محتاجة شي حاجة ولا بغيت تحجزي موعد، قولي لي باش نعاونك. نهارك مبروك!", "created_at": "2026-04-08T18:29:08.041570", "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 867 in training_review_items