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": 42358, "message_id": "bot_ACA21634A0403BCA8D267E30F23B1C9A_7680", "sender": "bot", "message_type": "text", "content": "Merci pour votre réponse ! Pour finaliser la demande, pouvez-vous me donner votre nom complet ainsi que le créneau qui vous conviendrait le mieux pour la consultation ?", "created_at": "2026-06-11T22:26:05.129232", "media_url": null, "media_mime_type": null}, {"id": 42359, "message_id": "AC277E94B65BE56C6B83D0F0D45EDC2D", "sender": "user", "message_type": "text", "content": "Aidouni Farah \nSamedi ? 14h", "created_at": "2026-06-11T22:28:02.799814", "media_url": null, "media_mime_type": null}, {"id": 42363, "message_id": "bot_AC277E94B65BE56C6B83D0F0D45EDC2D_8447", "sender": "bot", "message_type": "text", "content": "Merci Farah, c’est noté !", "created_at": "2026-06-11T22:28:16.195429", "media_url": null, "media_mime_type": null}, {"id": 42364, "message_id": "bot_AC277E94B65BE56C6B83D0F0D45EDC2D_4858", "sender": "bot", "message_type": "text", "content": "Votre demande pour une consultation esthétique avec Dr Haitham Boutaib samedi à 14h a bien été transmise à l’équipe.", "created_at": "2026-06-11T22:28:16.265042", "media_url": null, "media_mime_type": null}, {"id": 42365, "message_id": "bot_AC277E94B65BE56C6B83D0F0D45EDC2D_1072", "sender": "bot", "message_type": "text", "content": "Ils vont vérifier la disponibilité et vous recontacter rapidement.", "created_at": "2026-06-11T22:28:16.327372", "media_url": null, "media_mime_type": null}, {"id": 42366, "message_id": "bot_AC277E94B65BE56C6B83D0F0D45EDC2D_6962", "sender": "bot", "message_type": "text", "content": "Note : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-06-11T22:28:16.393483", "media_url": null, "media_mime_type": null}, {"id": 42380, "message_id": "ACDE87E917888A01B0A1EC9C9D9ED7D0", "sender": "user", "message_type": "text", "content": "Ca marche merci", "created_at": "2026-06-11T22:57:49.961242", "media_url": null, "media_mime_type": null}, {"id": 42381, "message_id": "AC9317ED0B931E2E4CA4BC9D6F58C685", "sender": "user", "message_type": "text", "content": "Bonne soirée", "created_at": "2026-06-11T22:57:53.658945", "media_url": null, "media_mime_type": null}, {"id": 43058, "message_id": "ACAFA83EE6B00A4C7B39296468C1C3FA", "sender": "user", "message_type": "text", "content": "Waleykoum Salam \nVous faites quoi ?", "created_at": "2026-06-14T06:03:56.183867", "media_url": null, "media_mime_type": null}, {"id": 43059, "message_id": "bot_ACAFA83EE6B00A4C7B39296468C1C3FA_4594", "sender": "bot", "message_type": "text", "content": "Bonsoir 😊 Nous sommes le Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib.", "created_at": "2026-06-14T06:04:11.190760", "media_url": null, "media_mime_type": null}, {"id": 43060, "message_id": "bot_ACAFA83EE6B00A4C7B39296468C1C3FA_1433", "sender": "bot", "message_type": "text", "content": "Nous proposons des soins dentaires, chirurgie et orthodontie.", "created_at": "2026-06-14T06:04:11.262795", "media_url": null, "media_mime_type": null}, {"id": 43061, "message_id": "bot_ACAFA83EE6B00A4C7B39296468C1C3FA_4556", "sender": "bot", "message_type": "text", "content": "Vous souhaitez des informations sur un service en particulier ?", "created_at": "2026-06-14T06:04:11.327961", "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 3537 in training_review_items