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": 38065, "message_id": "3EB097F6FA86ACC3759CEF", "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 is a promotional or confirmation graphic for Tanger Bay Dental Center. It features a smiling cartoon tooth with expressive eyes, eyebrows, and a mouth, giving a thumbs-up gesture with its left hand. The tooth is holding a small spiral-bound notepad with a green checkmark inside a box, symbolizing confirmation. The background shows a blurred dental clinic environment with dental equipment and a chair visible. At the top of the image, there is the logo of Tanger Bay Dental Center with a stylized tooth and text. Over the image, there are two colored bars with text: a larger blue bar with the words 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and a smaller blue bar below stating 'CHEZ TANGER BAY DENTAL CENTER.' The overall color theme is clean and clinical with whites, soft blues, and beige tones.\",\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_\n\nUser message context: Salut *YOUYOU Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mercredi 03 juin 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-06-02T15:05:32.302005", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10613/download", "media_mime_type": "image/jpeg"}, {"id": 38069, "message_id": "3A6D429FFF719F27CA92", "sender": "user", "message_type": "text", "content": "<reply_to>Salut *YOUYOU Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mercredi 0...</reply_to> C okk", "created_at": "2026-06-02T15:09:20.699257", "media_url": null, "media_mime_type": null}, {"id": 38113, "message_id": "3A97CC1579956F05A88A", "sender": "user", "message_type": "text", "content": "<reply_to>Salut *YOUYOU Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mercredi 0...</reply_to> Oui", "created_at": "2026-06-02T15:59:31.838592", "media_url": null, "media_mime_type": null}, {"id": 38114, "message_id": "A572967091786A64D11B2CE94144235C", "sender": "bot", "message_type": "text", "content": "Marhba", "created_at": "2026-06-02T16:00:50.200733", "media_url": null, "media_mime_type": null}, {"id": 38372, "message_id": "3EB0937110586D9C17276A", "sender": "bot", "message_type": "document", "content": "20260603_12463666.pdf", "created_at": "2026-06-03T11:47:16.011604", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10690/download", "media_mime_type": "application/pdf"}, {"id": 39552, "message_id": "3EB0FD2C2DC4736EF89C65", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*YOUYOU Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 06 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لديكم موعد مع ** يوم *السبت 6 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-05T18:14:11.086589", "media_url": null, "media_mime_type": null}, {"id": 39553, "message_id": "3A23086E1B2E4A3FB171", "sender": "user", "message_type": "text", "content": "<reply_to>Bonjour \r\n*YOUYOU Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 06 juin 2026* à *11:30* .\r\nEn cas d'empêchement, veuillez c...</reply_to> Okk", "created_at": "2026-06-05T18:15:15.452007", "media_url": null, "media_mime_type": null}, {"id": 39555, "message_id": "bot_3A23086E1B2E4A3FB171_2959", "sender": "bot", "message_type": "text", "content": "Merci pour votre confirmation Mohamed 😊\n\nVotre rendez-vous du samedi 06 juin 2026 à 11h30 avec le Dr Oussama Mouallem est bien noté.", "created_at": "2026-06-05T18:15:33.089977", "media_url": null, "media_mime_type": null}, {"id": 39556, "message_id": "bot_3A23086E1B2E4A3FB171_8160", "sender": "bot", "message_type": "text", "content": "Si besoin de changement, la réception reste à votre disposition.", "created_at": "2026-06-05T18:15:33.137805", "media_url": null, "media_mime_type": null}, {"id": 39557, "message_id": "bot_3A23086E1B2E4A3FB171_45", "sender": "bot", "message_type": "text", "content": "À bientôt au centre !", "created_at": "2026-06-05T18:15:33.204643", "media_url": null, "media_mime_type": null}, {"id": 39559, "message_id": "3A0782DF02617C9B873D", "sender": "user", "message_type": "text", "content": "<reply_to>Merci pour votre confirmation Mohamed 😊\n\nVotre rendez-vous du samedi 06 juin 2026 à 11h30 avec le Dr Oussama Mouallem est bien noté.</reply_to> 🙏🙏", "created_at": "2026-06-05T18:16:02.054283", "media_url": null, "media_mime_type": null}, {"id": 39561, "message_id": "bot_3A0782DF02617C9B873D_2180", "sender": "bot", "message_type": "text", "content": "Avec plaisir Mohamed 🙏🏻 À très bientôt au centre !", "created_at": "2026-06-05T18:16:13.241672", "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 3203 in training_review_items