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": 35314, "message_id": "3A7B4593484573F051AB", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-05-25T13:19:02.297823", "media_url": null, "media_mime_type": null}, {"id": 35315, "message_id": "bot_3A7B4593484573F051AB_2528", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-05-25T13:19:14.331047", "media_url": null, "media_mime_type": null}, {"id": 45385, "message_id": "3EB0FB8EEB579DB2CA758B", "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 shows a digital advertisement for Tanger Bay Dental Center. In the foreground, there is a large, anthropomorphic cartoon tooth character with a smiling face and eyebrows, holding a notepad featuring a green checkmark. The tooth character is giving a thumbs up gesture. In the background, a blurred-out dental clinic scene is visible with a dental chair and dental equipment, light blue and white colors dominate the scene. At the top, the logo of Tanger Bay Dental Center is present, featuring a stylized tooth outline and the text 'TANGER BAY DENTAL CENTER'. Below it are two bold blue banners with white text: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER'. The overall style is clean, professional, and friendly.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"\n\nUser message context: Salut *BENZIZOU SAFAE*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 19 juin 2026*\r\n🕘 Heure : *17: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-06-18T15:05:27.543830", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12564/download", "media_mime_type": "image/jpeg"}, {"id": 45392, "message_id": "3EB0AC195E1CFD00672A79", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BENZIZOU SAFAE*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 19 juin 2026* à *16: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لديكم موعد مع ** يوم *الجمعة 19 يونيو 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-18T15:17:58.365328", "media_url": null, "media_mime_type": null}, {"id": 45454, "message_id": "3A3FE64F468B54FD94B7", "sender": "user", "message_type": "text", "content": "Ok inchalah merci", "created_at": "2026-06-18T17:47:46.787847", "media_url": null, "media_mime_type": null}, {"id": 45629, "message_id": "A5C004A4558B6E8611E2A14CE6771A5C", "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 (Transliteration):**\n\"Salam alaykum Safaa, kif nti? Mezyana? Bikher? Safi 3andek rendez-vous m3a l'rab3a, khayla ma t'attalch, safi?\"\n\n**Translation (for context):**\n\"Peace be upon you Safaa, how are you? Good? Well? Okay, you have an appointment at four, please don't be late, okay?\"", "created_at": "2026-06-19T14:30:02.084861", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12649/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45630, "message_id": "3A5079F193F8354E942C", "sender": "user", "message_type": "text", "content": "D accord merci", "created_at": "2026-06-19T14:31:36.157585", "media_url": null, "media_mime_type": null}, {"id": 45739, "message_id": "3EB0C63C6149C12A99F959", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-2800,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-19T16:11:54.888911", "media_url": null, "media_mime_type": null}, {"id": 45740, "message_id": "3EB07BB2D0861EEED00EE1", "sender": "bot", "message_type": "document", "content": "2026061917105367.pdf", "created_at": "2026-06-19T16:12:20.255014", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12687/download", "media_mime_type": "application/pdf"}, {"id": 45742, "message_id": "3EB0768DA96273768D6169", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BENZIZOU SAFAE*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mercredi 24 juin 2026* à *17: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لديكم موعد مع ** يوم *الأربعاء 24 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-19T16:14:08.680471", "media_url": null, "media_mime_type": null}, {"id": 47644, "message_id": "3A36373A7D654394CABA", "sender": "user", "message_type": "text", "content": "<reply_to>Bonjour \r\n*BENZIZOU SAFAE*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *mercredi 24 juin 2026* à *17:00* .\r\nEn cas d'empêchement, veuillez...</reply_to> Bonjour , je suis désolée, mais je dois annuler mon rendez-vous d’aujourd’hui pour des raisons indépendantes de ma volonté. Merci de votre compréhension. 😊", "created_at": "2026-06-24T07:56:51.236173", "media_url": null, "media_mime_type": null}, {"id": 47648, "message_id": "bot_3A36373A7D654394CABA_7330", "sender": "bot", "message_type": "text", "content": "Bonjour Safae 😊 Aucun souci, l'annulation de votre rendez-vous est bien transmise à l'équipe. N'hésitez pas à nous recontacter quand vous souhaiterez reprendre rendez-vous إن شاء الله 🙏🏻", "created_at": "2026-06-24T07:57:20.649595", "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 3952 in training_review_items