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": 35761, "message_id": "3A039848D4EC0C1CC469", "sender": "user", "message_type": "video", "content": "", "created_at": "2026-05-27T07:15:37.607461", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10052/download", "media_mime_type": "video/mp4"}, {"id": 35764, "message_id": "A5D1F3DB78CC8F490FE33ACF4CF2385C", "sender": "bot", "message_type": "voice", "content": "[Voice message] بالتأكيد، إليك التفريغ النصي للمقطع الصوتي:\n\n\"السلام عليكم مدام فاطمة، صباح الخير، عيد مبارك سعيد، باش ما كاتمناي إن شاء الله يا ربي، الله يعطيك ربي شي صحة جديدة وكل أي حاجة تمنيتيها.\"", "created_at": "2026-05-27T08:00:33.998577", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10054/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 35765, "message_id": "3A978E191927178C7B97", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"آمين أختي شيماء، سنتك مبروكة، تعيدي وتعاودي بّاش ما كتمناي إن شاء الله، بّاش ما كتمناي في حياتك كاملة إن شاء الله أختي، شكراً بزاف.\"\n\n**Latin Script (Transcription):**\n\"Amin khti Shaimae, santek mabrouka, t'eidi w t'awdi bach ma katmanay insha'Allah, bach ma katmanay f hyatek kamla insha'Allah khti, chokran bzaf.\"", "created_at": "2026-05-27T08:01:06.481771", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10055/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45712, "message_id": "A5B145EDEF737D49764D5896C76F7BEF", "sender": "bot", "message_type": "text", "content": "<reply_to>[Video]</reply_to> 😍", "created_at": "2026-06-19T15:29:13.374377", "media_url": null, "media_mime_type": null}, {"id": 45713, "message_id": "A54262214FA97E16E5EF4E4F1AF2A2C3", "sender": "bot", "message_type": "text", "content": "<reply_to>[Video]</reply_to> 😍", "created_at": "2026-06-19T15:29:14.426708", "media_url": null, "media_mime_type": null}, {"id": 45736, "message_id": "3AF201AD789D682651CE", "sender": "user", "message_type": "text", "content": "😘😘", "created_at": "2026-06-19T16:07:26.215891", "media_url": null, "media_mime_type": null}, {"id": 48361, "message_id": "3A23FCD650A8716FD244", "sender": "user", "message_type": "text", "content": "Sbh khr kif sbhti", "created_at": "2026-06-25T09:36:12.824586", "media_url": null, "media_mime_type": null}, {"id": 48362, "message_id": "bot_3A23FCD650A8716FD244_6142", "sender": "bot", "message_type": "text", "content": "صباح النور، بارك الله فيك، لاباس الحمد لله 😊 ونتي/نتا بخير؟", "created_at": "2026-06-25T09:36:35.746732", "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 3998 in training_review_items