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": 12285, "message_id": "A500EE0EA6AADFA6041F66F90EC20CC4", "sender": "bot", "message_type": "text", "content": "<reply_to>[Image]</reply_to> مرحبا بيك", "created_at": "2026-04-05T10:02:15.648778", "media_url": null, "media_mime_type": null}, {"id": 12288, "message_id": "A5CAC05BAFF99CB722524DF3C9473748", "sender": "user", "message_type": "text", "content": "ما عنديش تأمين حاليا", "created_at": "2026-04-05T10:02:30.566881", "media_url": null, "media_mime_type": null}, {"id": 12289, "message_id": "A560B76FBDF19B9488676E2D19325904", "sender": "user", "message_type": "text", "content": "جزاك الله خيرا", "created_at": "2026-04-05T10:02:41.569674", "media_url": null, "media_mime_type": null}, {"id": 12290, "message_id": "A52F2A7D87DD462BB2825975D6359970", "sender": "bot", "message_type": "voice", "content": "[Voice message] ماشِي مُشكل، مَرْحبا. جِي بَعْدا يْشُوفك الدُّكتور يْحَيّد لِيك المُشْكِل الّلي عَنْدك، ومْنِين يْكُون عَنْدك لـ\"assurance\" أجي عَنْدي نْعَمَّر لِيك.", "created_at": "2026-04-05T10:02:45.242886", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3089/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 12295, "message_id": "A5E410CD8F031A2D9A2487AC4971F2CC", "sender": "user", "message_type": "text", "content": "نحن وصلنا", "created_at": "2026-04-05T10:20:25.086424", "media_url": null, "media_mime_type": null}, {"id": 12303, "message_id": "A56B3B12A89BD660F58D19D9C77E7215", "sender": "bot", "message_type": "text", "content": "تمام", "created_at": "2026-04-05T10:24:19.909803", "media_url": null, "media_mime_type": null}, {"id": 12304, "message_id": "A594A4F5484218F910BF9DCE2613B01D", "sender": "bot", "message_type": "text", "content": "٥ دقايق", "created_at": "2026-04-05T10:24:27.427922", "media_url": null, "media_mime_type": null}, {"id": 12305, "message_id": "A5FD773D158827111F1A6FE57A51DC61", "sender": "user", "message_type": "text", "content": "شكرا لك", "created_at": "2026-04-05T10:24:46.749182", "media_url": null, "media_mime_type": null}, {"id": 12306, "message_id": "A56A1F74D112A78D3A04325BA9565573", "sender": "bot", "message_type": "text", "content": "العفو", "created_at": "2026-04-05T10:24:56.601685", "media_url": null, "media_mime_type": null}, {"id": 12951, "message_id": "A55995343510BBAAE2D9E0EDA73B1CB2", "sender": "user", "message_type": "text", "content": "السلام عليكم", "created_at": "2026-04-09T10:55:52.441749", "media_url": null, "media_mime_type": null}, {"id": 12953, "message_id": "A552128B0B5AB80177697C914114C2AC", "sender": "user", "message_type": "text", "content": "ممكن آتي غدا في الصباح", "created_at": "2026-04-09T10:56:04.943412", "media_url": null, "media_mime_type": null}, {"id": 12956, "message_id": "bot_A552128B0B5AB80177697C914114C2AC_9206", "sender": "bot", "message_type": "text", "content": "Merci pour votre message ! J’ai bien transmis votre demande d’urgence à l’équipe, ils vont vous recontacter très bientôt pour organiser la prise en charge. Notez que le rendez-vous ne sera confirmé qu’après leur retour direct auprès de vous 🙏🏻", "created_at": "2026-04-09T10:56:34.919515", "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 889 in training_review_items