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": 40629, "message_id": "A566FFF4709593A2404AAAEAC1E55F03", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**ألو، كولشي مزيان؟ لا، غدا ما غاتجيش، الـ rendez-vous حتى الخميس.**\n\n**Transcription (Latin script):**\n*Alo, kolshi mezian? La, ghedda ma ghatjish, le rendez-vous hta l-khmis.*", "created_at": "2026-06-08T23:19:01.296106", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11284/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40651, "message_id": "3EB09366E6730FEB320AB1", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ISMAEL Fatima*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 10 juin 2026* à *11: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لديكم موعد مع ** يوم *الأربعاء 10 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-09T08:42:11.153502", "media_url": null, "media_mime_type": null}, {"id": 40919, "message_id": "3EB0B28B0AB149AEC15E00", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ISMAEL Fatima*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 10 juin 2026* à *11: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لديكم موعد مع ** يوم *الأربعاء 10 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-09T15:27:11.469343", "media_url": null, "media_mime_type": null}, {"id": 41344, "message_id": "3EB05434E3BB955C9B4095", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ISMAEL Fatima*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 11 juin 2026* à *10: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لديكم موعد مع ** يوم *الخميس 11 يونيو 2026* على الساعة *10:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-10T12:41:06.371271", "media_url": null, "media_mime_type": null}, {"id": 41448, "message_id": "3EB0AE8163F94A4E8822F7", "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 promotional graphic for a dental clinic. There is a large, cartoon-style anthropomorphic tooth in the foreground, smiling and holding a calendar with a green checkmark, giving a 'thumbs up' gesture. In the background, an out-of-focus dental clinic setting is visible, including a dental chair and other typical clinic furnishings. At the top, there is a logo with a stylized tooth and the words 'TANGER BAY DENTAL CENTER.' Two large banners contain French text: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER.' The overall color scheme is clean and professional, with blue and white as dominant colors.\",\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\": [\n    \"TANGER BAY DENTAL CENTER\",\n\nUser message context: Salut *ISMAEL Fatima*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 11 juin 2026*\r\n🕘 Heure : *10:30*\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-10T15:04:36.483050", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11497/download", "media_mime_type": "image/jpeg"}, {"id": 41988, "message_id": "3EB03469AF37252573636F", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1500,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-11T11:30:10.644084", "media_url": null, "media_mime_type": null}, {"id": 41989, "message_id": "3EB0F0CD73FEEE86195171", "sender": "bot", "message_type": "document", "content": "2026061112292219.pdf", "created_at": "2026-06-11T11:30:33.028743", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11622/download", "media_mime_type": "application/pdf"}, {"id": 41991, "message_id": "3EB032C6EED9ED16D0C33E", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ISMAEL Fatima*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-11T11:31:10.621045", "media_url": null, "media_mime_type": null}, {"id": 42952, "message_id": "3AFAA4012E998973D6BC", "sender": "user", "message_type": "text", "content": "Salam, I need to rebook my appointment to the 17th. Would you do that for me?😃", "created_at": "2026-06-13T18:26:19.944820", "media_url": null, "media_mime_type": null}, {"id": 42955, "message_id": "bot_3AFAA4012E998973D6BC_3741", "sender": "bot", "message_type": "text", "content": "Bonjour Fatima 😊 Pas de souci, j'ai transmis votre demande de déplacement au 17 juin à l'équipe.", "created_at": "2026-06-13T18:27:22.250772", "media_url": null, "media_mime_type": null}, {"id": 42956, "message_id": "bot_3AFAA4012E998973D6BC_7383", "sender": "bot", "message_type": "text", "content": "Ils vont vérifier la disponibilité et vous recontacter rapidement.", "created_at": "2026-06-13T18:27:22.316605", "media_url": null, "media_mime_type": null}, {"id": 42957, "message_id": "bot_3AFAA4012E998973D6BC_9163", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-13T18:27:22.386945", "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 3521 in training_review_items