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": 45164, "message_id": "3A15658A41C022E49815", "sender": "user", "message_type": "text", "content": "oui", "created_at": "2026-06-18T11:34:56.684817", "media_url": null, "media_mime_type": null}, {"id": 45400, "message_id": "A5BC376EC17FC3FF6CAFB879585E45E2", "sender": "bot", "message_type": "text", "content": "Salam", "created_at": "2026-06-18T15:28:31.349465", "media_url": null, "media_mime_type": null}, {"id": 45401, "message_id": "A58B0883A39FBF47475015837BB08212", "sender": "bot", "message_type": "text", "content": "???", "created_at": "2026-06-18T15:29:01.415507", "media_url": null, "media_mime_type": null}, {"id": 45816, "message_id": "3AC4BC65A9C937BF32B4", "sender": "user", "message_type": "text", "content": "salam j’etait malade désolé je peut avoir un autre rendez vous s’il vous plait", "created_at": "2026-06-19T18:18:34.481816", "media_url": null, "media_mime_type": null}, {"id": 45817, "message_id": "bot_3AC4BC65A9C937BF32B4_1932", "sender": "bot", "message_type": "text", "content": "Aucun souci, j’espère que vous allez mieux.", "created_at": "2026-06-19T18:19:11.994529", "media_url": null, "media_mime_type": null}, {"id": 45818, "message_id": "bot_3AC4BC65A9C937BF32B4_9261", "sender": "bot", "message_type": "text", "content": "Pour reprogrammer votre rendez-vous, pouvez-vous me donner votre nom complet et me préciser le soin souhaité ainsi que vos disponibilités ?", "created_at": "2026-06-19T18:19:12.043550", "media_url": null, "media_mime_type": null}, {"id": 45819, "message_id": "3A2A4D02E7AFCF6250F0", "sender": "user", "message_type": "text", "content": "brahimi lounes c’était pour soigner les caries restantes", "created_at": "2026-06-19T18:19:54.902661", "media_url": null, "media_mime_type": null}, {"id": 45820, "message_id": "bot_3A2A4D02E7AFCF6250F0_3234", "sender": "bot", "message_type": "text", "content": "Merci beaucoup Brahimi Lounes ! Pour bien transmettre votre demande, à quel moment préférez-vous reprendre rendez-vous (jour et créneau horaire) ?", "created_at": "2026-06-19T18:20:06.526483", "media_url": null, "media_mime_type": null}, {"id": 45821, "message_id": "3A85640BAC41AA844A2F", "sender": "user", "message_type": "text", "content": "à partir de lundi plutôt de l’après midi", "created_at": "2026-06-19T18:20:34.461044", "media_url": null, "media_mime_type": null}, {"id": 45825, "message_id": "bot_3A85640BAC41AA844A2F_2149", "sender": "bot", "message_type": "text", "content": "Merci Brahimi Lounes, c’est bien noté !", "created_at": "2026-06-19T18:20:46.813085", "media_url": null, "media_mime_type": null}, {"id": 45826, "message_id": "bot_3A85640BAC41AA844A2F_4517", "sender": "bot", "message_type": "text", "content": "L’équipe va vérifier les disponibilités à partir de lundi après-midi et vous recontactera rapidement.", "created_at": "2026-06-19T18:20:46.871479", "media_url": null, "media_mime_type": null}, {"id": 45827, "message_id": "bot_3A85640BAC41AA844A2F_9163", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-19T18:20:46.923583", "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 3773 in training_review_items