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": 7018, "message_id": "3AE757F891D777BCF328", "sender": "user", "message_type": "text", "content": "Tu a une date pour la couronne", "created_at": "2026-03-26T14:57:04.745667", "media_url": null, "media_mime_type": null}, {"id": 7019, "message_id": "3AB52F5B2E106DC64F30", "sender": "user", "message_type": "text", "content": "Il devait apeler labo", "created_at": "2026-03-26T15:04:26.108360", "media_url": null, "media_mime_type": null}, {"id": 7740, "message_id": "3EB041F0D003999A1F0D53", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *4400,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-2600,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-03-27T19:42:12.630862", "media_url": null, "media_mime_type": null}, {"id": 7742, "message_id": "3EB0ABCD0E97ED13F076C7", "sender": "bot", "message_type": "document", "content": "2026032720413949.pdf", "created_at": "2026-03-27T19:42:25.344294", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1617/download", "media_mime_type": "application/pdf"}, {"id": 7743, "message_id": "3EB01CD48B3BFBC6936078", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *2600,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-03-27T19:42:37.469527", "media_url": null, "media_mime_type": null}, {"id": 7744, "message_id": "3EB00FE50DB4653D1377EE", "sender": "bot", "message_type": "document", "content": "2026032720420106.pdf", "created_at": "2026-03-27T19:42:50.280469", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1618/download", "media_mime_type": "application/pdf"}, {"id": 7752, "message_id": "3A58AA677F1974B4BD03", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-03-27T19:50:30.941809", "media_url": null, "media_mime_type": null}, {"id": 7753, "message_id": "bot_3A58AA677F1974B4BD03_8578", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-03-27T19:50:41.981888", "media_url": null, "media_mime_type": null}, {"id": 7754, "message_id": "3A6A2289CB2D9CF55902", "sender": "user", "message_type": "text", "content": "C quoi ton prenon", "created_at": "2026-03-27T19:50:57.303028", "media_url": null, "media_mime_type": null}, {"id": 7755, "message_id": "bot_3A6A2289CB2D9CF55902_672", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 أنا assistant ديال Centre Dentaire Tanger Bay. واش نقدر نعاونك بخصوص موعد، خدمة، ولا العنوان؟", "created_at": "2026-03-27T19:51:10.346018", "media_url": null, "media_mime_type": null}, {"id": 7756, "message_id": "3AA82F457E20C73D6156", "sender": "user", "message_type": "text", "content": "ماتعاونوني مانعاونكم تعلمو هي تكتبو بلغة سليمة باش يفهموكم الجميع", "created_at": "2026-03-27T20:40:19.897781", "media_url": null, "media_mime_type": null}, {"id": 7757, "message_id": "bot_3AA82F457E20C73D6156_6924", "sender": "bot", "message_type": "text", "content": "كنعتدر إذا كان شي حاجة ما كانتش واضحة. واش نقدر نعاونك فشي حاجة معينة؟", "created_at": "2026-03-27T20:40:34.315581", "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 330 in training_review_items