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": 38090, "message_id": "bot_3A06411371088E342B49_5163", "sender": "bot", "message_type": "text", "content": "Merci pour votre remarque Wendel !", "created_at": "2026-06-02T15:50:23.796457", "media_url": null, "media_mime_type": null}, {"id": 38091, "message_id": "bot_3A06411371088E342B49_8095", "sender": "bot", "message_type": "text", "content": "Effectivement, le 2 mai est déjà passé.", "created_at": "2026-06-02T15:50:23.861254", "media_url": null, "media_mime_type": null}, {"id": 38092, "message_id": "bot_3A06411371088E342B49_8093", "sender": "bot", "message_type": "text", "content": "Voulez-vous qu’on fixe un nouveau rendez-vous à une date qui vous arrange ?", "created_at": "2026-06-02T15:50:23.927707", "media_url": null, "media_mime_type": null}, {"id": 38093, "message_id": "bot_3A06411371088E342B49_290", "sender": "bot", "message_type": "text", "content": "Si oui, dites-moi simplement vos disponibilités et le type de soin souhaité, et je transmets à l’équipe.", "created_at": "2026-06-02T15:50:23.996474", "media_url": null, "media_mime_type": null}, {"id": 38094, "message_id": "3ABCF43F7F21E7B4538D", "sender": "user", "message_type": "text", "content": "Samedi à 13h", "created_at": "2026-06-02T15:51:44.049815", "media_url": null, "media_mime_type": null}, {"id": 38095, "message_id": "bot_3ABCF43F7F21E7B4538D_8205", "sender": "bot", "message_type": "text", "content": "Merci Wendel !", "created_at": "2026-06-02T15:51:56.940093", "media_url": null, "media_mime_type": null}, {"id": 38096, "message_id": "bot_3ABCF43F7F21E7B4538D_2699", "sender": "bot", "message_type": "text", "content": "Pour bien transmettre votre demande, pouvez-vous me confirmer le type de soin ou la raison de votre visite samedi à 13h ?", "created_at": "2026-06-02T15:51:57.004649", "media_url": null, "media_mime_type": null}, {"id": 38097, "message_id": "bot_3ABCF43F7F21E7B4538D_5070", "sender": "bot", "message_type": "text", "content": "Dès que j’ai cette information, je fais suivre à l’équipe pour validation.", "created_at": "2026-06-02T15:51:57.067684", "media_url": null, "media_mime_type": null}, {"id": 38098, "message_id": "3A1E8A734266087AF902", "sender": "user", "message_type": "voice", "content": "[Voice message] Le type de soins je sais pas, moi toutes les deux semaines j’ai rendez-vous avec le docteur Mustafa pour serrer l’appareil dentaire.", "created_at": "2026-06-02T15:53:09.769639", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10627/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 38102, "message_id": "bot_3A1E8A734266087AF902_8401", "sender": "bot", "message_type": "text", "content": "Votre demande est transmise à l’équipe, Wendel.", "created_at": "2026-06-02T15:53:30.010065", "media_url": null, "media_mime_type": null}, {"id": 38103, "message_id": "bot_3A1E8A734266087AF902_2059", "sender": "bot", "message_type": "text", "content": "Ils vont vérifier la disponibilité pour samedi à 13h et reviendront vers vous rapidement.", "created_at": "2026-06-02T15:53:30.067928", "media_url": null, "media_mime_type": null}, {"id": 38104, "message_id": "bot_3A1E8A734266087AF902_1336", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-02T15:53:30.133262", "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 3050 in training_review_items