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": 46647, "message_id": "bot_AC938DC7E89E39CAEB455523D0870FD7_4156", "sender": "bot", "message_type": "text", "content": "Merci pour votre intérêt 😊 Je ne peux pas fixer directement les rendez-vous, mais je peux transmettre votre demande à l’équipe pour qu’ils vous contactent rapidement.", "created_at": "2026-06-22T11:38:54.546822", "media_url": null, "media_mime_type": null}, {"id": 46648, "message_id": "bot_AC938DC7E89E39CAEB455523D0870FD7_3438", "sender": "bot", "message_type": "text", "content": "Souhaitez-vous qu’on vous rappelle pour convenir de la date la plus proche ?", "created_at": "2026-06-22T11:38:54.594311", "media_url": null, "media_mime_type": null}, {"id": 46649, "message_id": "AC783DC9A6E59310881B50B6424E4815", "sender": "user", "message_type": "text", "content": "Une réponse via WhatsApp si possible", "created_at": "2026-06-22T11:39:18.390106", "media_url": null, "media_mime_type": null}, {"id": 46650, "message_id": "bot_AC783DC9A6E59310881B50B6424E4815_73", "sender": "bot", "message_type": "text", "content": "Bien noté !", "created_at": "2026-06-22T11:39:30.524485", "media_url": null, "media_mime_type": null}, {"id": 46651, "message_id": "bot_AC783DC9A6E59310881B50B6424E4815_9548", "sender": "bot", "message_type": "text", "content": "Pour avancer, pouvez-vous me donner votre nom complet et le type de soin ou la raison de votre visite ?", "created_at": "2026-06-22T11:39:30.592544", "media_url": null, "media_mime_type": null}, {"id": 46652, "message_id": "bot_AC783DC9A6E59310881B50B6424E4815_9339", "sender": "bot", "message_type": "text", "content": "Je transmettrai votre demande à l’équipe qui vous répondra directement sur WhatsApp pour fixer la date la plus proche.", "created_at": "2026-06-22T11:39:30.636371", "media_url": null, "media_mime_type": null}, {"id": 46721, "message_id": "AC2D6B5B41115F7FB80A905A09484561", "sender": "user", "message_type": "text", "content": "Couronne dentaire", "created_at": "2026-06-22T13:12:47.653390", "media_url": null, "media_mime_type": null}, {"id": 46722, "message_id": "bot_AC2D6B5B41115F7FB80A905A09484561_423", "sender": "bot", "message_type": "text", "content": "Merci ! Pouvez-vous me donner votre nom complet pour que je puisse transmettre la demande à l’équipe ? Ils vous contacteront directement sur WhatsApp pour vous proposer la date la plus proche.", "created_at": "2026-06-22T13:13:00.141998", "media_url": null, "media_mime_type": null}, {"id": 46729, "message_id": "AC9ECB4F923BF733CD0A5FE8DA6C58DD", "sender": "user", "message_type": "text", "content": "Omar", "created_at": "2026-06-22T13:15:37.509189", "media_url": null, "media_mime_type": null}, {"id": 46730, "message_id": "bot_AC9ECB4F923BF733CD0A5FE8DA6C58DD_3163", "sender": "bot", "message_type": "text", "content": "Merci Omar !", "created_at": "2026-06-22T13:15:51.733960", "media_url": null, "media_mime_type": null}, {"id": 46731, "message_id": "bot_AC9ECB4F923BF733CD0A5FE8DA6C58DD_6463", "sender": "bot", "message_type": "text", "content": "Pour finaliser la demande, pouvez-vous préciser si vous avez une préférence pour le jour ou l’heure du rendez-vous, ou souhaitez-vous simplement la première disponibilité ?", "created_at": "2026-06-22T13:15:51.776663", "media_url": null, "media_mime_type": null}, {"id": 46732, "message_id": "bot_AC9ECB4F923BF733CD0A5FE8DA6C58DD_5293", "sender": "bot", "message_type": "text", "content": "Dès réception, je transmets tout à l’équipe qui vous contactera directement sur WhatsApp pour confirmation.", "created_at": "2026-06-22T13:15:51.814054", "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 3865 in training_review_items