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": 10832, "message_id": "AC13DC1E6701305B4C44D37634BFBC02", "sender": "user", "message_type": "text", "content": "Bonjour Dr", "created_at": "2026-04-02T14:27:11.810260", "media_url": null, "media_mime_type": null}, {"id": 10833, "message_id": "ACA687DC71D33691FA377512E5ACD4DE", "sender": "user", "message_type": "image", "content": "Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a promotional image for a dental webinar event. The image contains a professional man in a suit (presumably Dr Emiliano Ferrari), dental prosthetic components including a metal tool/screw and a full-arch dental prosthesis (likely an implant-supported bridge or denture). Text appears in French and includes date, time, topic, and presenter's name. The background is mostly black with some yellow and blue graphic elements, and there is a prominent Rhein83 logo at the bottom. The phrase 'LIVE WEBINAR' with a microphone symbol, and 'EASY Fix' are visible.\",\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    \"MARDI 14 AVRIL 2026\",\n    \"14H00 (HEURE DE ROME)\",\n    \"LIVE WEBINAR\",\n    \"PROTO\n\nUser message context: Rome)\n\nLE WEBINAIRE\nLa réhabilitation implanto-prothétique doit restaurer à la fois la fonction et l’esthétique. Cependant, l’obtention de résultats prévisibles dépend d’une planification prothétique rigoureuse et du choix d’un système de connexion adapté.\n\nAujourd’hui, les cliniciens ont besoin de solutions offrant flexibilité, précision et efficacité, quel que soit le scénario implantaire.\n\nAvec le système Easy Fix de Rhein83, il est désormais possible de réaliser des prothèses fixes complètes sans accès aux vis, améliorant l’esthétique tout en offrant une plus grande liberté dans la conception prothétique.\n\nLors de ce webinaire en direct, Dr. Emiliano Ferrari présentera le protocole Easy Fix, en partageant des insights cliniques et des applications pratiques pour des restaurations implantaires full-arch prévisibles.\n\n📅 14 avril 2026\n🕒 14h00 (heure de Rome)\n⏱ Durée : 60 minutes + session de questions-réponses en direct\n🎙 Intervenant : Dr. Emiliano Ferrari\nInscription :\nhttps://us02web.zoom.us/webinar/register/WN_pQYuAHSeR2uFUySzpLKt6g", "created_at": "2026-04-02T14:27:12.005325", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2599/download", "media_mime_type": "image/jpeg"}, {"id": 10835, "message_id": "bot_ACA687DC71D33691FA377512E5ACD4DE_760", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Merci d’avoir partagé l’information sur ce webinaire du Dr Emiliano Ferrari concernant le protocole Easy Fix de Rhein83 pour la prothèse implantaire fixe sans vis.\n\nSi vous souhaitez en discuter avec Dr Haitham Boutaib ou avez des questions sur les solutions implantaires proposées au Centre Dentaire Tanger Bay, n’hésitez pas à me le dire ! Je peux transmettre votre demande à l’équipe ou vous aider à prendre rendez-vous si besoin.\n\nSouhaitez-vous que je fasse suivre cette information au Dr Haitham ou avez-vous une question particulière à ce sujet ?", "created_at": "2026-04-02T14:27:33.083108", "media_url": null, "media_mime_type": null}, {"id": 13278, "message_id": "ACB39CF2760227C46DD8DB830C99E2B3", "sender": "user", "message_type": "text", "content": "Bonsoir Dr.", "created_at": "2026-04-09T17:14:17.972998", "media_url": null, "media_mime_type": null}, {"id": 13279, "message_id": "ACF96251FFA315D6F5BD3009DEA8E13E", "sender": "user", "message_type": "image", "content": "Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a promotional banner for a dental training event titled 'Formation Chirurgie Guidée' (Guided Surgery Training). The design features blue and yellow color themes, and logos of MIS Guide, JAT Medical, and Dentsply Sirona at the top. There is a partial transparent image of a surgical guide template on the right. Event dates are listed as 'Module 1 : 11,12 Avril 2026' and 'Module 2 : 09,10 Mai 2026'. The city 'Casablanca' and the name 'Lumina Dental Institute' are highlighted. Three speakers are shown in individual portrait photos, labeled as 'Faïçal Benjelloun', 'Patrice Capitaine', and 'Taher Adlouni'. Contact phone numbers for different regions (Casablanca et Région, Agadir et Sud, Tanger & Nord) are provided at the bottom, along with the website: www.jatmedical.ma. The background includes faint imagery of dental instruments or surgery, consistent with the dental event theme.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root\n\nUser message context: https://jatmedical.ma/formation-chirurgie-guidee/", "created_at": "2026-04-09T17:14:18.590992", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3406/download", "media_mime_type": "image/jpeg"}, {"id": 13280, "message_id": "ACDD04A6C061E6ED471C14CDE905A7C1", "sender": "user", "message_type": "image", "content": "Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a digital flyer or poster advertising a dental education event about implant prostheses. The top portion contains six clinical photos showing various stages and types of dental prosthetics on implants, including teeth with abutments, implant bars, and crowns. The main text area uses blue and black colors, prominently displaying 'FORMATION PROTHÈSE SUR IMPLANTS' (Implant Prosthesis Training). The event is set for April 18-19, 2026, in Casablanca, organized by Lumina Dental Institute, with Dr. Taher Adlouni as the main speaker (his portrait appears on the right side). Target audience is dentists. There is an orange and gold-toned logo for Lumina Dental Institute. The objectives section lists educational goals in French. At the bottom, there is a blue bar with program and registration details (website, phone), and several logos (Dentsply Sirona, MEET MIS Expert Experience Team, JAT Medical). The overall layout is clean, with white background and blue/orange/black accents.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\n\nUser message context: https://jatmedical.ma/formation-prothese-sur-implants/", "created_at": "2026-04-09T17:14:19.014738", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3407/download", "media_mime_type": "image/jpeg"}, {"id": 13281, "message_id": "AC92F917D67BD9199F033B70D8AB390E", "sender": "user", "message_type": "image", "content": "Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This is a promotional flyer for an implantology training cycle. The upper part contains three dental-themed images: a gloved hand holding a dental implant with crown, a person smiling and holding a dental model showing tooth root anatomy, and an intraoral shot showing a dental implant in the gum. The main text reads 'IMPLANTraining' with emphasis on 'IMPLANT' and 'Training.' The flyer states 'CYCLE IMPLANTOLOGIE.' There is a highlighted section noting '14ème promotion | Casablanca' and the dates 'Module1: 25, 26 Avril 2026.' The flyer provides information about the course's goal and pre-requisites for a university diploma. At the bottom are two headshots of professionals: Dr. Faïçal Benjelloun and Dr. Sefiani Moncef. The bottom bar provides contact information, the website 'WWW.AMEDEDENTAL.COM,' a phone number, program inscription details, and logos for AMEDEDENTAL, ADS, and Lumina Dental Institute.\",\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\nUser message context: https://jatmedical.ma/implant-training/", "created_at": "2026-04-09T17:14:19.387686", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3408/download", "media_mime_type": "image/jpeg"}, {"id": 13282, "message_id": "bot_AC92F917D67BD9199F033B70D8AB390E_1204", "sender": "bot", "message_type": "text", "content": "Bonsoir 😊 Merci d’avoir partagé ces informations sur les différentes formations dentaires à venir (chirurgie guidée, prothèse sur implants, implantologie) organisées à Casablanca.\n\nSi vous souhaitez que je transmette ces annonces à Dr Haitham Boutaib ou à l’équipe du Centre Dentaire Tanger Bay, ou si vous avez une question spécifique concernant ces formations, n’hésitez pas à me le préciser. Je peux faire suivre votre message ou vous aider selon votre besoin.\n\nSouhaitez-vous que j’informe le Dr ou avez-vous une demande particulière à ce sujet ?", "created_at": "2026-04-09T17:14:56.944586", "media_url": null, "media_mime_type": null}, {"id": 13289, "message_id": "ACB15ECCE1EF3831B1093194564ABE9E", "sender": "user", "message_type": "text", "content": "Ça nous fait plaisir de transmettre ces annonces à Dr Haitham aussi l équipe du centre dentaire Tanger Bay.\nMerci 🙏", "created_at": "2026-04-09T17:20:20.834841", "media_url": null, "media_mime_type": null}, {"id": 13290, "message_id": "bot_ACB15ECCE1EF3831B1093194564ABE9E_3734", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre gentillesse et votre partage 🙏 Je vais transmettre ces annonces à Dr Haitham et à toute l’équipe du Centre Dentaire Tanger Bay. Bonne soirée à vous !", "created_at": "2026-04-09T17:20:32.532531", "media_url": null, "media_mime_type": null}, {"id": 15523, "message_id": "AC85580CB0CAF6451EDFED362ED5425E", "sender": "user", "message_type": "image", "content": "Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a promotional flyer for a dental webinar. The top section displays the date and time: 'MARDI 14 AVRIL 2026 14H00 (HEURE DE ROME)'. There is a 'LIVE WEBINAR' label with a microphone icon. The main headline reads: 'PROTOCOLE EASY FIX: Redéfinir la prothèse implantaire fixe sans vis', suggesting a discussion about a protocol for fixed implant prosthesis without screws. The flyer features a large portrait of a smiling man in a suit, identified as DR Emiliano Ferrari. Near him, there is a prosthetic dental arch (likely an upper arch) and a metal dental component (possibly an abutment or another prosthetic part) depicted. The words 'EASY Fix' are presented in large, bold, yellow and green font. In the lower right, the brand 'Rhein83' is present in blue and yellow stylized text. The background is a gradient of black with some yellow and blue accents.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\n\nUser message context: Bonjour,\n\nJ’espère que vous allez très bien.\n\nNous avons le plaisir de vous inviter à notre webinaire en langue française, qui se tiendra aujourd’hui à 13h.\n\nN’hésitez pas à le diffuser auprès de votre laboratoire. Ce contenu pourrait être particulièrement intéressant pour vous ainsi que pour votre prothésiste.\n\n🔹 Présentation de l’événement :\nhttps://www.rhein83.com/en/courses/webinaire-en-direct-mardi-14-avril-2026/\n\n🔹 Inscription :\nhttps://us02web.zoom.us/webinar/register/WN_pQYuAHSeR2uFUySzpLKt6g\n\nJe reste bien entendu à votre entière disposition pour toute question.\n\nBien cordialement,", "created_at": "2026-04-14T12:16:18.510456", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4035/download", "media_mime_type": "image/jpeg"}, {"id": 15524, "message_id": "bot_AC85580CB0CAF6451EDFED362ED5425E_7859", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour cette invitation et pour le partage du webinaire en français 😊 Je vais transmettre l’information à Dr Haitham et à l’équipe du Centre Dentaire Tanger Bay.\n\nSi vous avez d’autres annonces ou besoins, n’hésitez pas à nous en faire part. Bonne journée à vous !", "created_at": "2026-04-14T12:16:38.839589", "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 1132 in training_review_items