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": 8121, "message_id": "3EB0B73CC931A1AE5C3FA1", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*AMELLAL Fouad*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 30 mars 2026* à *18: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لديكم موعد مع ** يوم *الأثنين 30 مارس 2026* على الساعة *18:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-28T14:41:42.547689", "media_url": null, "media_mime_type": null}, {"id": 8221, "message_id": "3EB01CD9F82BEC1F9B130E", "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 features a dental-themed promotional graphic. In the foreground, there is a large cartoon tooth character with a smiling face, black eyes, raised eyebrows, and a thumb up gesture. The tooth character is holding a small spiral notepad featuring a green check mark inside a box. Behind the cartoon character, the background is a blurred image of a dental office, including a dental chair and clinical furniture. At the top of the image, the logo for 'Tanger Bay Dental Center' is visible, featuring a white stylized tooth and the clinic name. Central text in bold white letters on a blue background reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check mark. Below, another blue text bar states 'CHEZ TANGER BAY DENTAL CENTER.' The overall tone is friendly and reassuring, aiming to confirm a dental appointment.\",\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    \"per\n\nUser message context: Salut *AMELLAL Fouad*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *lundi 30 mars 2026*\r\n🕘 Heure : *18: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-28T23:02:42.124714", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1790/download", "media_mime_type": "image/jpeg"}, {"id": 8564, "message_id": "3EB08C81E1DF7A6087DEA7", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*AMELLAL Fouad*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *lundi 30 mars 2026* à *18: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لديكم موعد مع ** يوم *الأثنين 30 مارس 2026* على الساعة *18:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-30T08:06:46.586565", "media_url": null, "media_mime_type": null}, {"id": 8600, "message_id": "A5058E12E4ACE2264FE231C8885569B2", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script) with the French loanwords as spoken:\n\n\"السلام عليكم، صافا لاباس عليك؟ كنتمنى تكون مزيان بخير وعلى خير. خاي الله يخليك كونفيرمي معايا على حساب لورونديفو واش غتجي ولا مغتجيشي، باش أنا كنعرف راسي شنو غنعمل واش نخلي ليكم لورونديفو ديالكم ولا نعمرو بناس خرين حيت الناس كيسقسيوني. رد عليا عافاك، شكراً.\"\n\n**Latin Script Version (Transcription):**\n\"Assalamu alaykum, ça va labas 3lik? Kantmenna tkoun mzyan bikhir wa 3la khir. Khay lah ykhallik confirmer m3aya 3la 7sab le rendez-vous wach ghatji wlla ma-ghatjichi, bach ana k-na3ref rassi chnou gha-n3mel wach nkhalli likom le rendez-vous dyalkom wlla n-3emmrou b nas khrin hit n-nas kaysaqsyouni. Rod 3lia 3afak, chokran.\"", "created_at": "2026-03-30T08:51:55.053080", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1870/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8601, "message_id": "3A6E2E64FB35893EAD4A", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French:\n\n**Arabic Script:**\nألو، كيدايرة؟ لاباس عليك؟ بيخير؟ مزيان؟ صافي إن شاء الله، c'est confirmé le rendez-vous مع الستة. الله يخليك شكراً.\n\n**Latin Script:**\nAllo, kidayra? Labas 3lik? Bikher? Mzyan? Safi in sha Allah, c’est confirmé le rendez-vous m3a l-setta. Allah ykhallik chokran.", "created_at": "2026-03-30T08:53:50.270339", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1871/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8604, "message_id": "bot_3A6E2E64FB35893EAD4A_4687", "sender": "bot", "message_type": "text", "content": "مرحبا شكرا بزاف على التأكيد ديالك Fouad 😊 الموعد ديالك مع الدكتور هايثم بوتيب غادي يبقى محفوظ ليكوم نهار الاثنين 30 مارس 2026 على الساعة 18:00. نتسناوكوم إن شاء الله، وأي سؤال حنا رهن الاشارة!", "created_at": "2026-03-30T08:54:29.049876", "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 425 in training_review_items