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": 43911, "message_id": "AC94381C51ED7144E855F818F6757BDD", "sender": "user", "message_type": "text", "content": "Dear Sir or Madam, I found your contact details online and have a problem: I need to have a tooth restored (specifically, a crown or similar procedure). I will be traveling to Morocco in December and wanted to know if I could get an appointment with you then. I have a 14-day window for this, so the work would need to be completed within that time. Naturally, I would be very happy if I could avoid any pain or complications afterward, as otherwise, I would face difficulties back in Germany—no doctor there is willing to accept work done by another practitioner, especially one from abroad. I hope we can make this work. I speak only German and English, but communication would also be possible with the help of my translator.", "created_at": "2026-06-15T17:07:36.514892", "media_url": null, "media_mime_type": null}, {"id": 43912, "message_id": "A55FAEC6BF1FB25B57E50FFCC3F383F9", "sender": "bot", "message_type": "text", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \nمرحبا بكم فـ عيادة طنجة باي لطب الأسنان.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre équipe puisse vous orienter au mieux.\nمن فضلكم، أخبرونا كيف يمكننا مساعدتكم لكي يتمكن فريقنا من توجيهكم بشكل مناسب\n\n📍 Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n🌐 Site web : www.tangerbay.ma\n📧 Email :\ntangerbay01@gmail.com\n\n✅ Notre équipe vous répondra dans les plus brefs délais.\nسيقوم فريقنا بالرد عليكم في أقرب وقت ممكن", "created_at": "2026-06-15T17:07:37.764032", "media_url": null, "media_mime_type": null}, {"id": 43914, "message_id": "bot_AC94381C51ED7144E855F818F6757BDD_8658", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre message et votre confiance 😊 Nous restons à votre écoute. Si vous avez une demande précise, n'hésitez pas à la partager !", "created_at": "2026-06-15T17:07:48.770166", "media_url": null, "media_mime_type": null}, {"id": 43928, "message_id": "A5CA3D555C51D5F1C08B4D3F39F27772", "sender": "bot", "message_type": "text", "content": "Thank you for your message.\nYes, of course, we would be happy to welcome you to our clinic during your stay in Morocco in December.\nA 14-day stay is generally sufficient for a crown treatment, depending on the condition of the tooth. We would first carry out a clinical examination and any necessary X-rays to determine the most appropriate treatment plan. In many cases, the crown can be completed within your available timeframe.\nOur priority is to ensure that the treatment is carried out comfortably and carefully to minimize the risk of pain or complications after your return to Germany. However, the final treatment plan can only be confirmed after an examination.", "created_at": "2026-06-15T17:13:04.547366", "media_url": null, "media_mime_type": null}, {"id": 43931, "message_id": "AC9777FCD4E1D9E81E312F89D85BA6E9", "sender": "user", "message_type": "text", "content": "I will contact you when I arrive in Tanga; I am leaving Germany on December 23rd and will fly back on January 6th.", "created_at": "2026-06-15T17:16:08.035283", "media_url": null, "media_mime_type": null}, {"id": 43932, "message_id": "AC7645FD4FC4E3BD145549752D437271", "sender": "user", "message_type": "text", "content": "Thank you so much🦷", "created_at": "2026-06-15T17:16:57.904548", "media_url": null, "media_mime_type": null}, {"id": 44750, "message_id": "A59A09E590808208319D483C1687290D", "sender": "bot", "message_type": "text", "content": "Welcome", "created_at": "2026-06-17T10:28:30.546852", "media_url": null, "media_mime_type": null}, {"id": 48998, "message_id": "AC4D3063EF108D1CC758DF0245CB5AE3", "sender": "user", "message_type": "text", "content": "👍", "created_at": "2026-06-26T12:50:20.554954", "media_url": null, "media_mime_type": null}, {"id": 48999, "message_id": "bot_AC4D3063EF108D1CC758DF0245CB5AE3_8107", "sender": "bot", "message_type": "text", "content": "Merci à vous 🙏🏻 N’hésitez pas si vous avez besoin de quelque chose !", "created_at": "2026-06-26T12:50:33.708728", "media_url": null, "media_mime_type": null}, {"id": 49000, "message_id": "AC8451D87F1DD2C60EB06BC9D9E7CAC6", "sender": "user", "message_type": "text", "content": "😂", "created_at": "2026-06-26T12:51:09.525776", "media_url": null, "media_mime_type": null}, {"id": 49001, "message_id": "bot_AC8451D87F1DD2C60EB06BC9D9E7CAC6_2054", "sender": "bot", "message_type": "text", "content": "😊 بارك الله فيكوم! إذا احتاجيتو شي حاجة، أنا هنا.", "created_at": "2026-06-26T12:51:21.015398", "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 4033 in training_review_items