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": 4742, "message_id": "AC9C78087648D1486F985804D9D71B5A", "sender": "user", "message_type": "text", "content": "https://www.facebook.com/share/v/1CCvXepwoF/", "created_at": "2026-03-14T17:24:27.227240", "media_url": null, "media_mime_type": null}, {"id": 4743, "message_id": "bot_AC9C78087648D1486F985804D9D71B5A_3251", "sender": "bot", "message_type": "text", "content": "كنعتدر، ما نقدرش نفتح الروابط الخارجية مباشرة. واش كاين شي حاجة معينة بغيتي نعرفها أو نعاونك بها؟ 😊", "created_at": "2026-03-14T17:24:36.797441", "media_url": null, "media_mime_type": null}, {"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 analysis] Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a promotional flyer/poster for a dental continuing education course titled 'Formation Chirurgie Guidée' (Guided Surgery Training). The background includes dental surgical guide imagery and designs in blue. The main text is in French, with key details such as dates, location, and instructors. Three presenters' photographs are shown at the bottom, with their names displayed. Several logos (MIS Guide, JAT Medical, Dentsply Sirona, and Lumina Dental Institute) are present. Course modules and contact details are provided, as well as information for registration.\",\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    \"MIS Guide\",\n    \"JAT Medical\",\n    \"Dentsply Sirona\",\n    \"+\",\n    \"Formation CHIRURGIE GUIDÉE\",\n    \"Observer - Comprendre - Maîtriser\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 analysis] Image description: ```json\n{\n  \"visible_domain\": \"document\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"This image is an advertisement for a dental training event titled 'FORMATION PROTHÈSE SUR IMPLANTS' (Implant Prosthetics Training). The top contains a row of clinical dental photos showing various prosthetic and implant procedures on teeth. There is large blue and black text with course title and details. The event is scheduled for 18, 19 April 2026 in Casablanca, organized by Lumina Dental Institute. The target audience is 'Médecins Dentistes' (Dental Doctors). The objectives are listed in French, focusing on understanding prosthesis concepts for implants, modern techniques, prevention of complications, and successful management steps. There is an image of a man in a suit (identified in text as Dr. Taher Adlouni) on the right. The bottom contains program and registration information with a website (www.jatmedical.ma) and a phone number (+212-661 727 036), along with sponsor logos: Dentsply Sirona, MEET, and JAT Medical.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"unclear\",\n    \"bone_level\": null,\n    \"root_canals\": null,\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 analysis] 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 a dental implantology training cycle named 'IMPLANT Training'. The upper section displays three dental-themed images: a dental implant model, a hand holding a cross-sectional tooth model, and a clinical photo of an implant being inserted into the upper jaw. Below, bold text highlights the program name, location, and module date: '14ème promotion | Casablanca, Module 1: 25, 26 Avril 2026'. Additional details mention the training focus, the names and photos of two practitioners (Dr. Faïçal Benjelloun, Dr. Sefiani Moncef), and registration information, including a website, phone number, and organizing organizations/logos. The background uses white, orange, blue, and grey color accents.\",\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\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}]

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 904 in training_review_items