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": 43387, "message_id": "bot_AC4281AA68C2F672EBDF822284817B43_2057", "sender": "bot", "message_type": "text", "content": "Here is the location on Google Maps:\nhttps://maps.app.goo.gl/RCzcJXSXvgMzrRMFA\n\nIf you need anything else, just let me know!", "created_at": "2026-06-15T07:20:56.070361", "media_url": null, "media_mime_type": null}, {"id": 43388, "message_id": "AC2545147CB5CE2A69653E30224874D6", "sender": "user", "message_type": "text", "content": "To see schedules of the port algeciras to see when I can travel", "created_at": "2026-06-15T07:21:08.299228", "media_url": null, "media_mime_type": null}, {"id": 43389, "message_id": "bot_AC2545147CB5CE2A69653E30224874D6_1652", "sender": "bot", "message_type": "text", "content": "I understand!", "created_at": "2026-06-15T07:21:21.526760", "media_url": null, "media_mime_type": null}, {"id": 43390, "message_id": "bot_AC2545147CB5CE2A69653E30224874D6_494", "sender": "bot", "message_type": "text", "content": "For ferry schedules from Algeciras to Tangier, you can check the official websites of ferry companies like FRS or Balearia, or use comparison sites such as Direct Ferries.", "created_at": "2026-06-15T07:21:21.588666", "media_url": null, "media_mime_type": null}, {"id": 43391, "message_id": "bot_AC2545147CB5CE2A69653E30224874D6_4255", "sender": "bot", "message_type": "text", "content": "They provide up-to-date departure times and ticket information.", "created_at": "2026-06-15T07:21:21.656915", "media_url": null, "media_mime_type": null}, {"id": 43392, "message_id": "bot_AC2545147CB5CE2A69653E30224874D6_1546", "sender": "bot", "message_type": "text", "content": "If you need help with anything related to your dental visit, feel free to ask!", "created_at": "2026-06-15T07:21:21.726101", "media_url": null, "media_mime_type": null}, {"id": 43393, "message_id": "bot_AC2545147CB5CE2A69653E30224874D6_289", "sender": "bot", "message_type": "text", "content": "Safe travels 😊", "created_at": "2026-06-15T07:21:21.799572", "media_url": null, "media_mime_type": null}, {"id": 43394, "message_id": "AC0B2BB3505C7076B02D43FFD148FC1F", "sender": "user", "message_type": "text", "content": "Ok I have to see cause I also have kids so we need to check well also with our holidays", "created_at": "2026-06-15T07:22:21.763774", "media_url": null, "media_mime_type": null}, {"id": 43395, "message_id": "bot_AC0B2BB3505C7076B02D43FFD148FC1F_7272", "sender": "bot", "message_type": "text", "content": "Absolutely, that makes perfect sense!", "created_at": "2026-06-15T07:22:33.978984", "media_url": null, "media_mime_type": null}, {"id": 43396, "message_id": "bot_AC0B2BB3505C7076B02D43FFD148FC1F_1382", "sender": "bot", "message_type": "text", "content": "Take your time to plan everything comfortably with your family and holidays.", "created_at": "2026-06-15T07:22:34.042645", "media_url": null, "media_mime_type": null}, {"id": 43397, "message_id": "bot_AC0B2BB3505C7076B02D43FFD148FC1F_621", "sender": "bot", "message_type": "text", "content": "If you have any questions or need to book your consultation when you’re ready, just let me know.", "created_at": "2026-06-15T07:22:34.106064", "media_url": null, "media_mime_type": null}, {"id": 43398, "message_id": "bot_AC0B2BB3505C7076B02D43FFD148FC1F_9376", "sender": "bot", "message_type": "text", "content": "I’m here to help whenever you need!", "created_at": "2026-06-15T07:22:34.161776", "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 3590 in training_review_items