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": 39938, "message_id": "3A0920F31750EF7B84FC", "sender": "user", "message_type": "text", "content": "Vous êtes une intelligence artificielle ?", "created_at": "2026-06-06T23:47:10.762857", "media_url": null, "media_mime_type": null}, {"id": 39939, "message_id": "3A9481DF66F4299ECEE4", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-06T23:47:18.385167", "media_url": null, "media_mime_type": null}, {"id": 39940, "message_id": "3A32EAC0663683DD0808", "sender": "user", "message_type": "text", "content": "Je pense", "created_at": "2026-06-06T23:47:20.414316", "media_url": null, "media_mime_type": null}, {"id": 39941, "message_id": "bot_3A32EAC0663683DD0808_7757", "sender": "bot", "message_type": "text", "content": "Oui, c’est bien ça !", "created_at": "2026-06-06T23:47:28.511187", "media_url": null, "media_mime_type": null}, {"id": 39942, "message_id": "bot_3A32EAC0663683DD0808_960", "sender": "bot", "message_type": "text", "content": "Je suis un assistant virtuel du Centre Dentaire Tanger Bay, ici pour répondre à vos questions et vous orienter.", "created_at": "2026-06-06T23:47:28.574344", "media_url": null, "media_mime_type": null}, {"id": 39943, "message_id": "bot_3A32EAC0663683DD0808_2539", "sender": "bot", "message_type": "text", "content": "Si vous souhaitez parler directement à l’équipe médicale, dites-le-moi et je transmets votre demande.", "created_at": "2026-06-06T23:47:28.630853", "media_url": null, "media_mime_type": null}, {"id": 39944, "message_id": "3A8E7AB9DD6F04D304F2", "sender": "user", "message_type": "text", "content": "Contouring c’est quoi ?", "created_at": "2026-06-06T23:47:36.337441", "media_url": null, "media_mime_type": null}, {"id": 39945, "message_id": "3A5393A80E22C1422406", "sender": "user", "message_type": "text", "content": "Facette composite vous faites ?", "created_at": "2026-06-06T23:47:46.599242", "media_url": null, "media_mime_type": null}, {"id": 39946, "message_id": "bot_3A5393A80E22C1422406_8841", "sender": "bot", "message_type": "text", "content": "Le contouring dentaire, c’est une technique esthétique qui permet d’harmoniser la forme des dents pour améliorer le sourire, souvent en corrigeant de petites irrégularités.", "created_at": "2026-06-06T23:48:01.111763", "media_url": null, "media_mime_type": null}, {"id": 39947, "message_id": "bot_3A5393A80E22C1422406_9142", "sender": "bot", "message_type": "text", "content": "Pour les facettes, nous proposons principalement des facettes en céramique, qui sont plus durables et esthétiques. Les facettes composites ne sont pas notre recommandation principale, car elles nécessitent d’être refaites tous les 3 ans environ et impliquent de réduire la couche externe de la dent.", "created_at": "2026-06-06T23:48:01.156386", "media_url": null, "media_mime_type": null}, {"id": 39948, "message_id": "bot_3A5393A80E22C1422406_4745", "sender": "bot", "message_type": "text", "content": "L’orthodontie avec aligneurs invisibles et le blanchiment donnent souvent un résultat plus naturel et durable.", "created_at": "2026-06-06T23:48:01.195421", "media_url": null, "media_mime_type": null}, {"id": 39949, "message_id": "bot_3A5393A80E22C1422406_1540", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous une consultation pour voir ce qui conviendrait le mieux à votre sourire ?", "created_at": "2026-06-06T23:48:01.244272", "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 3238 in training_review_items