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": 34588, "message_id": "3A384F793673EE599D06", "sender": "user", "message_type": "text", "content": "Bonjour , je vais tarder 15 min je suis bloquée dans l’embouteillage", "created_at": "2026-05-23T11:17:14.050089", "media_url": null, "media_mime_type": null}, {"id": 34612, "message_id": "3EB05BEB988F3B89FFFD97", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *500,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-11500,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-05-23T11:49:24.439643", "media_url": null, "media_mime_type": null}, {"id": 34613, "message_id": "3EB088654CC2C1844862C5", "sender": "bot", "message_type": "document", "content": "2026052312490678.pdf", "created_at": "2026-05-23T11:49:54.405860", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9848/download", "media_mime_type": "application/pdf"}, {"id": 37962, "message_id": "3A660CEAE01FEA9440C3", "sender": "user", "message_type": "text", "content": "Coucou 👋🏻 \nSvp prochain rdv ?", "created_at": "2026-06-02T11:22:35.268698", "media_url": null, "media_mime_type": null}, {"id": 37963, "message_id": "bot_3A660CEAE01FEA9440C3_3626", "sender": "bot", "message_type": "text", "content": "Merci Oumaima pour votre relance !", "created_at": "2026-06-02T11:22:49.088091", "media_url": null, "media_mime_type": null}, {"id": 37964, "message_id": "bot_3A660CEAE01FEA9440C3_1488", "sender": "bot", "message_type": "text", "content": "L’équipe va vous contacter très prochainement pour vous proposer une nouvelle date de rendez-vous.", "created_at": "2026-06-02T11:22:49.151155", "media_url": null, "media_mime_type": null}, {"id": 37965, "message_id": "bot_3A660CEAE01FEA9440C3_762", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-02T11:22:49.204989", "media_url": null, "media_mime_type": null}, {"id": 40836, "message_id": "3A257443E081BE2AFC12", "sender": "user", "message_type": "text", "content": "Coucou 👋🏻 \nSvp prochain rdv ?", "created_at": "2026-06-09T14:04:58.276175", "media_url": null, "media_mime_type": null}, {"id": 40837, "message_id": "3AA7332298B0E63C601F", "sender": "user", "message_type": "text", "content": "???", "created_at": "2026-06-09T14:05:05.135757", "media_url": null, "media_mime_type": null}, {"id": 40838, "message_id": "bot_3AA7332298B0E63C601F_7008", "sender": "bot", "message_type": "text", "content": "Merci pour votre patience Oumaima !", "created_at": "2026-06-09T14:05:17.826486", "media_url": null, "media_mime_type": null}, {"id": 40839, "message_id": "bot_3AA7332298B0E63C601F_1289", "sender": "bot", "message_type": "text", "content": "Votre demande est bien transmise, l’équipe va vous rappeler pour fixer le prochain rendez-vous إن شاء الله.", "created_at": "2026-06-09T14:05:17.889598", "media_url": null, "media_mime_type": null}, {"id": 40840, "message_id": "bot_3AA7332298B0E63C601F_6428", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-09T14:05:17.956641", "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 3322 in training_review_items