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": 17676, "message_id": "3EB08F121F87C427267C2D", "sender": "bot", "message_type": "text", "content": "صحتك  هي أولويتنا، ويسعدنا خدمتك في مركز الدكتور ديناني هشام لطب الأسنان. نحن نقدر رضاك ونود أن نطلب منك تقييم تجربتك معنا باتباع هذا الرابط https://bit.ly/3yYyxc3. يتطلب التقييم خطوتين بسيطتين، يرجى التأكد من إكمال كل منهما حتى يتم قبول نتيجة التقييم بشكل جيد. شكرًا !\r\n\r\nVotre santé est notre priorité, et nous sommes heureux de vous servir au sein du Centre dentaire du Dr Dinani Hicham. Nous accordons une grande importance à votre satisfaction et aimerions vous demander d'évaluer votre expérience avec nous en suivant ce lien https://bit.ly/3yYyxc3. L'évaluation nécessite deux étapes simples, veuillez-vous assurer de compléter chacune d'elles afin que le résultat de votre évaluation soit bien reçu. Merci !", "created_at": "2026-04-23T09:43:50.438317", "media_url": null, "media_mime_type": null}, {"id": 17695, "message_id": "AC8AA365D4AC786B48EF4EE07114C43C", "sender": "user", "message_type": "image", "content": "[Image analysis] Image description: (a) Type of image: This appears to be a dental photo.\n\n(b) Visually observable details (neutral, non-diagnostic language): The image shows a close-up of a person's teeth with clear orthodontic brackets attached to the front teeth. Multiple teeth appear to have visible dark brown discoloration and uneven coloration. The lips and part of the surrounding skin are also visible. The teeth are in various positions, and the gums can be seen above the upper teeth.\n\n(c) Visible text (OCR): There is no visible text in the image.\n\n(d) Flag: No diagnostic terms, no suggestions of conditions, no recommendations for treatment provided. Output is strictly factual and observational.\n\nUser message context: (a) Image type: Dental photo  \n(b) Description: The image shows an open mouth with visible upper and lower teeth. There are clear or white orthodontic brackets attached to the teeth. There is visible brown discoloration on multiple teeth.  \n(c) Visible text (OCR): There is no visible text in the image.  \n(d) Flag: No diagnostic terms used, no conditions suggested, no treatments recommended. This is a factual and observational description only.", "created_at": "2026-04-23T10:16:33.708445", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4818/download", "media_mime_type": "image/jpeg"}, {"id": 17696, "message_id": "AC301B3C9437CDFA2786B9C829F0E061", "sender": "user", "message_type": "image", "content": "[Image analysis] (a) **Type of image:** Dental photo\n\n(b) **Visually observable details:**  \n- The photo shows a close-up of a person's lower teeth.\n- Several teeth have clear or white orthodontic brackets attached.\n- There is a visible green arrow drawn on the photo, pointing to a specific tooth.\n- Some teeth show visible color variation.\n- The lips and some facial skin are also visible, and a finger is pulling down the lower lip.\n\n(c) **Visible text (OCR):**  \n- No alphanumeric text visible, only a green arrow as a graphic overlay.\n\n(d) **Flag:**  \n- No diagnostic terms used.\n- No conditions or treatments suggested.\n- Description is factual and observational only.", "created_at": "2026-04-23T10:16:34.433616", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4819/download", "media_mime_type": "image/jpeg"}, {"id": 17697, "message_id": "bot_AC301B3C9437CDFA2786B9C829F0E061_8461", "sender": "bot", "message_type": "text", "content": "الفريق غادي يتواصلوا بيكوم بهاد الموضوع إن شاء الله 🙏🏻", "created_at": "2026-04-23T10:17:05.588212", "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 1364 in training_review_items