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": 12532, "message_id": "ACF0F174447E6BA040080F3618B13B0B", "sender": "user", "message_type": "text", "content": "Salam Ana chaimae", "created_at": "2026-04-07T15:45:09.527477", "media_url": null, "media_mime_type": null}, {"id": 12533, "message_id": "bot_ACF0F174447E6BA040080F3618B13B0B_1151", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، شيماء 😊 كيف يمكنني نعاونك اليوم؟ إذا كان عندك شي استفسار أو محتاجة شي خدمة من Centre Dentaire El Ouazzani، قولي لي.", "created_at": "2026-04-07T15:45:27.241524", "media_url": null, "media_mime_type": null}, {"id": 12620, "message_id": "ACC7842EEC8C83715512A5B284CF1206", "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**Latin Script (Transcription):**\n\"Salam o alaykoum khti, fin? Ana khti ma ‘aytitilchi, lhad s-semt hada, hna kantsnnawkoum ghir ntouma t’aytou, Allah yrhem ymmak.\"", "created_at": "2026-04-08T11:25:40.350724", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/3213/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 12621, "message_id": "bot_ACC7842EEC8C83715512A5B284CF1206_4293", "sender": "bot", "message_type": "text", "content": "سمح ليا، مفهمتش الرسالة حيث ما كانتش واضحة. واش تقدر توضح ليا شنو قصدك؟", "created_at": "2026-04-08T11:25:57.963933", "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 849 in training_review_items