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": 42126, "message_id": "3EB03BB5DC7C87D3BBCA3C", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Lounes*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *17: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* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-11T16:11:56.328238", "media_url": null, "media_mime_type": null}, {"id": 44904, "message_id": "3EB0F8CCD23078600B3191", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Lounes*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *17: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* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-17T15:02:03.425325", "media_url": null, "media_mime_type": null}, {"id": 44916, "message_id": "3EB0827364EEE158E21B2D", "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 an illustrated promotional or confirmation graphic for Tanger Bay Dental Center. It features an anthropomorphic smiling tooth cartoon character giving a thumbs up and holding a notepad with a large green checkmark. There is prominent French and English text in blue and white at the top and center over a dental operatory background with soft focus, showing a dental chair and equipment. The logo for Tanger Bay Dental Center (a stylized tooth with waves) appears at the top.\",\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    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n\nUser message context: Salut *BRAHIMI Lounes*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 18 juin 2026*\r\n🕘 Heure : *17: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:05:55.374739", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12391/download", "media_mime_type": "image/jpeg"}, {"id": 44919, "message_id": "3A8272C72158F6F50A11", "sender": "user", "message_type": "text", "content": "oui", "created_at": "2026-06-17T15:09:31.354232", "media_url": null, "media_mime_type": null}, {"id": 45147, "message_id": "3EB093EA885AC58774E1EF", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Lounes*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *16: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* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-18T11:23:23.375931", "media_url": null, "media_mime_type": null}, {"id": 45150, "message_id": "A5782A358854B7CC9B8D5F343D281559", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n\"Salut les ça va, j'espère que vous allez bien. Euh, moi je voulais juste vous informer que le rendez-vous ça sera à 6 heures, d'accord ?\"", "created_at": "2026-06-18T11:23:45.062549", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12466/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45164, "message_id": "3A15658A41C022E49815", "sender": "user", "message_type": "text", "content": "oui", "created_at": "2026-06-18T11:34:56.684817", "media_url": null, "media_mime_type": null}, {"id": 45400, "message_id": "A5BC376EC17FC3FF6CAFB879585E45E2", "sender": "bot", "message_type": "text", "content": "Salam", "created_at": "2026-06-18T15:28:31.349465", "media_url": null, "media_mime_type": null}, {"id": 45401, "message_id": "A58B0883A39FBF47475015837BB08212", "sender": "bot", "message_type": "text", "content": "???", "created_at": "2026-06-18T15:29:01.415507", "media_url": null, "media_mime_type": null}, {"id": 45816, "message_id": "3AC4BC65A9C937BF32B4", "sender": "user", "message_type": "text", "content": "salam j’etait malade désolé je peut avoir un autre rendez vous s’il vous plait", "created_at": "2026-06-19T18:18:34.481816", "media_url": null, "media_mime_type": null}, {"id": 45817, "message_id": "bot_3AC4BC65A9C937BF32B4_1932", "sender": "bot", "message_type": "text", "content": "Aucun souci, j’espère que vous allez mieux.", "created_at": "2026-06-19T18:19:11.994529", "media_url": null, "media_mime_type": null}, {"id": 45818, "message_id": "bot_3AC4BC65A9C937BF32B4_9261", "sender": "bot", "message_type": "text", "content": "Pour reprogrammer votre rendez-vous, pouvez-vous me donner votre nom complet et me préciser le soin souhaité ainsi que vos disponibilités ?", "created_at": "2026-06-19T18:19:12.043550", "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 3771 in training_review_items