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": 11897, "message_id": "3EB0C885FF24C252FEAD7A", "sender": "bot", "message_type": "document", "content": "ordonnance_n4645_4752148.pdf", "created_at": "2026-04-04T11:58:22.719182", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2960/download", "media_mime_type": "application/pdf"}, {"id": 12735, "message_id": "A529E0F675511A8A594D2D678C65E5D7", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure, here is the transcription of the audio:\n\n\"السلام سمر، صافا؟ لاباس عليك؟ مزيانة؟ صافا؟ بغيت نقول ليك راه عندك رونديفو غدا. إيوا إلا ما كنتيش غادي تجي زعما علمني وصافي، حيتاش كاين الناس كيسولوا.\"\n\n**Transcription in Latin script (Darija/French):**\n\n\"Salam Samar, ça va? Labaas alik? Mezyana? ça va? Bghit ngoul lik rah andek rendez-vous ghedda. Ewa ila makuntish ghadi tji zaama allemny o safi, hitash kayn nass kaysuwlu.\"", "created_at": "2026-04-08T17:05:04.822347", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3268/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 12736, "message_id": "3A2A4466236F8F718E46", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image shows a screenshot from a mobile banking or payment application. At the top, the time '18:08' and '5G' signal status are visible. The main part of the image displays a transaction with 'Grande Pharmacie Malabat' for the amount of -£57.02. The transaction is marked as occurring today at 16:38. There is a blue circle with a white heart icon. Below, there is a button for 'Split bill.' The status of the transaction is 'Pending' with a note that it will be automatically reverted on 17 April if unclaimed by the merchant. The card used is identified as 'Sam ..9076', and payment is from 'Personal · GBP'. There is a 'Download' link for the statement at the bottom. The interface uses a dark color scheme and the app likely has financial or transaction management functionalities.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",\n    \"per\n\nUser message context: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a mobile screenshot showing a payment transaction summary. The transaction is titled 'Grande Pharmacie Malabat' with a payment amount of -£57.02. The transaction time is today at 16:38. There is a heart icon at the top center, and a 'Split bill' button under the payment information. The status below indicates that the transaction is pending and will automatically revert on 17 April if unclaimed by merchant. There is a card identifier (Sam ••9076), and the payment is from 'Personal • GBP'. At the bottom there is a 'Statement' heading with a download link. The screenshot also shows device information at the top (time 18:08, 5G, battery 38%). The app interface uses a dark color scheme.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",\n    \"periapical_areas\": \"\",\n    \"other_findings\": \"\"\n  },\n  \"text_visible", "created_at": "2026-04-08T17:08:14.129510", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3269/download", "media_mime_type": "image/jpeg"}, {"id": 12737, "message_id": "3AF0E20FF48DDA099816", "sender": "user", "message_type": "text", "content": "<reply_to> </reply_to> Gna y’a", "created_at": "2026-04-08T17:08:20.254351", "media_url": null, "media_mime_type": null}, {"id": 12738, "message_id": "3A46DA4E48B4CFAF50C3", "sender": "user", "message_type": "text", "content": "Hnaya", "created_at": "2026-04-08T17:08:23.079251", "media_url": null, "media_mime_type": null}, {"id": 12743, "message_id": "bot_3A46DA4E48B4CFAF50C3_2238", "sender": "bot", "message_type": "text", "content": "Merci Samar, toutes vos pièces (ordonnance, vidéos, preuve de paiement) ont bien été reçues. J'ai transmis l'ensemble au cabinet pour suivi — un membre de l'équipe va vous recontacter très bientôt إن شاء الله 🙏🏻", "created_at": "2026-04-08T17:08:53.003832", "media_url": null, "media_mime_type": null}, {"id": 13131, "message_id": "3EB0600BE014E46D4109DB", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL FARZAZI BENTATOU Samar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 avril 2026* à *15:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-09T14:05:13.290883", "media_url": null, "media_mime_type": null}, {"id": 14034, "message_id": "3EB0B1C8D967FF23432A3A", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL FARZAZI BENTATOU Samar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 13 avril 2026* à *15:30* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الأثنين 13 أبريل 2026* على الساعة *15:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-11T12:34:33.105750", "media_url": null, "media_mime_type": null}, {"id": 14782, "message_id": "A54F5475C974B46FA98914D0885437AA", "sender": "bot", "message_type": "text", "content": "Salam", "created_at": "2026-04-13T11:34:27.301705", "media_url": null, "media_mime_type": null}, {"id": 14784, "message_id": "A59CBEC3088A390E9EBC92A904562246", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Latin Script:**\n\"Salam Safae, labas? mzyana? kolchi bikhir? Safae 3ndek rendez-vous m3a tlatat w ness, ghir kankked 3lik wach tconfirmi wlla la?\"\n\n**Arabic Script:**\n\"سلام صفاء، لاباس؟ مزيانة؟ كولشي بخير؟ صفاء عندك راندي فو مع التلاتة ونص، غير كأكد عليك واش تكونفيرمي ولا لا؟\"\n\n**English Translation (for context):**\n\"Hello Safae, how are you? Good? Is everything okay? Safae, you have an appointment at 3:30, I'm just checking with you to see if you confirm or not?\"", "created_at": "2026-04-13T11:35:17.045574", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3791/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 14846, "message_id": "3AC8D4C4486130FA73CF", "sender": "user", "message_type": "text", "content": "Est-ce qu'on peut décaler à demain s'il te plaît ? Mon argent n'est pas encore arrivé.", "created_at": "2026-04-13T13:03:32.982089", "media_url": null, "media_mime_type": null}, {"id": 14847, "message_id": "bot_3AC8D4C4486130FA73CF_3640", "sender": "bot", "message_type": "text", "content": "Merci pour votre message Samar. Je transmets tout de suite votre demande de décaler le rendez-vous à demain à l’équipe. Ils vont vous recontacter très bientôt pour vous proposer une nouvelle date إن شاء الله 🙏🏻", "created_at": "2026-04-13T13:03:53.495358", "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 1060 in training_review_items