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": 18851, "message_id": "AC2DC9C614423B2BD59C470BE19FDE16", "sender": "user", "message_type": "text", "content": "à bientôt avec plaisir à bientôt", "created_at": "2026-04-24T17:56:07.658820", "media_url": null, "media_mime_type": null}, {"id": 18852, "message_id": "bot_AC2DC9C614423B2BD59C470BE19FDE16_7858", "sender": "bot", "message_type": "text", "content": "À très bientôt, ce sera un plaisir de vous accueillir ! 😊", "created_at": "2026-04-24T17:56:18.252438", "media_url": null, "media_mime_type": null}, {"id": 18853, "message_id": "AC6AF688D5F630F5D87E0E0F3AF82D1A", "sender": "user", "message_type": "text", "content": "également", "created_at": "2026-04-24T17:56:30.470486", "media_url": null, "media_mime_type": null}, {"id": 18854, "message_id": "bot_AC6AF688D5F630F5D87E0E0F3AF82D1A_1431", "sender": "bot", "message_type": "text", "content": "Merci beaucoup ! À très bientôt 😊", "created_at": "2026-04-24T17:56:40.922387", "media_url": null, "media_mime_type": null}, {"id": 18855, "message_id": "AC59A2CBB09A7A2252DAA3A8B3202680", "sender": "user", "message_type": "text", "content": "de rien", "created_at": "2026-04-24T17:56:50.655707", "media_url": null, "media_mime_type": null}, {"id": 18856, "message_id": "bot_AC59A2CBB09A7A2252DAA3A8B3202680_25", "sender": "bot", "message_type": "text", "content": "Merci à vous, passez une excellente journée ! 😊", "created_at": "2026-04-24T17:57:01.980645", "media_url": null, "media_mime_type": null}, {"id": 18857, "message_id": "ACC41ED40819DE6EEDD1A8185F82EAB9", "sender": "user", "message_type": "text", "content": "et vous passez une très bonne soirée", "created_at": "2026-04-24T17:57:11.444605", "media_url": null, "media_mime_type": null}, {"id": 18858, "message_id": "bot_ACC41ED40819DE6EEDD1A8185F82EAB9_3241", "sender": "bot", "message_type": "text", "content": "Merci beaucoup, c’est très gentil ! Bonne soirée à vous aussi 😊", "created_at": "2026-04-24T17:57:22.427737", "media_url": null, "media_mime_type": null}, {"id": 18859, "message_id": "AC9FC1795819765242F54F005F6FDB01", "sender": "user", "message_type": "text", "content": "c'est très très gentil de votre part", "created_at": "2026-04-24T17:57:31.713161", "media_url": null, "media_mime_type": null}, {"id": 18860, "message_id": "bot_AC9FC1795819765242F54F005F6FDB01_2113", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre gentillesse ! 😊", "created_at": "2026-04-24T17:57:43.184942", "media_url": null, "media_mime_type": null}, {"id": 18861, "message_id": "ACE64A7CE0F05F58E1C88FE13479063A", "sender": "user", "message_type": "text", "content": "est-ce qu'on va arrêter de se dire les gentillesse ou pas comme vous voulez", "created_at": "2026-04-24T17:58:08.212681", "media_url": null, "media_mime_type": null}, {"id": 18862, "message_id": "bot_ACE64A7CE0F05F58E1C88FE13479063A_743", "sender": "bot", "message_type": "text", "content": "C’est vrai, on peut s’arrêter là si vous le souhaitez ! Je reste à votre disposition si vous avez besoin de quelque chose 😊", "created_at": "2026-04-24T17:58:19.466046", "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 1427 in training_review_items