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": 5999, "message_id": "3A67B10141888EBBBD8B", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-03-17T17:51:07.160049", "media_url": null, "media_mime_type": null}, {"id": 6000, "message_id": "bot_3A67B10141888EBBBD8B_4032", "sender": "bot", "message_type": "text", "content": "Bonjour ! Je suis l'assistant du Centre Dentaire El Ouazzani. Comment puis-je vous aider aujourd'hui ? 😊", "created_at": "2026-03-17T17:51:17.733380", "media_url": null, "media_mime_type": null}, {"id": 6297, "message_id": "3A9C1DA28B5EC7BFDBF3", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-03-18T16:09:19.594358", "media_url": null, "media_mime_type": null}, {"id": 6298, "message_id": "bot_3A9C1DA28B5EC7BFDBF3_7630", "sender": "bot", "message_type": "text", "content": "Bonjour ! Comment puis-je vous aider aujourd'hui au Centre Dentaire El Ouazzani ? 😊", "created_at": "2026-03-18T16:09:32.351559", "media_url": null, "media_mime_type": null}, {"id": 6310, "message_id": "3A83900AC00E743C4F5E", "sender": "user", "message_type": "text", "content": "🙂", "created_at": "2026-03-18T16:42:51.264446", "media_url": null, "media_mime_type": null}, {"id": 6311, "message_id": "bot_3A83900AC00E743C4F5E_4245", "sender": "bot", "message_type": "text", "content": "Si vous avez des questions ou besoin d'informations sur nos services, n'hésitez pas à me le faire savoir. Je suis là pour vous aider ! 😊", "created_at": "2026-03-18T16:43:02.553735", "media_url": null, "media_mime_type": null}, {"id": 7585, "message_id": "A56CD33CAB1EFC6DB2F4015CAD06959A", "sender": "bot", "message_type": "voice", "content": "[Voice message] إليك تفريغ المقطع الصوتي باللهجة المغربية:\n\n\"السلام حفصة، كي دايرة لاباس عليك بخير مزيان؟ سمحي لي إلا كنت شي كنجاوبك (تعطلت عليك فالمجاوبة)، كان عندي واحد الضغط د الخدمة ماشي عادي. بالنسبة للوراق الله يعطيك الستر إلا كنتي نتي هنا ولا شي واحد يقدر يدوز للعيادة يجيب ليا واحد جوج وراق باش نعمرهم لك، صافي أختي؟\"", "created_at": "2026-03-27T15:31:10.810467", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/1594/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7598, "message_id": "3A86434595EEFAFBF554", "sender": "user", "message_type": "text", "content": "Andi ghir warqa wahda maandichi double 3amrili li kfak o hta nzid njiblk mara yakhra wrqa akhra dik wr9a kay3tiwhalna f societe makatba3chi ana jbartini msafra f3chya andouz n ksar ondouz nakhod wrqa", "created_at": "2026-03-27T15:40:05.316797", "media_url": null, "media_mime_type": null}, {"id": 7599, "message_id": "bot_3A86434595EEFAFBF554_2579", "sender": "bot", "message_type": "text", "content": "سمح ليا، أنا غير assistant ديال الاستقبال وماعنديش دراية بهاد الموضوع. واش تبغي نبلغ دكتور Ayoub باش يتاصل بيك مباشرة؟", "created_at": "2026-03-27T15:40:26.154364", "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 282 in training_review_items