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": 7169, "message_id": "A57C4B5C1EB8FB07EDAE28F4C2D3921E", "sender": "bot", "message_type": "text", "content": "<reply_to>12 mezinna v</reply_to> Ok", "created_at": "2026-03-26T17:59:37.443535", "media_url": null, "media_mime_type": null}, {"id": 7170, "message_id": "3A981545161BCA4B0A3E", "sender": "user", "message_type": "text", "content": "Merci bcp 🙏", "created_at": "2026-03-26T17:59:44.781678", "media_url": null, "media_mime_type": null}, {"id": 7171, "message_id": "3EB023F450910258112B12", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*SORF Oumaima *\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *samedi 28 mars 2026* à *12: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لديكم موعد مع ** يوم *السبت 28 مارس 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-26T18:00:06.033879", "media_url": null, "media_mime_type": null}, {"id": 7176, "message_id": "3A4BE6D47D2A32D8AA5D", "sender": "user", "message_type": "text", "content": "J’ai payé f le 7/03 donc cette fois ci pas la peine yk . \nEnsuite je paye  mara f dik 2 seances dial avril n’est ce pas", "created_at": "2026-03-26T18:07:34.591792", "media_url": null, "media_mime_type": null}, {"id": 7188, "message_id": "A5B7744401597867083E42068085CE10", "sender": "bot", "message_type": "voice", "content": "[Voice message] شوف بالنسبة للـ paiement، دبا الطبيب غادي غير يشوفك وصافي، غادي يشوف ديك الحالة ديالك باش يعرف زعما traitement اللي غادي.. زعما اللي غادي يكمل معاك، واش غاتبقا تجي مرة وحدة فالشهر ولا جوج مرات فالشهر؟ إلا كنتي غادي تجي مرة وحدة فالشهر غاتبقا تخلص مرة وحدة فالشهر، إلا كنتي غادي جوج مرات فالشهر غاتبقا تخلص جوج مرات فالشهر، صافي؟", "created_at": "2026-03-26T18:21:10.795989", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1461/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7191, "message_id": "3A8C118E00C4FE996A36", "sender": "user", "message_type": "text", "content": "Ah d’accord donc hoa db ghadi ghi y analyser l khedma dial lowla", "created_at": "2026-03-26T18:21:42.376061", "media_url": null, "media_mime_type": null}, {"id": 7192, "message_id": "3AD4CAA268F8E0874C31", "sender": "user", "message_type": "text", "content": "Safi wakha nchofo Ach ghy9ol", "created_at": "2026-03-26T18:21:56.056945", "media_url": null, "media_mime_type": null}, {"id": 7193, "message_id": "A5CEB81FB200E6C4ECC809E2A58B5885", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script):\n\n**\"ييه، غدا إن شاء الله يعني غاي- غادي يأناليزي الحالة ديالك، يشوف تريطمون (traitement) ديالك كيفاش عامل وداكشي وكيفاش كان، وإن شاء الله باش يبدا معاك.\"**\n\n---\n**Latin script (Transcription):**\n\"Yeh, ghedda incha’Allah, yaani ghay- ghadi yanalyzer l-hala dyalk, y-chouf traitement dyalk kifach ‘amel w dakchi w kifach kan, w incha’Allah bach yebda m’aak.\"", "created_at": "2026-03-26T18:23:49.441819", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1462/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7194, "message_id": "3AC8C7FB111EF07106BD", "sender": "user", "message_type": "text", "content": "Safi ca marche merci bcp", "created_at": "2026-03-26T18:24:02.801863", "media_url": null, "media_mime_type": null}, {"id": 7524, "message_id": "3EB0E8C881A8F0E4D91452", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image features a cartoon character resembling a smiling tooth holding a notepad with a large checkmark. In the background, there is an out-of-focus dental office setting with a dental chair. The top part of the image has text: 'TANGER BAY DENTAL CENTER' along with a tooth-shaped logo. Below that, banners in blue say 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER', both including checkmark symbols.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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\": [\n    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\":\n\nUser message context: Salut *SORF Oumaima *👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *12:00*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.", "created_at": "2026-03-27T15:04:26.054720", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1574/download", "media_mime_type": "image/jpeg"}, {"id": 7610, "message_id": "3A03BC31AD6B2AD374B8", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-03-27T15:53:30.497825", "media_url": null, "media_mime_type": null}, {"id": 7611, "message_id": "bot_3A03BC31AD6B2AD374B8_1355", "sender": "bot", "message_type": "text", "content": "Parfait 😊 Votre rendez-vous est confirmé le samedi 28 mars 2026 à 12:00 chez Tanger Bay Dental Center. À bientôt إن شاء الله 🙏🏻", "created_at": "2026-03-27T15:54:22.726180", "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 287 in training_review_items