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": "bot", "content": "Global Attach\u00e9 offers a wide range of translation services for various documents, including birth certificates, marriage contracts, asylum documents, diplomas, legal contracts, academic transcripts, and passports. We provide both certified and non-certified translations in over 200 languages, available 24/7.\n\nHere are some examples of our pricing:\n- Birth Certificates: Starting from $45 per page\n- Marriage Contracts: Starting from $55 per page\n- School Transcripts: Starting from $65 per page\n\nWe also offer additional services such as editing, proofreading, transcription, and subtitling. Notarization is available for an additional $15 per signature. Typically, we provide quotes within 1-2 hours and deliver translations within 24-48 hours for audio transcription.\n\nIf you have any specific needs or questions, feel free to ask!"}, {"type": "user", "content": "I want my order status"}, {"type": "user", "content": "I want my order status"}, {"type": "user", "content": "I want my order status"}, {"type": "bot", "content": "To check your order status, could you please provide your order number? It should look something like DBO453230. Once I have that, I'll be able to look up the status for you."}, {"type": "user", "content": "my email is aminesaada18@gmail.com"}, {"type": "bot", "content": "I found a few quotes associated with your email:\n\n1. **Quote DBO69839efd76810**: This quote has expired. Please contact support to request a refreshed quote.\n2. **Quote DBO6976bcc9e8f15**: The quote has been submitted, and our team will review and provide pricing shortly.\n3. **Quote DBO6976aa317d136**: This quote has also expired. Please contact support to request a refreshed quote.\n\nIf you need further assistance or have any questions, feel free to ask!"}, {"type": "user", "content": "how to contact support"}, {"type": "bot", "content": "You can contact Global Attach\u00e9 support by visiting our website and using the contact form, or by emailing us directly at support@globalattache.com. Our team is available 24/7 to assist you with any inquiries or issues you may have."}, {"type": "user", "content": "can you notify them"}, {"type": "bot", "content": "Could you please provide me with your full name so I can notify our team to assist you with your expired quotes?"}, {"type": "user", "content": "Jesica"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 187 in notifications