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": 47085, "message_id": "bot_ACA9501466D86004B0AEBBB848DFAAE5_4726", "sender": "bot", "message_type": "text", "content": "Je m’occupe de transmettre tout ça à l’équipe pour organiser au mieux leur passage.", "created_at": "2026-06-22T19:30:05.996732", "media_url": null, "media_mime_type": null}, {"id": 47086, "message_id": "ACAA64BB7BC4F9393757C916F6093440", "sender": "user", "message_type": "text", "content": "Seulement 2enfants svp", "created_at": "2026-06-22T19:30:55.681327", "media_url": null, "media_mime_type": null}, {"id": 47087, "message_id": "bot_ACAA64BB7BC4F9393757C916F6093440_2998", "sender": "bot", "message_type": "text", "content": "Merci pour la précision !", "created_at": "2026-06-22T19:31:07.130128", "media_url": null, "media_mime_type": null}, {"id": 47088, "message_id": "bot_ACAA64BB7BC4F9393757C916F6093440_1010", "sender": "bot", "message_type": "text", "content": "Pouvez-vous me donner les prénoms et âges des deux enfants, ainsi que la raison de leur visite et le créneau qui vous arrange ?", "created_at": "2026-06-22T19:31:07.172349", "media_url": null, "media_mime_type": null}, {"id": 47089, "message_id": "bot_ACAA64BB7BC4F9393757C916F6093440_1354", "sender": "bot", "message_type": "text", "content": "Cela nous permettra de préparer leur rendez-vous au mieux.", "created_at": "2026-06-22T19:31:07.208478", "media_url": null, "media_mime_type": null}, {"id": 47090, "message_id": "ACF485AC6ACA5F88FA19B5395E1E90DC", "sender": "user", "message_type": "text", "content": "Luna 8ans noussayba 7ans", "created_at": "2026-06-22T19:31:12.956425", "media_url": null, "media_mime_type": null}, {"id": 47091, "message_id": "bot_ACF485AC6ACA5F88FA19B5395E1E90DC_4631", "sender": "bot", "message_type": "text", "content": "Merci beaucoup !", "created_at": "2026-06-22T19:31:26.106288", "media_url": null, "media_mime_type": null}, {"id": 47092, "message_id": "bot_ACF485AC6ACA5F88FA19B5395E1E90DC_5270", "sender": "bot", "message_type": "text", "content": "Pour finaliser la demande, pouvez-vous me préciser le motif de la visite pour Luna et Noussayba (contrôle, douleur, soin particulier...) ainsi que vos disponibilités pour le rendez-vous ?", "created_at": "2026-06-22T19:31:26.162613", "media_url": null, "media_mime_type": null}, {"id": 47093, "message_id": "AC676CE01ECDD68F4F38D6B0319140C8", "sender": "user", "message_type": "text", "content": "Lina 8ans sanhaji et noussayba 7ans sanhaji", "created_at": "2026-06-22T19:31:37.071815", "media_url": null, "media_mime_type": null}, {"id": 47094, "message_id": "bot_AC676CE01ECDD68F4F38D6B0319140C8_2365", "sender": "bot", "message_type": "text", "content": "Merci pour la correction des prénoms et noms : Lina Sanhaji (8 ans) et Noussayba Sanhaji (7 ans).", "created_at": "2026-06-22T19:31:50.855432", "media_url": null, "media_mime_type": null}, {"id": 47095, "message_id": "bot_AC676CE01ECDD68F4F38D6B0319140C8_5539", "sender": "bot", "message_type": "text", "content": "Pouvez-vous me dire pourquoi vous souhaitez prendre rendez-vous pour elles (contrôle, douleur, soin spécifique...) et à quel moment vous seriez disponible ?", "created_at": "2026-06-22T19:31:50.889436", "media_url": null, "media_mime_type": null}, {"id": 47096, "message_id": "bot_AC676CE01ECDD68F4F38D6B0319140C8_3377", "sender": "bot", "message_type": "text", "content": "Dès que j’ai ces informations, je transmets la demande à l’équipe.", "created_at": "2026-06-22T19:31:50.920756", "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 3902 in training_review_items