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": "Hello. Welcome to Harbor & Crown Real Estate. How can we assist you today?"}, {"type": "user", "content": "What you guys do"}, {"type": "bot", "content": "Harbor & Crown Real Estate is a luxury real estate advisory firm in Dubai. We offer services such as strategic market research, property consultation, legal coordination, property management, and after-sales support. Our focus is on luxury residential and commercial properties, and we ensure legal compliance through our partnership with RAALC Law Firm.\n\nAre you interested in any specific service or property type?"}, {"type": "user", "content": "I would like. A appointmenet to talk more in details"}, {"type": "bot", "content": "Of course, we can arrange a Zoom call for you to discuss your interests in more detail. Could I have your full name to proceed with the booking?"}, {"type": "user", "content": "Yes my name is amine"}, {"type": "bot", "content": "Thank you, Amine. We have several available slots for a 30-minute Zoom call tomorrow, May 5th. Here are some options:\n\n09:00, 09:30, 10:00, 10:30, 11:00, 11:30, 12:00, 12:30, 13:00, 13:30, 14:00, 14:30, 15:00, 15:30, 16:00, 16:30, 17:00, 17:30, 18:00, 18:30.\n\nPlease let me know which time works best for you, and I'll confirm the appointment."}, {"type": "user", "content": "Emm 16 works for me"}, {"type": "bot", "content": "Your appointment is confirmed for tomorrow, May 5th at 16:00 (BST) for a 30-minute discussion on luxury real estate services. \n\nIf you have any questions or need to reschedule, feel free to reach out. Looking forward to our conversation!"}, {"type": "user", "content": "I want to talk to a human"}, {"type": "bot", "content": "Could you please provide your email address so I can connect you with our advisory team?"}, {"type": "user", "content": "Cto@forteunoweb.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 345 in notifications