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": 35331, "message_id": "A5124F9F7C0DB9D4F32F5C632EBB359A", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nفاطمة الزهراء، كيدرتي مزيان؟ بخير؟ ضحكتيني ملي قلتي لي أويلي على مورا العيد. واخا صافي، أنا غادي نقولها له، ونرجع نرد عليك، صافي؟ باي.\n\n**Latin Script (Phonetic):**\nFatima Zahra, ki derti meziane? Bekhir? Da7ktini melli goulti li awili 3la mour el eid. Wakha safi, ana ghadi ngoulha lo, o nerja3 nradd 3lik, safi? Bye.", "created_at": "2026-05-25T14:02:09.825570", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9963/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 35335, "message_id": "2A866DA158AAA4C40508", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-05-25T14:05:01.798428", "media_url": null, "media_mime_type": null}, {"id": 37480, "message_id": "2A55A4351A16E368965A", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-06-01T11:53:08.983585", "media_url": null, "media_mime_type": null}, {"id": 37483, "message_id": "bot_2A55A4351A16E368965A_2884", "sender": "bot", "message_type": "text", "content": "Bonjour Fatima 😊 Merci pour votre retour. Si vous avez besoin de quoi que ce soit ou souhaitez fixer un nouveau rendez-vous, n’hésitez pas à me le dire !", "created_at": "2026-06-01T11:54:16.443789", "media_url": null, "media_mime_type": null}, {"id": 37484, "message_id": "2AA530A087226617C0B2", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio, which is a mix of French and Moroccan Darija:\n\n\"Bon bonjour. Comme j’t’ai dit, je voudrais prendre un rendez-vous avant l’Aïd, walakin ma radditich ‘aliya. O hna après l’Aïd, chouf liya un rendez-vous s’il te plaît.\"", "created_at": "2026-06-01T11:54:49.463153", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10484/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37485, "message_id": "bot_2AA530A087226617C0B2_3656", "sender": "bot", "message_type": "text", "content": "Merci Fatima pour la précision ! 😊 Pour organiser un rendez-vous après l’Aïd, pouvez-vous me dire le type de soin que vous souhaitez et vos disponibilités (jour/heure) ?", "created_at": "2026-06-01T11:55:18.509656", "media_url": null, "media_mime_type": null}, {"id": 37487, "message_id": "2AAB68C0A0CC0AF94965", "sender": "user", "message_type": "text", "content": "Je veux continuer mes soins", "created_at": "2026-06-01T11:56:13.209150", "media_url": null, "media_mime_type": null}, {"id": 37488, "message_id": "bot_2AAB68C0A0CC0AF94965_4974", "sender": "bot", "message_type": "text", "content": "Merci Fatima ! Pour bien organiser votre passage, pouvez-vous me préciser quel(s) jour(s) et créneau(s) horaire(s) après l’Aïd vous arrangeraient le plus ?", "created_at": "2026-06-01T11:56:25.217026", "media_url": null, "media_mime_type": null}, {"id": 37492, "message_id": "2AB02C872F36E613719C", "sender": "user", "message_type": "text", "content": "Je préfère demain", "created_at": "2026-06-01T11:59:08.540478", "media_url": null, "media_mime_type": null}, {"id": 37496, "message_id": "bot_2AB02C872F36E613719C_1998", "sender": "bot", "message_type": "text", "content": "Votre demande est bien transmise Fatima !", "created_at": "2026-06-01T11:59:24.971267", "media_url": null, "media_mime_type": null}, {"id": 37497, "message_id": "bot_2AB02C872F36E613719C_7237", "sender": "bot", "message_type": "text", "content": "L’équipe va revenir vers vous pour confirmer le rendez-vous de demain.", "created_at": "2026-06-01T11:59:25.030318", "media_url": null, "media_mime_type": null}, {"id": 37498, "message_id": "bot_2AB02C872F36E613719C_1336", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-01T11:59:25.081934", "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 2983 in training_review_items