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": 47073, "message_id": "3A45DBE87AE4DEE2367F", "sender": "user", "message_type": "text", "content": "Khadija boufounas", "created_at": "2026-06-22T19:18:59.370761", "media_url": null, "media_mime_type": null}, {"id": 47074, "message_id": "bot_3A45DBE87AE4DEE2367F_1000", "sender": "bot", "message_type": "text", "content": "مرحبا Khadija 😊 كيف يمكن نعاونكوم اليوم؟ واش محتاجين شي موعد، استشارة، ولا عندكوم سؤال على شي خدمة معينة؟", "created_at": "2026-06-22T19:19:14.040900", "media_url": null, "media_mime_type": null}, {"id": 47075, "message_id": "3A38A33D35D42C4E383E", "sender": "user", "message_type": "text", "content": "Vous pouvez m’envoyer localisation", "created_at": "2026-06-22T19:20:28.409239", "media_url": null, "media_mime_type": null}, {"id": 47076, "message_id": "bot_3A38A33D35D42C4E383E_3867", "sender": "bot", "message_type": "text", "content": "Bien sûr !", "created_at": "2026-06-22T19:20:40.611697", "media_url": null, "media_mime_type": null}, {"id": 47077, "message_id": "bot_3A38A33D35D42C4E383E_1160", "sender": "bot", "message_type": "text", "content": "Voici l’adresse du Centre Dentaire Tanger Bay : \nAvenue Mohammed VI, Résidence Borj Khalij Tanger 3, étage 5, appartement numéro 197, Tanger \nhttps://maps.app.goo.gl/RCzcJXSXvgMzrRMFA\n\nN’hésitez pas si vous avez besoin d’autres informations !", "created_at": "2026-06-22T19:20:40.645939", "media_url": null, "media_mime_type": null}, {"id": 47078, "message_id": "3A16C901DA2C52452577", "sender": "user", "message_type": "text", "content": "Hado li permanence db ?", "created_at": "2026-06-22T19:22:35.707017", "media_url": null, "media_mime_type": null}, {"id": 47079, "message_id": "bot_3A16C901DA2C52452577_6143", "sender": "bot", "message_type": "text", "content": "Oui, nous sommes ouverts en ce moment ! Nos horaires aujourd’hui (lundi) sont de 09:00 à 19:00. Vous souhaitez passer directement ou prendre rendez-vous ?", "created_at": "2026-06-22T19:22:48.355457", "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 3898 in training_review_items