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": 10350, "message_id": "A52B7DE8568304097F5F253B8A922902", "sender": "bot", "message_type": "text", "content": "7ta nrod elik ghada", "created_at": "2026-04-01T18:41:46.442752", "media_url": null, "media_mime_type": null}, {"id": 10351, "message_id": "A54D1C7C15A9E3D2AE17932A6A94D879", "sender": "bot", "message_type": "text", "content": "3la 7sab rdv", "created_at": "2026-04-01T18:41:49.201829", "media_url": null, "media_mime_type": null}, {"id": 10359, "message_id": "ACA88D7124FCE1B23C21D38B2622811B", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-04-01T19:11:38.469705", "media_url": null, "media_mime_type": null}, {"id": 10360, "message_id": "AC5806C0E5E434B165A47CB97A4A9C65", "sender": "user", "message_type": "text", "content": "Hta ila kan bkri mzn", "created_at": "2026-04-01T19:11:50.537097", "media_url": null, "media_mime_type": null}, {"id": 10361, "message_id": "AC6938C26DF8021DD427A317599030B5", "sender": "user", "message_type": "text", "content": "11 wla 10", "created_at": "2026-04-01T19:11:56.187151", "media_url": null, "media_mime_type": null}, {"id": 10437, "message_id": "A5D4C90737A712DD86B2D8A10AAF3804", "sender": "bot", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio:\n\n**Arabic Script:**\n\"لا نهار السبت عندي عامر، شوف شي وقت آخر من غير السبت وصافي.\"\n\n**Latin Script (Darija):**\n\"La nhar es-sabt 'andi 'amer. Shouf shi waqt akhor men ghir es-sabt o safi.\"", "created_at": "2026-04-02T08:16:55.376228", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2504/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 10465, "message_id": "ACE775547E93512009CB5F6D5FC56310", "sender": "user", "message_type": "text", "content": "Khti ana khadam", "created_at": "2026-04-02T08:38:45.747189", "media_url": null, "media_mime_type": null}, {"id": 10466, "message_id": "ACBF115A0A9DDAE4F6711578EBBF3583", "sender": "user", "message_type": "text", "content": "Sf nxof xi had akhor", "created_at": "2026-04-02T08:38:55.085297", "media_url": null, "media_mime_type": null}, {"id": 10467, "message_id": "AC2AB0B148C6181870B3D345223C14F3", "sender": "user", "message_type": "text", "content": "Chokran", "created_at": "2026-04-02T08:39:01.520037", "media_url": null, "media_mime_type": null}, {"id": 10468, "message_id": "bot_AC2AB0B148C6181870B3D345223C14F3_6936", "sender": "bot", "message_type": "text", "content": "Merci pour votre retour et votre compréhension. Si vous souhaitez proposer un autre jour ou une plage horaire qui vous arrange, n’hésitez pas à me le dire et je le transmettrai à l’équipe pour organiser un nouveau rendez-vous إن شاء الله. \n\nBonne journée à vous !", "created_at": "2026-04-02T08:40:18.326760", "media_url": null, "media_mime_type": null}, {"id": 10469, "message_id": "AC602BF257355340DB6C1214FE6205B4", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-04-02T08:41:16.307253", "media_url": null, "media_mime_type": null}, {"id": 10470, "message_id": "bot_AC602BF257355340DB6C1214FE6205B4_7862", "sender": "bot", "message_type": "text", "content": "العفو مرحبا بيكوم 🙏🏻", "created_at": "2026-04-02T08:41:30.469778", "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 583 in training_review_items