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": 49900, "message_id": "A52C9B7CC3E6BB1CC01B74FBEF21CE5A", "sender": "user", "message_type": "text", "content": "Bonjour khti ca va svp bghite nakhode rendez vous pour les bagues ndirhom inchaalh pour la semaine prochaine vendredi le 10/07 a 13h00  c possible ?", "created_at": "2026-07-01T11:00:26.705979", "media_url": null, "media_mime_type": null}, {"id": 49902, "message_id": "bot_A52C9B7CC3E6BB1CC01B74FBEF21CE5A_9353", "sender": "bot", "message_type": "text", "content": "Merci pour votre message 😊 Pouvez-vous me donner votre nom complet pour que je transmette la demande à l'équipe ?", "created_at": "2026-07-01T11:00:42.703591", "media_url": null, "media_mime_type": null}, {"id": 49903, "message_id": "bot_A52C9B7CC3E6BB1CC01B74FBEF21CE5A_4009", "sender": "bot", "message_type": "text", "content": "Dès que j'ai votre nom, je leur envoie la demande pour vendredi 10 juillet à 13h إن شاء الله.", "created_at": "2026-07-01T11:00:42.740029", "media_url": null, "media_mime_type": null}, {"id": 49904, "message_id": "A55E3FC9C430EC399796EAB46D7C293F", "sender": "user", "message_type": "text", "content": "Moussaoui maryam", "created_at": "2026-07-01T11:01:46.919078", "media_url": null, "media_mime_type": null}, {"id": 49905, "message_id": "bot_A55E3FC9C430EC399796EAB46D7C293F_3673", "sender": "bot", "message_type": "text", "content": "Merci beaucoup Moussaoui maryam 😊 Votre demande est enregistrée, notre équipe va vous contacter pour confirmer le rendez-vous إن شاء الله 🙏🏻", "created_at": "2026-07-01T11:02:01.334258", "media_url": null, "media_mime_type": null}, {"id": 49906, "message_id": "A560E6C994995FD2AA4C7E7CD238C767", "sender": "user", "message_type": "text", "content": "Merci bq", "created_at": "2026-07-01T11:02:10.208456", "media_url": null, "media_mime_type": null}, {"id": 49907, "message_id": "bot_A560E6C994995FD2AA4C7E7CD238C767_9031", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيك 😊 واش كاين شي حاجة أخرى نقدر نعاونكوم بها؟", "created_at": "2026-07-01T11:02:21.583742", "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 4139 in training_review_items