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": 10669, "message_id": "3A837BECC80E70079B38", "sender": "user", "message_type": "text", "content": "Salut", "created_at": "2026-04-02T11:43:00.511150", "media_url": null, "media_mime_type": null}, {"id": 10670, "message_id": "bot_3A837BECC80E70079B38_4269", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib. Comment puis-je vous aider ?", "created_at": "2026-04-02T11:43:14.662683", "media_url": null, "media_mime_type": null}, {"id": 10671, "message_id": "3A7EBD94DC7F07E491FC", "sender": "user", "message_type": "text", "content": "Salut j’espère que vous allez bien", "created_at": "2026-04-02T11:43:23.445072", "media_url": null, "media_mime_type": null}, {"id": 10672, "message_id": "3AFAD7ABD3114AED3268", "sender": "user", "message_type": "document", "content": "CV Professionnel FATIMA ZOHRA EL HALOUI.pdf", "created_at": "2026-04-02T11:43:23.968512", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2561/download", "media_mime_type": "application/pdf"}, {"id": 10673, "message_id": "3ACB492C0F36C18D83DA", "sender": "user", "message_type": "text", "content": "Voilà mon CV", "created_at": "2026-04-02T11:43:24.118830", "media_url": null, "media_mime_type": null}, {"id": 10677, "message_id": "bot_3ACB492C0F36C18D83DA_1041", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour l’envoi de votre CV ! Je transmets votre candidature à notre équipe, ils reviendront vers vous très bientôt إن شاء الله 🙏🏻", "created_at": "2026-04-02T11:43:38.535486", "media_url": null, "media_mime_type": null}, {"id": 10679, "message_id": "3A4E8CF4305A9B05EAAB", "sender": "user", "message_type": "text", "content": "Merci beaucoup wlaah \nIncha allah puis-je rejoindre votre équipe", "created_at": "2026-04-02T11:44:41.481670", "media_url": null, "media_mime_type": null}, {"id": 10681, "message_id": "bot_3A4E8CF4305A9B05EAAB_9306", "sender": "bot", "message_type": "text", "content": "Merci à vous pour votre confiance ! Je viens de transmettre votre demande à l’équipe, ils vont étudier votre candidature et vous contacter directement إن شاء الله. Bonne chance à vous !", "created_at": "2026-04-02T11:44:53.126509", "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 625 in training_review_items