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": "Ye i newd appointment when i can?"}, {"type": "user", "content": "Im in tanger!"}, {"type": "user", "content": "I need"}, {"type": "user", "content": "Sorry"}, {"type": "bot", "content": "No problem at all! \ud83d\ude0a Can you please tell me your full name, the type of dental care you need, and your preferred day or time for the appointment? This will help us organize your visit quickly."}, {"type": "user", "content": "I had an appointment scheduled with you a while ago but I couldn't come... now I'm here until next week. I need something temporary: a cleaning and an x-ray, and I'd like to know if you can temporarily place a 7-piece bridge I have."}, {"type": "bot", "content": "Thank you for explaining your situation."}, {"type": "bot", "content": "I am just a virtual assistant and do not have access to your previous appointments or clinical details."}, {"type": "bot", "content": "If you\u2019d like, I can forward your message to the team so they can help you directly."}, {"type": "bot", "content": "Could you please send me your full name?"}, {"type": "bot", "content": "This will help them find your file and contact you as soon as possible."}, {"type": "user", "content": "Pedro nicolas camacho umpierrez"}]

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 524 in notifications