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": 7024, "message_id": "3EB0E72C9F355ECAF8FB3F", "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 depicts a stylized cartoon tooth character smiling and giving a thumbs-up while holding a clipboard with a green checkmark. The background shows a blurred, out-of-focus dental clinic setting with a dental chair and cabinets. The top of the image includes text and a logo of the Tanger Bay Dental Center. The logo consists of a white outline of a tooth with the name of the clinic below it.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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    \"other_findings\": null\n  },\n  \"text_visible\": [\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"The image is promotional and does not\n\nUser message context: Salut *BEN WARET Yasmina*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. RIAD GUENNOUNI*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 27 mars 2026*\r\n🕘 Heure : *11: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-03-26T15:06:32.625243", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1418/download", "media_mime_type": "image/jpeg"}, {"id": 7221, "message_id": "3EB0E758900FB44C7560B9", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BEN WARET Yasmina*\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *vendredi 27 mars 2026* à *11: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لديكم موعد مع ** يوم *الجمعة 27 مارس 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-26T18:50:54.294217", "media_url": null, "media_mime_type": null}, {"id": 7309, "message_id": "3EB00D2D0A014CD0946D20", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BEN WARET Yasmina*\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *vendredi 27 mars 2026* à *11: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لديكم موعد مع ** يوم *الجمعة 27 مارس 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-27T08:27:17.071539", "media_url": null, "media_mime_type": null}, {"id": 7446, "message_id": "A550ABD434248BC33ADE03AD0E9199B7", "sender": "user", "message_type": "text", "content": "Salam wa3elikom khrejtli whd khdma daroriii", "created_at": "2026-03-27T13:50:02.140514", "media_url": null, "media_mime_type": null}, {"id": 7447, "message_id": "A5185A32D168C24F733E24BCE7F995DF", "sender": "user", "message_type": "text", "content": "Min nbghi n9dar nbdel rendez-vous", "created_at": "2026-03-27T13:50:24.567628", "media_url": null, "media_mime_type": null}, {"id": 7455, "message_id": "A57C833BD81580BB3DBC94EDB82F0669", "sender": "bot", "message_type": "text", "content": "Had simana 3andi 3amra", "created_at": "2026-03-27T13:55:57.953584", "media_url": null, "media_mime_type": null}, {"id": 7488, "message_id": "A5C0FEEB78293DB450275486840BF0C4", "sender": "user", "message_type": "text", "content": "Ahh bsah", "created_at": "2026-03-27T14:31:59.008181", "media_url": null, "media_mime_type": null}, {"id": 7570, "message_id": "A5A24C5C43EE9C8A9830F4C220208D4D", "sender": "user", "message_type": "text", "content": "Ghada n9dar nji?", "created_at": "2026-03-27T15:24:50.278381", "media_url": null, "media_mime_type": null}, {"id": 7572, "message_id": "bot_A5A24C5C43EE9C8A9830F4C220208D4D_5427", "sender": "bot", "message_type": "text", "content": "Bonjour Yasmina 😊\n\nJe vois que vous avez un rendez-vous prévu avec Dr. RIAD GUENNOUNI le vendredi 27 mars 2026 à 11:00. Si vous souhaitez modifier ce rendez-vous, je vous recommande de contacter directement la réception au 06 60 02 22 63 ou 05 39 94 80 14 pour voir les disponibilités. Merci de votre compréhension et à bientôt إن شاء الله 🙏🏻", "created_at": "2026-03-27T15:25:09.023338", "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 273 in training_review_items