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": 44929, "message_id": "A5C51C84584C841F777229989207999A", "sender": "bot", "message_type": "text", "content": "Hamdolilah", "created_at": "2026-06-17T16:39:30.648409", "media_url": null, "media_mime_type": null}, {"id": 44930, "message_id": "A54E6B79090DD96A08F28F1120E55076", "sender": "bot", "message_type": "voice", "content": "[Voice message] Certainly! Here is the transcription of the audio in Moroccan Darija (using Arabic script) with the French word included:\n\n**السلام عليكم براهيم، كيف نتينا مزيان آ خاي؟ براهيم حنايا جبرتينا سدينا اليوم، جيت للدار، حتى لغدا إن شاء الله ونعدل لك نصيفط لك الـ devis كامل، صافي؟ كون هاني. إلا ما صيفطته لكش عرفني غير مشغولة وصافي، أما راني غانصيفط لك كلشي، كون هاني.**\n\n### Transliteration (Latin Script):\n\"Assalamu alaikum Brahim, kif tina mzyan a khay? Brahim hnaia jabrtina sddina lyoma, jit lddar, htta l ghadda inshallah w n'addal lk nsayfat lk d-devis kamel, safi? Kon hanni. Ila ma sayfatolks ch'e'rafni ghir mshghula w safi, amma rani hansayfat lk kolchi, kon hanni.\"\n\n### Summary of Languages Used:\n*   **Moroccan Darija:** The majority of the speech (Northern/Chamali dialect noted by the use of \"tina\").\n*   **French:** The word **\"devis\"** (quote/estimate).\n*   **Arabic:** Standard religious/greeting phrases like **\"Assalamu alaikum\"** and **\"Inshallah\"**.", "created_at": "2026-06-17T16:39:48.196195", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12395/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45517, "message_id": "3A690F154AFE4B422B0C", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio, which features a mix of Algerian/Moroccan Darija and French:\n\n**Arabic Script:**\nالسلام عليكم، شراك؟ لاباس؟\nEnvoie-moi le devis الله يحفظك، le devis à jour s’il te plaît.\nغدا à 10h نجي.\n\n**Latin Script:**\n\"Salam aleykoum, chrak? Labass? \nEnvoie-moi le devis Allah yahafdak, le devis à jour s’il te plaît. \nGhedda à 10h nji.\"\n\n**English Translation (for context):**\n\"Peace be upon you, how are you? Are you well?\nSend me the quote, may God protect you, the updated quote please.\nTomorrow at 10:00 AM I’ll come.\"", "created_at": "2026-06-19T12:25:07.225097", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12632/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45518, "message_id": "bot_3A690F154AFE4B422B0C_8739", "sender": "bot", "message_type": "text", "content": "Merci pour votre message !", "created_at": "2026-06-19T12:25:43.983012", "media_url": null, "media_mime_type": null}, {"id": 45519, "message_id": "bot_3A690F154AFE4B422B0C_996", "sender": "bot", "message_type": "text", "content": "Pour bien préparer votre passage demain à 10h, pouvez-vous me confirmer votre nom complet et le type de soin ou traitement pour lequel vous souhaitez recevoir le devis à jour ?", "created_at": "2026-06-19T12:25:44.022872", "media_url": null, "media_mime_type": null}, {"id": 45520, "message_id": "bot_3A690F154AFE4B422B0C_3377", "sender": "bot", "message_type": "text", "content": "Dès que j’ai ces informations, je transmets la demande à l’équipe.", "created_at": "2026-06-19T12:25:44.056735", "media_url": null, "media_mime_type": null}, {"id": 45521, "message_id": "bot_3A690F154AFE4B422B0C_3142", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-19T12:25:44.100373", "media_url": null, "media_mime_type": null}, {"id": 45523, "message_id": "3A3FEE387938FB2BBE11", "sender": "user", "message_type": "text", "content": "Nekka Ibrahim \nContrôle implant dentaire", "created_at": "2026-06-19T12:26:18.627676", "media_url": null, "media_mime_type": null}, {"id": 45527, "message_id": "bot_3A3FEE387938FB2BBE11_4998", "sender": "bot", "message_type": "text", "content": "Merci Ibrahim !", "created_at": "2026-06-19T12:26:31.200247", "media_url": null, "media_mime_type": null}, {"id": 45528, "message_id": "bot_3A3FEE387938FB2BBE11_1834", "sender": "bot", "message_type": "text", "content": "Votre demande pour un contrôle d’implant dentaire et le devis à jour est bien transmise pour demain à 10h.", "created_at": "2026-06-19T12:26:31.246474", "media_url": null, "media_mime_type": null}, {"id": 45529, "message_id": "bot_3A3FEE387938FB2BBE11_8090", "sender": "bot", "message_type": "text", "content": "L’équipe va vous recontacter rapidement pour confirmer le rendez-vous.", "created_at": "2026-06-19T12:26:31.292662", "media_url": null, "media_mime_type": null}, {"id": 45530, "message_id": "bot_3A3FEE387938FB2BBE11_3142", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-19T12:26:31.341283", "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 3748 in training_review_items