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": 8748, "message_id": "3EB0690E9C97C6A9558C60", "sender": "bot", "message_type": "document", "content": "_radios_el cadi Hamza_20260330_12025139.pdf", "created_at": "2026-03-30T11:03:31.309282", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1925/download", "media_mime_type": "application/pdf"}, {"id": 8789, "message_id": "ACB680D3C19862FCAF19C5CD7A558F7E", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"إييه حمزة، دزنا من جيهت برج خليج 3، وراني غادي نجي عندكم، ما كرهتش تصيفط ليا لوكاليزاسيون باش نجي عندكم.\"\n\n**Latin Script (Transcription):**\n\"Iyeh Hamza, dozna mn jiht Borj Khalij 3, wa rani ghadi nji andkom, ma krahtch tsifet liya localisation bach nji andkom.\"\n\n**English Translation (for context):**\n\"Yes Hamza, we passed by Burj Khalij 3, and I'm coming to you. I'd appreciate it if you could send me the location so I can come to you.\"", "created_at": "2026-03-30T11:22:55.201714", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1936/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8794, "message_id": "bot_ACB680D3C19862FCAF19C5CD7A558F7E_4351", "sender": "bot", "message_type": "text", "content": "Centre Dentaire Tanger Bay كاين ف Avenue Mohammed VI، Résidence Borj Khalij Tanger 3، étage 5، appartement numéro 197، Tanger  \nhttps://maps.app.goo.gl/RCzcJXSXvgMzrRMFA\n\nمرحبا بيكوم، وأي سؤال آخر أنا رهن الإشارة!", "created_at": "2026-03-30T11:24:14.237638", "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 458 in training_review_items