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": 15387, "message_id": "owner_media_7b77fb64618e47c188e34681381fbf9e", "sender": "bot", "message_type": "image", "content": null, "created_at": "2026-04-14T10:26:34.640939", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3988/download", "media_mime_type": "image/png"}, {"id": 15396, "message_id": "owner_media_df8d9d0a83f244afbeee13f5875917e6", "sender": "bot", "message_type": "voice", "content": null, "created_at": "2026-04-14T10:32:12.666804", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3990/download", "media_mime_type": "video/webm"}, {"id": 15398, "message_id": "owner_media_c12e23b85c464c159f1eceaadb5c1c0f", "sender": "bot", "message_type": "image", "content": null, "created_at": "2026-04-14T10:34:46.926900", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3991/download", "media_mime_type": "image/png"}, {"id": 15411, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQyOTYxNzAxMjYzMjM0ODA3MDI4MDc0NDE0MDgwMAZDZD_audio", "sender": "user", "message_type": "voice", "content": "[Voice message received but could not be transcribed. Ask the user to resend as text.]", "created_at": "2026-04-14T10:41:30.920635", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/4001/download", "media_mime_type": "audio/mp4"}, {"id": 15412, "message_id": "bot_ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQyOTYxNzAxMjYzMjM0ODA3MDI4MDc0NDE0MDgwMAZDZD_audio_2621", "sender": "bot", "message_type": "text", "content": "Je suis désolé, mais je n'ai pas pu comprendre le message vocal. Pourriez-vous s'il vous plaît le renvoyer sous forme de texte ? Cela m'aidera à mieux vous assister. Merci !", "created_at": "2026-04-14T10:41:43.501917", "media_url": null, "media_mime_type": null}, {"id": 15428, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQ0MjEzNjc3ODkzMDk5MTQ5MTUwOTA3ODk4MjY1NgZDZD", "sender": "user", "message_type": "text", "content": "[Attachment: image]", "created_at": "2026-04-14T10:52:49.092222", "media_url": null, "media_mime_type": null}, {"id": 15429, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQ0MjEzNjc3ODkzMDk5MTQ5MTUwOTA3ODk4MjY1NgZDZD_image", "sender": "user", "message_type": "image", "content": "Image description: - A man is gesturing emotionally in a workshop setting with tools in the background.\n- Visible text: \"كيكون معقد! Logicat Launch Sponsorisé Réserver\"\n- Notable objects/entities: Tools hanging on the wall, workshop setting.\n\nUser message context: [Attachment: image]", "created_at": "2026-04-14T10:52:49.665182", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/4004/download", "media_mime_type": "image/jpeg"}, {"id": 15430, "message_id": "bot_ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQ0MjEzNjc3ODkzMDk5MTQ5MTUwOTA3ODk4MjY1NgZDZD_image_7953", "sender": "bot", "message_type": "text", "content": "Merci pour l'image ! Si vous avez des questions ou besoin d'informations spécifiques, n'hésitez pas à les écrire ici en texte. Je suis là pour vous aider !", "created_at": "2026-04-14T10:53:03.957297", "media_url": null, "media_mime_type": null}, {"id": 15431, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQ0MjgyNjk5Nzk1MDA5MjM4MjU5ODA0MzAwOTAyNAZDZD", "sender": "user", "message_type": "text", "content": "slm", "created_at": "2026-04-14T10:53:26.237357", "media_url": null, "media_mime_type": null}, {"id": 15432, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQ0MjgzODY3MzcyNDUyMDExNjY5MDE5MDU5ODE0NAZDZD", "sender": "user", "message_type": "text", "content": "cv", "created_at": "2026-04-14T10:53:27.674354", "media_url": null, "media_mime_type": null}, {"id": 15433, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQ0Mjg5MTIyMjU0MDA4Nzc3OTM5NDU1OTQxMDE3NgZDZD", "sender": "user", "message_type": "text", "content": "khti?", "created_at": "2026-04-14T10:53:29.883099", "media_url": null, "media_mime_type": null}, {"id": 15434, "message_id": "bot_ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQ0Mjg5MTIyMjU0MDA4Nzc3OTM5NDU1OTQxMDE3NgZDZD_5854", "sender": "bot", "message_type": "text", "content": "Wa alaykoum salam ! Je vais bien, merci. Comment puis-je vous aider aujourd'hui ?", "created_at": "2026-04-14T10:53:39.995232", "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 1125 in training_review_items