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": 5445, "message_id": "3EB025BE625880A26E196D", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *100,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-500,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-03-16T17:31:56.841536", "media_url": null, "media_mime_type": null}, {"id": 5446, "message_id": "3EB0E47A9C2F84B6896341", "sender": "bot", "message_type": "document", "content": "2026031617313833.pdf", "created_at": "2026-03-16T17:32:09.498624", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/987/download", "media_mime_type": "application/pdf"}, {"id": 10627, "message_id": "ACC70F192AB5C7312D7486A54C5A8230", "sender": "user", "message_type": "text", "content": "Le reçu de payement svp", "created_at": "2026-04-02T11:17:36.464303", "media_url": null, "media_mime_type": null}, {"id": 10631, "message_id": "bot_ACC70F192AB5C7312D7486A54C5A8230_2259", "sender": "bot", "message_type": "text", "content": "Je comprends, mais je n'ai accès qu'à cette conversation. Votre demande a été transmise à l'équipe إن شاء الله 🙏🏻", "created_at": "2026-04-02T11:17:50.206859", "media_url": null, "media_mime_type": null}, {"id": 10632, "message_id": "A56E521CA9D28B3CED00A86350684CC0", "sender": "bot", "message_type": "text", "content": "<reply_to> </reply_to> ?", "created_at": "2026-04-02T11:18:03.669756", "media_url": null, "media_mime_type": null}, {"id": 10633, "message_id": "AC5623EAC367647E7BB33E6F9A6306AA", "sender": "user", "message_type": "text", "content": "Déjà compléter le reste", "created_at": "2026-04-02T11:18:09.978740", "media_url": null, "media_mime_type": null}, {"id": 10634, "message_id": "A5C438E743810C9BFBB8838A64B03EE8", "sender": "bot", "message_type": "text", "content": "Sf rak khalsti", "created_at": "2026-04-02T11:18:19.562680", "media_url": null, "media_mime_type": null}, {"id": 10635, "message_id": "bot_AC5623EAC367647E7BB33E6F9A6306AA_4198", "sender": "bot", "message_type": "text", "content": "Merci pour votre précision ! Votre demande a bien été transmise à l’équipe, ils vont vous recontacter très bientôt إن شاء الله 🙏🏻", "created_at": "2026-04-02T11:18:22.453527", "media_url": null, "media_mime_type": null}, {"id": 10636, "message_id": "A55342478EF88FAF1B426B4594E17D15", "sender": "bot", "message_type": "text", "content": "W3amrtlk la mutuelle", "created_at": "2026-04-02T11:18:26.913004", "media_url": null, "media_mime_type": null}, {"id": 10637, "message_id": "A5F6CCBA3B827D61F6688951262D3BBB", "sender": "bot", "message_type": "text", "content": "Maktsalna makansalok", "created_at": "2026-04-02T11:18:36.100303", "media_url": null, "media_mime_type": null}, {"id": 10638, "message_id": "AC5C2FC7B1BBBF724AF7B760C0EE524C", "sender": "user", "message_type": "text", "content": "D'accords", "created_at": "2026-04-02T11:18:44.974260", "media_url": null, "media_mime_type": null}, {"id": 10642, "message_id": "bot_AC5C2FC7B1BBBF724AF7B760C0EE524C_1663", "sender": "bot", "message_type": "text", "content": "Merci pour votre retour ! Si vous avez besoin d’autre chose ou une question supplémentaire, n’hésitez pas à me le dire. L’équipe reste à votre disposition إن شاء الله.", "created_at": "2026-04-02T11:18:57.308991", "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 618 in training_review_items