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": 10437, "message_id": "A5D4C90737A712DD86B2D8A10AAF3804", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio:\n\n**Arabic Script:**\n\"لا نهار السبت عندي عامر، شوف شي وقت آخر من غير السبت وصافي.\"\n\n**Latin Script (Darija):**\n\"La nhar es-sabt 'andi 'amer. Shouf shi waqt akhor men ghir es-sabt o safi.\"", "created_at": "2026-04-02T08:16:55.376228", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2504/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10465, "message_id": "ACE775547E93512009CB5F6D5FC56310", "sender": "user", "message_type": "text", "content": "Khti ana khadam", "created_at": "2026-04-02T08:38:45.747189", "media_url": null, "media_mime_type": null}, {"id": 10466, "message_id": "ACBF115A0A9DDAE4F6711578EBBF3583", "sender": "user", "message_type": "text", "content": "Sf nxof xi had akhor", "created_at": "2026-04-02T08:38:55.085297", "media_url": null, "media_mime_type": null}, {"id": 10467, "message_id": "AC2AB0B148C6181870B3D345223C14F3", "sender": "user", "message_type": "text", "content": "Chokran", "created_at": "2026-04-02T08:39:01.520037", "media_url": null, "media_mime_type": null}, {"id": 10468, "message_id": "bot_AC2AB0B148C6181870B3D345223C14F3_6936", "sender": "bot", "message_type": "text", "content": "Merci pour votre retour et votre compréhension. Si vous souhaitez proposer un autre jour ou une plage horaire qui vous arrange, n’hésitez pas à me le dire et je le transmettrai à l’équipe pour organiser un nouveau rendez-vous إن شاء الله. \n\nBonne journée à vous !", "created_at": "2026-04-02T08:40:18.326760", "media_url": null, "media_mime_type": null}, {"id": 10469, "message_id": "AC602BF257355340DB6C1214FE6205B4", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-04-02T08:41:16.307253", "media_url": null, "media_mime_type": null}, {"id": 10470, "message_id": "bot_AC602BF257355340DB6C1214FE6205B4_7862", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-04-02T08:41:30.469778", "media_url": null, "media_mime_type": null}, {"id": 10478, "message_id": "A57E9C70E5E3BBEE4759AD5533C77CEE", "sender": "bot", "message_type": "voice", "content": "[Voice message] مافهمتش واش بغيتي تشوف شي حد آخر زعما شي نهار آخر ولا تشوف شي دكتور آخر مافهمتش.", "created_at": "2026-04-02T08:56:31.792787", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2530/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10785, "message_id": "ACA5241C2B5B35351CF18B54D5B809F4", "sender": "user", "message_type": "voice", "content": "[Voice message] قلت لك صافي أختي غادي نشوف شي دكتور آخور على حساب سينو السبت قلتي عندك رونديفو عامر وأنا الأوقات العادية ديالي كنخدم نورمال يعني ما عنديش الوقت عندي غير السبت، يعني غانشوف شي واحد آخور عاوتاني نتبع معاه.", "created_at": "2026-04-02T14:04:06.041864", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2583/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10786, "message_id": "bot_ACA5241C2B5B35351CF18B54D5B809F4_3117", "sender": "bot", "message_type": "text", "content": "شكرا بزاف على التوضيح، الله يسهل عليكوم فالمسار ديالكوم. إذا احتاجيتو شي حاجة أخرى ولا بغيتو ترجعو مرحبا بيكوم دائما 😊", "created_at": "2026-04-02T14:04:28.908654", "media_url": null, "media_mime_type": null}, {"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}]

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 643 in training_review_items