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": 37582, "message_id": "A5AED35C43AA23900088E6D45ED4DD9D", "sender": "bot", "message_type": "text", "content": "A demain", "created_at": "2026-06-01T14:05:55.388815", "media_url": null, "media_mime_type": null}, {"id": 37597, "message_id": "ACDE651E4254C288FB08D0038A860645", "sender": "user", "message_type": "text", "content": "A demain", "created_at": "2026-06-01T14:34:25.490174", "media_url": null, "media_mime_type": null}, {"id": 37598, "message_id": "ACAC0E9F77FA45B0D771D70540EB4A96", "sender": "user", "message_type": "text", "content": "On n'a pas rendez vous encore", "created_at": "2026-06-01T14:34:37.367510", "media_url": null, "media_mime_type": null}, {"id": 37601, "message_id": "A5E9623213579DB3B49BBE2E1BEAE731", "sender": "bot", "message_type": "text", "content": "Pas encore", "created_at": "2026-06-01T14:36:05.569488", "media_url": null, "media_mime_type": null}, {"id": 37665, "message_id": "AC96A43F8C8EC6757B9E2FE6EEFA2366", "sender": "user", "message_type": "text", "content": "Ok  dis moi quand on avait le rendez vous, et on vais voir le money la bas", "created_at": "2026-06-01T15:09:06.326893", "media_url": null, "media_mime_type": null}, {"id": 37676, "message_id": "A5B9D5E2A58AAD9C3E75B6D4921B2C88", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-06-01T15:15:14.374529", "media_url": null, "media_mime_type": null}, {"id": 38774, "message_id": "AC65C555C081E88F19424CAD3AC75508", "sender": "user", "message_type": "text", "content": "<reply_to>So after  the holidays</reply_to> Bonjour\nJ'attend le rendez-vous!", "created_at": "2026-06-04T10:55:09.699611", "media_url": null, "media_mime_type": null}, {"id": 38775, "message_id": "bot_AC65C555C081E88F19424CAD3AC75508_8594", "sender": "bot", "message_type": "text", "content": "Merci pour votre message !", "created_at": "2026-06-04T10:55:25.897691", "media_url": null, "media_mime_type": null}, {"id": 38776, "message_id": "bot_AC65C555C081E88F19424CAD3AC75508_889", "sender": "bot", "message_type": "text", "content": "Votre rendez-vous avec Dr Haitham Boutaib est bien noté pour le mardi 26 mai 2026 à 11h00.", "created_at": "2026-06-04T10:55:25.972471", "media_url": null, "media_mime_type": null}, {"id": 38777, "message_id": "bot_AC65C555C081E88F19424CAD3AC75508_4113", "sender": "bot", "message_type": "text", "content": "Si vous souhaitez le modifier ou avez une question, n’hésitez pas à me le dire ou à contacter la réception.", "created_at": "2026-06-04T10:55:26.039766", "media_url": null, "media_mime_type": null}, {"id": 38778, "message_id": "AC70637879CE7FBD14B7F4C41A23E3FB", "sender": "user", "message_type": "text", "content": "<reply_to>Votre rendez-vous avec Dr Haitham Boutaib est bien noté pour le mardi 26 mai 2026 à 11h00.</reply_to> ?..a bot", "created_at": "2026-06-04T10:56:05.266343", "media_url": null, "media_mime_type": null}, {"id": 38779, "message_id": "bot_AC70637879CE7FBD14B7F4C41A23E3FB_6504", "sender": "bot", "message_type": "text", "content": "Oui, c’est bien un assistant virtuel qui vous répond ici. Si vous avez besoin d’aide ou souhaitez parler directement à l’équipe, dites-le-moi et je transmets votre demande sans souci.", "created_at": "2026-06-04T10:56:18.996704", "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 3131 in training_review_items