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": 6633, "message_id": "ACE00A1372A1B726702CE2CB7399638C", "sender": "bot", "message_type": "text", "content": "ننهي الى علم مرضانا الكرام ان يوم عيد الفطر بالمغرب غدا الجمعة 20 مارس و بالتالى فإن موعدكم غدا سيلغى،  و سيتواصل معكم فريقنا فور العودة يوم الاثنين 30 مارس لترتيب مواعيدكم وضمان استقبالكم في أفضل الظروف.\nشكراً لثقتكم وتفهمكم.", "created_at": "2026-03-19T19:28:04.641965", "media_url": null, "media_mime_type": null}, {"id": 6634, "message_id": "AC4B62EEFB71AD029305A4D7D24216D6", "sender": "bot", "message_type": "text", "content": "Docteur nssift had le msg lnas Li andhom rdv", "created_at": "2026-03-19T19:29:22.211155", "media_url": null, "media_mime_type": null}, {"id": 6635, "message_id": "3A4D4BE3C05473F23E25", "sender": "user", "message_type": "text", "content": "Ouii", "created_at": "2026-03-19T19:29:33.279267", "media_url": null, "media_mime_type": null}, {"id": 11064, "message_id": "ACE1AB5CBD58E83F6BA41B4A43A2F6B6", "sender": "bot", "message_type": "document", "content": "Document.pdf", "created_at": "2026-04-02T19:00:26.431545", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/2700/download", "media_mime_type": "application/pdf"}, {"id": 12559, "message_id": "3A942478835DB570ABA9", "sender": "user", "message_type": "text", "content": "Bonsoir", "created_at": "2026-04-07T19:12:39.910588", "media_url": null, "media_mime_type": null}, {"id": 12560, "message_id": "owner_8a76f95b752d4144b3168ec867efb958", "sender": "bot", "message_type": "text", "content": "Bonsoir 😊 Comment puis-je vous aider aujourd'hui au Centre Dentaire Dr DINANI Hicham ?", "created_at": "2026-04-07T19:13:44.626912", "media_url": null, "media_mime_type": null}, {"id": 12561, "message_id": "3A0148C70F09A4F65A5A", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، اختي عافاك بغيت واحد الرونديفو لغدا إن شاء الله.", "created_at": "2026-04-07T19:14:10.059202", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/3199/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 12562, "message_id": "bot_3A0148C70F09A4F65A5A_2078", "sender": "bot", "message_type": "text", "content": "كنعتدر، مفهمتش الرسالة الصوتية بالضبط. واش تقدر توضح ليا شنو قصدك؟", "created_at": "2026-04-07T19:14:24.878288", "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 834 in training_review_items