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": 10493, "message_id": "3EB02463ABE80F1222CE9E", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL FARZAZI  Samar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 03 avril 2026* à *11: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*EL FARZAZI *\r\nلديكم موعد مع ** يوم *الجمعة 3 أبريل 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-02T09:29:04.300223", "media_url": null, "media_mime_type": null}, {"id": 10520, "message_id": "3ABCBD5E45BD70A7F7BD", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio:\n\n\"Bonjour, إن شاء الله غتلقايني تما غدا إن شاء الله بإذن الله، شكرا بزاف.\"\n\n**Transliteration (Latin script):**\n\"Bonjour, insha'Allah ghat-lqayni tema ghada. Insha'Allah bi'idni-Allah, shokran bzaf.\"\n\n**Translation (for context):**\n\"Good morning, God willing you will find me there tomorrow. God willing, by the will of God. Thank you very much.\"", "created_at": "2026-04-02T09:51:18.579299", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2534/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10521, "message_id": "bot_3ABCBD5E45BD70A7F7BD_7373", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre confirmation Samar 😊\n\nNous vous attendrons demain, vendredi 3 avril à 11:00 إن شاء الله. Si jamais vous avez un empêchement, n'hésitez pas à contacter la réception au 060022263.\n\nÀ très bientôt au Centre Dentaire Tanger Bay !", "created_at": "2026-04-02T09:51:38.548651", "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 597 in training_review_items