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": 44218, "message_id": "3EB0648184D489DA989A3F", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2100,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-16T10:11:40.005660", "media_url": null, "media_mime_type": null}, {"id": 44219, "message_id": "3EB027073BDC5113CAEC9A", "sender": "bot", "message_type": "document", "content": "2026061611104723.pdf", "created_at": "2026-06-16T10:12:10.158211", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12172/download", "media_mime_type": "application/pdf"}, {"id": 44312, "message_id": "3EB03F69EDF191B941CE3F", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*FATIMA Bounadem*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 18 juin 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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-16T11:56:56.498911", "media_url": null, "media_mime_type": null}, {"id": 44889, "message_id": "3EB099724395FEA7A4E096", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*FATIMA Bounadem*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 18 juin 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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-17T14:58:26.202759", "media_url": null, "media_mime_type": null}, {"id": 44908, "message_id": "3EB077621A38537F33B45C", "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 the Tanger Bay Dental Center. It features a large cartoon tooth with smiling facial features, holding a small calendar with a green check mark, indicating confirmation. The background shows a dental clinic room with a blurred dental chair and instruments. At the top, there is the Tanger Bay Dental Center logo, which consists of a stylized tooth and text. The image includes bold blue bands with white French text indicating that an appointment is confirmed. The scene is bright, well-lit, and visually appealing, with a pastel and blue color palette. No actual clinical or real dental/medical content is present.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\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    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONF\n\nUser message context: Salut *FATIMA Bounadem*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 18 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-17T15:03:27.751905", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12384/download", "media_mime_type": "image/jpeg"}, {"id": 44923, "message_id": "AC9A16C253814E94DE27A7BA6414AB43", "sender": "user", "message_type": "text", "content": "Je confirme", "created_at": "2026-06-17T15:21:30.620388", "media_url": null, "media_mime_type": null}, {"id": 44924, "message_id": "AC4C07D531484190255AF7C6915A77F1", "sender": "user", "message_type": "text", "content": "Ana wselt", "created_at": "2026-06-17T15:21:45.214306", "media_url": null, "media_mime_type": null}, {"id": 45166, "message_id": "3EB0478AE7E23BF0F6CF58", "sender": "bot", "message_type": "text", "content": "Bonjour FATIMA Bounadem", "created_at": "2026-06-18T11:37:19.184418", "media_url": null, "media_mime_type": null}, {"id": 45167, "message_id": "A5E21C254B8E59348A474616B065E892", "sender": "bot", "message_type": "text", "content": "Titulaire : HAITHAM BOUTAIB\nRIB : 230 825 2602742211029400 66\nIBAN : MA64 2308 2526 0274 2211 0294 0066 \nCode SWIFT : CIHMMAMC", "created_at": "2026-06-18T11:37:23.610491", "media_url": null, "media_mime_type": null}, {"id": 48127, "message_id": "AC1BF1FB464C958C33D6F310EFBDB239", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-06-24T17:30:51.298647", "media_url": null, "media_mime_type": null}, {"id": 48128, "message_id": "AC709D8B68023FD7472943153E1BEDF7", "sender": "user", "message_type": "text", "content": "Stp je veux un rdv pour vendredi ila momkin", "created_at": "2026-06-24T17:31:17.697902", "media_url": null, "media_mime_type": null}, {"id": 48129, "message_id": "bot_AC709D8B68023FD7472943153E1BEDF7_6251", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Avec plaisir ! Pouvez-vous me donner votre nom complet et le type de soin souhaité pour vendredi ?", "created_at": "2026-06-24T17:31:39.479026", "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 3987 in training_review_items