SQLite Web: app.db

id

Primary key. INTEGER

chatbot_id

INTEGER NOT NULL

conversation_id

INTEGER NOT NULL

user_id

TEXT NOT NULL

reason

TEXT NOT NULL

user_name

TEXT

user_email

TEXT

user_phone

TEXT

conversation_messages

[{"type": "user", "content": "This is our pricelist."}, {"type": "bot", "content": "Thank you for sharing your pricelist."}, {"type": "bot", "content": "If you have any specific details or proposals you'd like us to consider, please feel free to share them."}, {"type": "bot", "content": "Our team will review the information and get back to you regarding any potential collaboration opportunities."}, {"type": "bot", "content": "If there's anything else you'd like to discuss, just let us know!"}, {"type": "user", "content": "Waiting for your kind confirmation."}, {"type": "bot", "content": "I've noted your request for confirmation regarding the collaboration."}, {"type": "bot", "content": "I'll notify our team about your proposal, and they will follow up with you shortly."}, {"type": "bot", "content": "Could you please provide your full name so I can pass this information to the right person?"}, {"type": "user", "content": "Ahmed Abdul-Jawad"}, {"type": "bot", "content": "Could you please provide your email address as well? This will help us ensure that our team can reach out to you with the confirmation and any further details regarding the collaboration. Thank you!"}, {"type": "user", "content": "info@wordwaytranslate.com"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

lead_source

TEXT

lead_source_id

TEXT

app.db — notifications

Update row 648 in notifications