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": 44923, "message_id": "AC9A16C253814E94DE27A7BA6414AB43", "sender": "user", "message_type": "text", "content": "Je confirme", "created_at": "2026-06-17T15:21:30.620388", "media_url": null, "media_mime_type": null}, {"id": 44924, "message_id": "AC4C07D531484190255AF7C6915A77F1", "sender": "user", "message_type": "text", "content": "Ana wselt", "created_at": "2026-06-17T15:21:45.214306", "media_url": null, "media_mime_type": null}, {"id": 45166, "message_id": "3EB0478AE7E23BF0F6CF58", "sender": "bot", "message_type": "text", "content": "Bonjour FATIMA Bounadem", "created_at": "2026-06-18T11:37:19.184418", "media_url": null, "media_mime_type": null}, {"id": 45167, "message_id": "A5E21C254B8E59348A474616B065E892", "sender": "bot", "message_type": "text", "content": "Titulaire : HAITHAM BOUTAIB\nRIB : 230 825 2602742211029400 66\nIBAN : MA64 2308 2526 0274 2211 0294 0066 \nCode SWIFT : CIHMMAMC", "created_at": "2026-06-18T11:37:23.610491", "media_url": null, "media_mime_type": null}, {"id": 48127, "message_id": "AC1BF1FB464C958C33D6F310EFBDB239", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-06-24T17:30:51.298647", "media_url": null, "media_mime_type": null}, {"id": 48128, "message_id": "AC709D8B68023FD7472943153E1BEDF7", "sender": "user", "message_type": "text", "content": "Stp je veux un rdv pour vendredi ila momkin", "created_at": "2026-06-24T17:31:17.697902", "media_url": null, "media_mime_type": null}, {"id": 48129, "message_id": "bot_AC709D8B68023FD7472943153E1BEDF7_6251", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Avec plaisir ! Pouvez-vous me donner votre nom complet et le type de soin souhaité pour vendredi ?", "created_at": "2026-06-24T17:31:39.479026", "media_url": null, "media_mime_type": null}, {"id": 48130, "message_id": "AC85492241613FA8B6ECC021A2EB53CF", "sender": "user", "message_type": "text", "content": "Ali Jlok", "created_at": "2026-06-24T17:32:27.189872", "media_url": null, "media_mime_type": null}, {"id": 48131, "message_id": "bot_AC85492241613FA8B6ECC021A2EB53CF_9105", "sender": "bot", "message_type": "text", "content": "Merci Ali ! Pour bien préparer votre rendez-vous vendredi, pouvez-vous me préciser le type de soin ou la raison de votre visite ?", "created_at": "2026-06-24T17:32:39.314528", "media_url": null, "media_mime_type": null}, {"id": 48132, "message_id": "AC296C87E317D51F03C461E9CFA5A07F", "sender": "user", "message_type": "text", "content": "J'ai déjà commencé avec vous, j'ai une dent que vous avez déjà soignée, mais la douleur est revenue. Merci.", "created_at": "2026-06-24T17:35:28.059205", "media_url": null, "media_mime_type": null}, {"id": 48136, "message_id": "bot_AC296C87E317D51F03C461E9CFA5A07F_6168", "sender": "bot", "message_type": "text", "content": "Je comprends Ali, mais je ne suis qu'un assistant virtuel et je n'ai accès qu'à cette conversation.", "created_at": "2026-06-24T17:35:42.604280", "media_url": null, "media_mime_type": null}, {"id": 48137, "message_id": "bot_AC296C87E317D51F03C461E9CFA5A07F_6138", "sender": "bot", "message_type": "text", "content": "Votre demande a été transmise à l'équipe, ils vont vous recontacter très bientôt إن شاء الله 🙏🏻\nNote : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-24T17:35:42.665620", "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 3989 in training_review_items