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": 10925, "message_id": "A5EE41792CB1CCF0E0E6E19C4003CC10", "sender": "bot", "message_type": "text", "content": "J'espère que vous allez bien", "created_at": "2026-04-02T16:41:29.997704", "media_url": null, "media_mime_type": null}, {"id": 13047, "message_id": "2AC5ED0A7442EE041018", "sender": "user", "message_type": "text", "content": "Alikoum salam ça va et vous", "created_at": "2026-04-09T11:32:18.483652", "media_url": null, "media_mime_type": null}, {"id": 13048, "message_id": "bot_2AC5ED0A7442EE041018_1162", "sender": "bot", "message_type": "text", "content": "Merci beaucoup, tout va bien également 😊 Je reste à votre disposition si vous avez besoin d’informations ou d’aide concernant le Centre Dentaire Tanger Bay. Comment puis-je vous aider aujourd’hui ?", "created_at": "2026-04-09T11:32:31.279507", "media_url": null, "media_mime_type": null}, {"id": 13052, "message_id": "2A6CE96855AFCFA82AB3", "sender": "user", "message_type": "text", "content": "Je peux passer aujourd’hui ou demin ?", "created_at": "2026-04-09T11:33:12.290793", "media_url": null, "media_mime_type": null}, {"id": 13053, "message_id": "bot_2A6CE96855AFCFA82AB3_4145", "sender": "bot", "message_type": "text", "content": "Avec plaisir ! Pour organiser votre passage, pouvez-vous me préciser votre nom complet, le type de soin ou la raison de votre visite, ainsi que le créneau horaire qui vous conviendrait aujourd’hui ou demain ?", "created_at": "2026-04-09T11:33:24.531931", "media_url": null, "media_mime_type": null}, {"id": 13054, "message_id": "2ADFE2D3554EB5016887", "sender": "user", "message_type": "text", "content": "Razzouk Karim", "created_at": "2026-04-09T11:33:40.392998", "media_url": null, "media_mime_type": null}, {"id": 13055, "message_id": "bot_2ADFE2D3554EB5016887_720", "sender": "bot", "message_type": "text", "content": "Merci Karim ! Pouvez-vous aussi me préciser le type de soin ou la raison de votre visite, ainsi que le moment qui vous arrange le plus (aujourd’hui ou demain, matin ou après-midi) ?", "created_at": "2026-04-09T11:33:56.008695", "media_url": null, "media_mime_type": null}, {"id": 14065, "message_id": "A5342957BC9730FA4220F7263E02A38C", "sender": "bot", "message_type": "text", "content": "Salam alikom", "created_at": "2026-04-11T13:20:54.336607", "media_url": null, "media_mime_type": null}, {"id": 14066, "message_id": "A5880540348B1BE1F781D806CF686333", "sender": "bot", "message_type": "text", "content": "Cava  j'espère que vous allez bien", "created_at": "2026-04-11T13:21:10.512314", "media_url": null, "media_mime_type": null}, {"id": 15698, "message_id": "A5DD405A8B7C25AFE10DCB6E5049FFF5", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija (incorporating the French terms used):\n\n**Arabic Script:**\n\"السلام عليكم سي كريم، كيف تينا مزيان؟ بخير؟ الصحة لاباس؟ سي كريم كنعيط لك على حساب عملنا غادي نبداو إن شاء الله plan de traitement ديالك، وباقي ما رديتيش عليا، باش نشوفوا شي rendez-vous إن شاء الله، شي وقيّت باش نبداو إن شاء الله يا ربي.\"\n\n**Latin Script (Transcription):**\n\"السلام عليكم (As-salamu alaykum) Si Karim, kif tina mzyan? Bekher? Seha labas? Si Karim, kan 3ayetlek 3la hsab 3melna ghadi nebdaou inshallah **plan de traitement** dyalek, u baqi ma raditi chi 3liya, bash nchoufou chi **rendez-vous** inshallah, shi wqeyyet bash nebdaou inshallah ya rabbi.\"", "created_at": "2026-04-14T16:22:46.754603", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4085/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15747, "message_id": "2A514CD887EA2825AEE5", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\nالسلام عليكم، لاباس بخير؟ اسمح لي يلا دخلت لطنجة. قولي لي إلى ممكن ندوز غدا إن شاء الله. قولي لي معاش نجي لعندكم.\n\n**Latin Script:**\nSalamu alaykom, labas bikhir? Smah liya yallah dkhelt l Tanja. Goliya ila momkin ndouz ghedda inshallah. Goliya m'aash nji laandkom.\n\n**English Translation (for context):**\n\"Peace be upon you, are you doing well? Sorry, I just arrived in Tangier. Tell me if it's possible for me to come by tomorrow, God willing. Tell me what time I should come to you.\"", "created_at": "2026-04-14T16:52:15.755867", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4112/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15748, "message_id": "bot_2A514CD887EA2825AEE5_8912", "sender": "bot", "message_type": "text", "content": "مرحبا سي Karim 😊 شكراً على التوضيح. باش نكملو الحجز، واش ممكن تقولي ليا شنو نوع العلاج أو الخدمة اللي محتاج تدير غداً؟ وشنو الوقت اللي مناسبك أكثر (الصباح ولا العشية)؟", "created_at": "2026-04-14T16:52:42.106592", "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 1162 in training_review_items