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": 14378, "message_id": "A5DD5AA02FDC87C4FEE6336F9E59CCFD", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-12T15:12:00.802786", "media_url": null, "media_mime_type": null}, {"id": 14629, "message_id": "3EB00053E119220E0C7B5C", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ALAIN Azar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 16 avril 2026* à *14: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*ALAIN*\r\nلديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-13T08:14:45.673479", "media_url": null, "media_mime_type": null}, {"id": 16209, "message_id": "3EB032DD4F85BD69D61364", "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 shows a digital illustration of an anthropomorphic tooth character, smiling and giving a thumbs-up. The tooth is holding a notepad with a large checked box on it, indicating confirmation. The background appears to represent a dental clinic interior with blurred dental chair and equipment. At the top, the logo of Tanger Bay Dental Center is visible, featuring a tooth outline and the words 'Tanger Bay Dental Center.' The text in the image, written in French, reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check mark and 'CHEZ TANGER BAY DENTAL CENTER' below it. The colors are mainly blue and white with a professional, welcoming aesthetic.\",\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\nUser message context: Salut *ALAIN Azar*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 16 avril 2026*\r\n🕘 Heure : *14: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-04-15T15:04:27.582067", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4263/download", "media_mime_type": "image/jpeg"}, {"id": 16231, "message_id": "3EB03AFF6D1C931A096584", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ALAIN Azar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 16 avril 2026* à *14: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*ALAIN*\r\nلديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *14:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-15T15:18:41.602750", "media_url": null, "media_mime_type": null}, {"id": 16369, "message_id": "2A34CA3E76875C06F5C2", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-15T16:43:36.205909", "media_url": null, "media_mime_type": null}, {"id": 16370, "message_id": "bot_2A34CA3E76875C06F5C2_8399", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre confirmation Alain 😊\n\nVotre rendez-vous avec Dr Haitham Boutaib est bien confirmé pour jeudi 16 avril 2026 à 14:00. Si jamais vous avez un empêchement, n'hésitez pas à contacter la réception au 06 60 02 22 63.\n\nAu plaisir de vous accueillir au Centre Dentaire Tanger Bay !", "created_at": "2026-04-15T16:43:56.770439", "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 1217 in training_review_items