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": 42670, "message_id": "bot_3AA520F1E767A95AE5E4_6776", "sender": "bot", "message_type": "text", "content": "Bonsoir 😊 Il y a 3 types d’extraction pour la dent de sagesse : extraction simple (700DH), extraction partiellement incluse (1500DH), et extraction totalement incluse (2000DH).", "created_at": "2026-06-12T21:31:41.920603", "media_url": null, "media_mime_type": null}, {"id": 42671, "message_id": "bot_3AA520F1E767A95AE5E4_8060", "sender": "bot", "message_type": "text", "content": "Vous savez déjà de quel type il s’agit dans votre cas ?", "created_at": "2026-06-12T21:31:41.985607", "media_url": null, "media_mime_type": null}, {"id": 42988, "message_id": "3AB3C8BE85BDFEE22803", "sender": "user", "message_type": "text", "content": "Bonsoir, désoler j’ai récris mais j pas envoyer le message", "created_at": "2026-06-13T20:20:03.585408", "media_url": null, "media_mime_type": null}, {"id": 42989, "message_id": "bot_3AB3C8BE85BDFEE22803_9622", "sender": "bot", "message_type": "text", "content": "Pas de souci, merci pour votre retour 😊 Si vous avez des questions ou si vous souhaitez prendre rendez-vous, je suis là pour vous aider !", "created_at": "2026-06-13T20:20:14.973924", "media_url": null, "media_mime_type": null}, {"id": 42990, "message_id": "3AED3FE027B59D90A034", "sender": "user", "message_type": "text", "content": "<reply_to>Vous savez déjà de quel type il s’agit dans votre cas ?</reply_to> Du coup je sais pas", "created_at": "2026-06-13T20:20:18.963566", "media_url": null, "media_mime_type": null}, {"id": 42991, "message_id": "bot_3AED3FE027B59D90A034_6916", "sender": "bot", "message_type": "text", "content": "Pas de problème 😊 Le type d’extraction dépend vraiment de la position de la dent de sagesse.", "created_at": "2026-06-13T20:20:29.953675", "media_url": null, "media_mime_type": null}, {"id": 42992, "message_id": "bot_3AED3FE027B59D90A034_3950", "sender": "bot", "message_type": "text", "content": "Dr Haitham Boutaib pourra vous examiner et vous indiquer exactement ce qu’il faut faire lors d’une consultation.", "created_at": "2026-06-13T20:20:30.023085", "media_url": null, "media_mime_type": null}, {"id": 42993, "message_id": "bot_3AED3FE027B59D90A034_3855", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous prendre un rendez-vous ?", "created_at": "2026-06-13T20:20:30.091099", "media_url": null, "media_mime_type": null}, {"id": 42999, "message_id": "3A0BCFF8B7DD06A0DEBA", "sender": "user", "message_type": "text", "content": "D’accord, le soucis c’est que je serais dans à peut près 1 semaines à Tanger donc je sais pas j’ai pas envie de prendre rendez vous au final je viens pas, je vous tient au courant🥰", "created_at": "2026-06-13T20:23:31.670694", "media_url": null, "media_mime_type": null}, {"id": 43000, "message_id": "bot_3A0BCFF8B7DD06A0DEBA_5442", "sender": "bot", "message_type": "text", "content": "Merci pour votre message et votre honnêteté 😊 Aucun souci, tenez-nous simplement au courant quand vous serez prêt(e). On reste à votre disposition !", "created_at": "2026-06-13T20:23:43.528215", "media_url": null, "media_mime_type": null}, {"id": 43006, "message_id": "3AC50B2C412D1404BEAB", "sender": "user", "message_type": "text", "content": "Merciii", "created_at": "2026-06-13T20:24:28.831797", "media_url": null, "media_mime_type": null}, {"id": 43007, "message_id": "bot_3AC50B2C412D1404BEAB_8828", "sender": "bot", "message_type": "text", "content": "Avec plaisir 😊 Bonne soirée à vous !", "created_at": "2026-06-13T20:24:40.712989", "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 3528 in training_review_items