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": 39091, "message_id": "ACA20C19C708429A7EBD8A7AB1941498", "sender": "user", "message_type": "text", "content": "C confirmé et je souhaite venir bien avant 17h30 ou cas où il y pas bcp de personne pour passer", "created_at": "2026-06-04T20:27:51.694228", "media_url": null, "media_mime_type": null}, {"id": 39092, "message_id": "AC51C21F864966F235E5D9545D545D49", "sender": "user", "message_type": "text", "content": "🙏", "created_at": "2026-06-04T20:27:56.621855", "media_url": null, "media_mime_type": null}, {"id": 39093, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_1241", "sender": "bot", "message_type": "text", "content": "Merci pour votre message Malika.", "created_at": "2026-06-04T20:28:34.083666", "media_url": null, "media_mime_type": null}, {"id": 39094, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_3673", "sender": "bot", "message_type": "text", "content": "Votre rendez-vous est bien noté pour vendredi 5 juin à 17h30.", "created_at": "2026-06-04T20:28:34.146275", "media_url": null, "media_mime_type": null}, {"id": 39095, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_6519", "sender": "bot", "message_type": "text", "content": "Si vous arrivez plus tôt, nous ferons de notre mieux pour vous recevoir rapidement selon l’affluence, mais la priorité reste aux rendez-vous déjà programmés.", "created_at": "2026-06-04T20:28:34.200236", "media_url": null, "media_mime_type": null}, {"id": 39096, "message_id": "bot_AC51C21F864966F235E5D9545D545D49_1435", "sender": "bot", "message_type": "text", "content": "N’hésitez pas à venir, on vous accueillera avec plaisir !", "created_at": "2026-06-04T20:28:34.255807", "media_url": null, "media_mime_type": null}, {"id": 39097, "message_id": "ACAC963563F1EED88656810E6F34F66A", "sender": "user", "message_type": "text", "content": "OK merci", "created_at": "2026-06-04T20:29:17.404526", "media_url": null, "media_mime_type": null}, {"id": 39098, "message_id": "bot_ACAC963563F1EED88656810E6F34F66A_5856", "sender": "bot", "message_type": "text", "content": "Avec plaisir Malika ! À très bientôt au centre 😊", "created_at": "2026-06-04T20:29:33.984682", "media_url": null, "media_mime_type": null}, {"id": 39221, "message_id": "ACD386DABC5EAC6761C96FC230ED5B98", "sender": "user", "message_type": "text", "content": "Svp j ai trouvé votre appel", "created_at": "2026-06-05T09:59:54.079784", "media_url": null, "media_mime_type": null}, {"id": 39222, "message_id": "bot_ACD386DABC5EAC6761C96FC230ED5B98_7562", "sender": "bot", "message_type": "text", "content": "Merci pour votre retour Malika.", "created_at": "2026-06-05T10:00:07.963504", "media_url": null, "media_mime_type": null}, {"id": 39223, "message_id": "bot_ACD386DABC5EAC6761C96FC230ED5B98_7420", "sender": "bot", "message_type": "text", "content": "Notre équipe vous a probablement contactée pour confirmer ou discuter de votre rendez-vous.", "created_at": "2026-06-05T10:00:08.027930", "media_url": null, "media_mime_type": null}, {"id": 39224, "message_id": "bot_ACD386DABC5EAC6761C96FC230ED5B98_1272", "sender": "bot", "message_type": "text", "content": "Si vous avez une question précise ou besoin d’assistance, n’hésitez pas à me le préciser et je transmets au médecin.", "created_at": "2026-06-05T10:00:08.095875", "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 3178 in training_review_items