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": 10756, "message_id": "6A20212DEAC3DF5D7131", "sender": "bot", "message_type": "text", "content": "Merci d’avoir contacté DR WALID HALIM ! Dites-nous en quoi nous pouvons vous aider ?", "created_at": "2026-04-02T13:29:49.944714", "media_url": null, "media_mime_type": null}, {"id": 10757, "message_id": "AC1DB734DDDBF5E93BADBA32BF714005", "sender": "user", "message_type": "text", "content": "Bonjour je veux savoir le prix", "created_at": "2026-04-02T13:30:00.613358", "media_url": null, "media_mime_type": null}, {"id": 10758, "message_id": "AC09D865A8AF4D4387C9197B116E228C", "sender": "user", "message_type": "text", "content": "Des couronnes", "created_at": "2026-04-02T13:30:09.299414", "media_url": null, "media_mime_type": null}, {"id": 10759, "message_id": "AC2CCB6E862FD123FD1E366733790A44", "sender": "user", "message_type": "text", "content": "20 dents", "created_at": "2026-04-02T13:30:19.162883", "media_url": null, "media_mime_type": null}, {"id": 10760, "message_id": "bot_AC2CCB6E862FD123FD1E366733790A44_1442", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Pour obtenir des informations précises sur les prix des couronnes pour 20 dents, je vais vérifier cela pour vous. \n\nPourriez-vous me donner votre nom complet afin que je puisse vous aider au mieux ?", "created_at": "2026-04-02T13:30:34.428537", "media_url": null, "media_mime_type": null}, {"id": 10761, "message_id": "AC7BFEA74B5308EA0756FBE370923B65", "sender": "user", "message_type": "text", "content": "Boudsi hamza", "created_at": "2026-04-02T13:31:01.394207", "media_url": null, "media_mime_type": null}, {"id": 10764, "message_id": "bot_AC7BFEA74B5308EA0756FBE370923B65_5147", "sender": "bot", "message_type": "text", "content": "Merci, Hamza. J'ai transmis votre demande à notre équipe, et ils vous contacteront bientôt pour vous fournir tous les détails nécessaires concernant les couronnes pour 20 dents. 😊", "created_at": "2026-04-02T13:31:16.765096", "media_url": null, "media_mime_type": null}, {"id": 10765, "message_id": "AC889002E960A537E9FCEF3239B5F443", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-04-02T13:31:51.010099", "media_url": null, "media_mime_type": null}, {"id": 10766, "message_id": "bot_AC889002E960A537E9FCEF3239B5F443_1584", "sender": "bot", "message_type": "text", "content": "Avec plaisir, Hamza ! Si vous avez d'autres questions, n'hésitez pas à me le faire savoir. 😊", "created_at": "2026-04-02T13:32:02.884982", "media_url": null, "media_mime_type": null}, {"id": 10767, "message_id": "AC4C2727419D0B595E08B9A73A9EB8FA", "sender": "user", "message_type": "text", "content": "Vous faites les facettes", "created_at": "2026-04-02T13:32:38.911908", "media_url": null, "media_mime_type": null}, {"id": 10768, "message_id": "ACA39916EEADACA4B35844FAEC384466", "sender": "user", "message_type": "text", "content": "?", "created_at": "2026-04-02T13:32:40.440900", "media_url": null, "media_mime_type": null}, {"id": 10769, "message_id": "bot_ACA39916EEADACA4B35844FAEC384466_6714", "sender": "bot", "message_type": "text", "content": "Oui, nous proposons des services d'esthétique dentaire, ce qui peut inclure les facettes. Le Dr Halim Walid, Chirurgien Dentiste, dirige notre cabinet. Si vous souhaitez plus d'informations ou prendre rendez-vous, n'hésitez pas à me le faire savoir ! 😊", "created_at": "2026-04-02T13:33:01.969554", "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 638 in training_review_items