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": 47701, "message_id": "3A832883F2EF902A5664", "sender": "user", "message_type": "text", "content": "surgam yek", "created_at": "2026-06-24T10:34:39.576802", "media_url": null, "media_mime_type": null}, {"id": 47702, "message_id": "A5E3485059122FC5D8486548EF4BC854", "sender": "bot", "message_type": "voice", "content": "[Voice message] السوغام، السوغام غاتشربوا تلت أيام، صافي؟", "created_at": "2026-06-24T10:37:44.730198", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13221/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47714, "message_id": "3ABE53839312155AC946", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"صافي شكرا، ولكن خاصني ناخد تلت أيام زعما دبا ياك؟ تلت أيام قبل l'extraction.\"\n\n**Latin Script:**\n\"Safi shokran, walakin khassni nakhod telt ayyam zaama daba yak? Telt ayyam qbal l'extraction.\"\n\n**Translation (for context):**\n\"Okay thank you, but I need to take [it] for three days starting now, right? Three days before the extraction.\"", "created_at": "2026-06-24T10:54:58.100281", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13224/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47715, "message_id": "A57383F65841A521F9C5AF712E2010DC", "sender": "bot", "message_type": "voice", "content": "[Voice message] The audio is in Moroccan Darija and can be transcribed as follows:\n\n**Arabic Script:**\nآه، خد اليوم وغدا إن شاء الله والجمعة ف الصباح، صافي؟\n\n**Latin Script:**\nAh, khoud lyouma w ghada inchallah w ljoumou3a f sbah, safi?\n\n**English Translation (for context):**\n\"Ah, take [it/them] today, tomorrow God willing, and Friday morning, okay?\"", "created_at": "2026-06-24T10:55:19.419901", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13225/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47716, "message_id": "3A4DF5F48ACCAB69961D", "sender": "user", "message_type": "text", "content": "chokran", "created_at": "2026-06-24T10:55:38.539613", "media_url": null, "media_mime_type": null}, {"id": 48567, "message_id": "3EB0BEB6954023E2A29D3E", "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 informational graphic for Tanger Bay Dental Center. The upper section features the clinic logo, which incorporates a stylized tooth and the text 'TANGER BAY DENTAL CENTER.' Below it, there is a blue banner with the text 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (Your appointment is confirmed) with a check mark icon next to it. Another blue banner underneath states 'CHEZ TANGER BAY DENTAL CENTER.' The background shows a blurred dental clinic environment, including a dental chair and equipment. In the foreground, there is a large, animated cartoon tooth character with a smiling face, eyebrows, and expressive eyes, holding a small calendar or notepad with a green check mark on it and giving a thumbs up gesture. The image is well-lit, colorful, and primarily uses shades of blue, white, and beige.\",\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\nUser message context: Salut *JAWAD  BOUYAZZIM*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 26 juin 2026*\r\n🕘 Heure : *16: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-25T15:53:37.302865", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13516/download", "media_mime_type": "image/jpeg"}, {"id": 48569, "message_id": "3A8F2CBBC695843B1B91", "sender": "user", "message_type": "text", "content": "oui", "created_at": "2026-06-25T15:54:16.595800", "media_url": null, "media_mime_type": null}, {"id": 49178, "message_id": "3A9504638E3A359068BE", "sender": "user", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> ?", "created_at": "2026-06-26T17:05:08.977595", "media_url": null, "media_mime_type": null}, {"id": 49179, "message_id": "bot_3A9504638E3A359068BE_5379", "sender": "bot", "message_type": "text", "content": "Merci pour votre confirmation, Jawad 😊 Votre rendez-vous du vendredi 26 juin à 16:00 chez Dr Haitham Boutaib est bien noté.", "created_at": "2026-06-26T17:06:02.021528", "media_url": null, "media_mime_type": null}, {"id": 49180, "message_id": "bot_3A9504638E3A359068BE_9058", "sender": "bot", "message_type": "text", "content": "Si vous avez une question précise ou si vous souhaitez envoyer un message vocal, n’hésitez pas à préciser votre demande par écrit ici pour que je puisse bien vous aider.", "created_at": "2026-06-26T17:06:02.078561", "media_url": null, "media_mime_type": null}, {"id": 49181, "message_id": "bot_3A9504638E3A359068BE_9185", "sender": "bot", "message_type": "text", "content": "Vous pouvez aussi appeler directement la réception au 06 60 02 22 63 si besoin.", "created_at": "2026-06-26T17:06:02.116152", "media_url": null, "media_mime_type": null}, {"id": 49182, "message_id": "bot_3A9504638E3A359068BE_7985", "sender": "bot", "message_type": "text", "content": "Je reste à votre disposition !", "created_at": "2026-06-26T17:06:02.159000", "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 4041 in training_review_items