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": 38794, "message_id": "3A09B779DC4405133AB6", "sender": "user", "message_type": "text", "content": "reporter le rendez-vous à dans 10 jours", "created_at": "2026-06-04T11:00:30.483877", "media_url": null, "media_mime_type": null}, {"id": 38795, "message_id": "3ACFEC2DB068A51F3EE7", "sender": "user", "message_type": "text", "content": "comme sa j’ai somme", "created_at": "2026-06-04T11:00:37.817718", "media_url": null, "media_mime_type": null}, {"id": 38796, "message_id": "3AAD6340D028B1395377", "sender": "user", "message_type": "text", "content": "c’est bien 2300?", "created_at": "2026-06-04T11:00:40.818038", "media_url": null, "media_mime_type": null}, {"id": 38797, "message_id": "3AE6C82A0BF4347A3EB0", "sender": "user", "message_type": "text", "content": "et les extractions se font en anesthésie locale ou général ?", "created_at": "2026-06-04T11:01:13.206032", "media_url": null, "media_mime_type": null}, {"id": 38798, "message_id": "A5395524D4325EF142ED2A3269A1CDE0", "sender": "bot", "message_type": "text", "content": "<reply_to>et les extractions se font en anesthésie locale ou général ?</reply_to> Locale", "created_at": "2026-06-04T11:01:23.127827", "media_url": null, "media_mime_type": null}, {"id": 38799, "message_id": "3A6F105A4617261236ED", "sender": "user", "message_type": "text", "content": "<reply_to>Locale</reply_to> c’est la même que pour les détartrages ou une plus puissante", "created_at": "2026-06-04T11:04:13.750629", "media_url": null, "media_mime_type": null}, {"id": 38807, "message_id": "A59C416EAFD66787BF1E6F55C2A2499A", "sender": "bot", "message_type": "voice", "content": "[Voice message] \"Y'a pas des aides locales pour un détartrage ?\"", "created_at": "2026-06-04T11:29:08.263957", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10793/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 39628, "message_id": "3A85BA2299EBDCB60152", "sender": "user", "message_type": "text", "content": "si j’ai fait l’anesthésie", "created_at": "2026-06-06T02:06:21.163278", "media_url": null, "media_mime_type": null}, {"id": 39629, "message_id": "bot_3A85BA2299EBDCB60152_3484", "sender": "bot", "message_type": "text", "content": "Merci pour la précision !", "created_at": "2026-06-06T02:06:48.673539", "media_url": null, "media_mime_type": null}, {"id": 39630, "message_id": "bot_3A85BA2299EBDCB60152_7232", "sender": "bot", "message_type": "text", "content": "Je ne suis qu'un assistant virtuel, pas la vraie réceptionniste, et je ne voudrais surtout pas me tromper sur ce sujet.", "created_at": "2026-06-06T02:06:48.742455", "media_url": null, "media_mime_type": null}, {"id": 39631, "message_id": "bot_3A85BA2299EBDCB60152_3064", "sender": "bot", "message_type": "text", "content": "Je transmets votre question à l'équipe pour qu'ils puissent vous répondre précisément concernant l'anesthésie et les éventuelles aides locales pour le détartrage.", "created_at": "2026-06-06T02:06:48.804996", "media_url": null, "media_mime_type": null}, {"id": 39632, "message_id": "bot_3A85BA2299EBDCB60152_7192", "sender": "bot", "message_type": "text", "content": "Un conseiller va vous recontacter très bientôt إن شاء الله 😊", "created_at": "2026-06-06T02:06:48.853956", "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 3213 in training_review_items