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": 10126, "message_id": "A566EE3B8AB12A0D626AC5DEBE6941FA", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-04-01T15:07:01.230864", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2400/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10129, "message_id": "A5BF273F833A6619AE65E86FCE6B3C43", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-01T15:11:03.615437", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2401/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10132, "message_id": "A593EBF982F212185FAB6E3B34D48EDB", "sender": "user", "message_type": "text", "content": "Safi d'accord inch'Allah akhti LAH yshal 3lik", "created_at": "2026-04-01T15:15:34.848761", "media_url": null, "media_mime_type": null}, {"id": 10137, "message_id": "A591DC93CEE9880DA840446009055BDE", "sender": "bot", "message_type": "text", "content": "Amine marhba bik", "created_at": "2026-04-01T15:23:12.145991", "media_url": null, "media_mime_type": null}, {"id": 12673, "message_id": "A5061961CD997AC3EB0AD100E72E196E", "sender": "user", "message_type": "text", "content": "Bnisba L samedi sbah", "created_at": "2026-04-08T16:22:27.693084", "media_url": null, "media_mime_type": null}, {"id": 12674, "message_id": "A5E19F448B49EFBF3772A92B9FF61A24", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-08T16:23:20.104013", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3230/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 12680, "message_id": "A5E18F5F67A66F8EE00B405FD1454F49", "sender": "user", "message_type": "text", "content": "Ops! No Safi khliha lsemaine Jaya inchaellah ola Ila l9iti chi sa3a fvendredi khawya o3lmini inchallah", "created_at": "2026-04-08T16:25:17.408105", "media_url": null, "media_mime_type": null}, {"id": 12681, "message_id": "A5F4F910F54BE04B3822BFEF999F594A", "sender": "user", "message_type": "text", "content": "LAH yshal élik akhti", "created_at": "2026-04-08T16:25:27.731028", "media_url": null, "media_mime_type": null}, {"id": 12694, "message_id": "A575F7E73B13F5C27CCAE3BCB60F1C90", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-04-08T16:37:35.243260", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3237/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 12703, "message_id": "A504B5EC6B2F66AF932673E65EE196BE", "sender": "user", "message_type": "text", "content": "Ghda endi khdma ana dispo nhar jm3a osbt inch'Allah", "created_at": "2026-04-08T16:49:30.651670", "media_url": null, "media_mime_type": null}, {"id": 16719, "message_id": "A5C51B37C31AC6F1C3B55F2445EC4749", "sender": "user", "message_type": "text", "content": "Salam alaikum khti ça va svp t9dri takhdi li rendez vous nhar tnin Inchaellah", "created_at": "2026-04-16T12:08:43.077794", "media_url": null, "media_mime_type": null}, {"id": 16720, "message_id": "bot_A5C51B37C31AC6F1C3B55F2445EC4749_539", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله 😊 مرحبا بيك! باش نكملو الحجز، ممكن تكتبي ليا الإسم الكامل ديالك وشنو العلاج اللي محتاجاه إن شاء الله؟", "created_at": "2026-04-16T12:08:56.617220", "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 1258 in training_review_items