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": 12184, "message_id": "3A0B955C182581572022", "sender": "user", "message_type": "text", "content": "Could you find it with my email?", "created_at": "2026-04-05T02:04:15.294790", "media_url": null, "media_mime_type": null}, {"id": 12185, "message_id": "3A39545B3B066E910CC1", "sender": "user", "message_type": "text", "content": "I mean the status of my order", "created_at": "2026-04-05T02:04:21.235582", "media_url": null, "media_mime_type": null}, {"id": 12186, "message_id": "bot_3A39545B3B066E910CC1_7417", "sender": "bot", "message_type": "text", "content": "Sure, I can help with that. Could you please provide me with the email address you used for your order? This will help me look up the status for you.", "created_at": "2026-04-05T02:04:39.158209", "media_url": null, "media_mime_type": null}, {"id": 12187, "message_id": "3ADF5CF38506FCF39991", "sender": "user", "message_type": "text", "content": "nabil@atallalaw.com", "created_at": "2026-04-05T02:04:59.705855", "media_url": null, "media_mime_type": null}, {"id": 12188, "message_id": "bot_3ADF5CF38506FCF39991_1004", "sender": "bot", "message_type": "text", "content": "I found the status of your orders:\n\n1. **Quote Reference: DBO699e02fb3f86f**\n   - **Status:** Quote ready for payment\n   - **Amount Due:** $160 USD\n   - **Next Action:** Proceed to place and pay for your order.\n   - [Payment Link](https://globalattache.com/index.php?mc=Quote&c=SUMMARY_QUOTE&qid=3774&idc=DBO699e02fb3f86f&status=1)\n\n2. **Order Reference: DBO281546**\n   - **Status:** Payment pending\n   - **Amount Due:** $98 USD\n   - **Next Action:** Complete payment to start processing.\n   - [Payment Link](https://globalattache.com/index.php?mc=Quote&c=SUMMARY_QUOTE&qid=3766&idc=DBO698bb86ae7404&status=1)\n\n3. **Order Reference: DBO925838**\n   - **Status:** Payment pending\n   - **Amount Due:** $98 USD\n   - **Next Action:** Complete payment to start processing.\n   - [Payment Link](https://globalattache.com/index.php?mc=Quote&c=SUMMARY_QUOTE&qid=3766&idc=DBO698bb86ae7404&status=1)\n\nPlease let me know if you need any further assistance!", "created_at": "2026-04-05T02:05:14.396108", "media_url": null, "media_mime_type": null}, {"id": 12189, "message_id": "3EB04F5C30DCF972C431AB", "sender": "bot", "message_type": "text", "content": "**Quote Reference: DBO699e02fb3f86f**\n - **Status:** Quote ready for payment\n - **Amount Due:** $160 USD\n - **Next Action:** Proceed to place and pay for your order.", "created_at": "2026-04-05T02:05:16.519680", "media_url": null, "media_mime_type": null}, {"id": 12190, "message_id": "3EB089910208AB33B388A3", "sender": "bot", "message_type": "text", "content": "**Order Reference: DBO281546**\n - **Status:** Payment pending\n - **Amount Due:** $98 USD\n - **Next Action:** Complete payment to start processing.", "created_at": "2026-04-05T02:05:21.347320", "media_url": null, "media_mime_type": null}, {"id": 12191, "message_id": "3EB03548A40BB072410F90", "sender": "bot", "message_type": "text", "content": "**Order Reference: DBO925838**\n - **Status:** Payment pending\n - **Amount Due:** $98 USD\n - **Next Action:** Complete payment to start processing.", "created_at": "2026-04-05T02:05:25.362104", "media_url": null, "media_mime_type": null}, {"id": 19287, "message_id": "meta_104150672696890_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTIyMzg3MjFCMjJGRjE1MjAzQQA=", "sender": "user", "message_type": "text", "content": "Hi", "created_at": "2026-04-25T19:40:22.958687", "media_url": null, "media_mime_type": null}, {"id": 19288, "message_id": "bot_meta_104150672696890_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTIyMzg3MjFCMjJGRjE1MjAzQQA=_9393", "sender": "bot", "message_type": "text", "content": "Hello! Welcome to Global Attaché 😊 How can I help you today?", "created_at": "2026-04-25T19:40:35.405225", "media_url": null, "media_mime_type": null}, {"id": 19311, "message_id": "meta_104150672696890_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTZBNjRFREI0M0YzNTlERTQ5MAA=", "sender": "user", "message_type": "text", "content": "Hi", "created_at": "2026-04-25T20:37:43.008946", "media_url": null, "media_mime_type": null}, {"id": 19312, "message_id": "bot_meta_104150672696890_wamid.HBgLMzM3NjY2NDg5NDIVAgASGBQzQTZBNjRFREI0M0YzNTlERTQ5MAA=_9393", "sender": "bot", "message_type": "text", "content": "Hello! Welcome to Global Attaché 😊 How can I help you today?", "created_at": "2026-04-25T20:37:57.104627", "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 1453 in training_review_items