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 Global Attach\u00e9 \ud83d\ude0a How can I help you today?"}, {"type": "user", "content": "Hi"}, {"type": "bot", "content": "Hello! Welcome to Global Attach\u00e9 \ud83d\ude0a How can I help you today?"}, {"type": "user", "content": "Hi"}, {"type": "bot", "content": "Hello! Welcome to Global Attach\u00e9 \ud83d\ude0a How can I help you today?"}, {"type": "user", "content": "Can I know the status of my order"}, {"type": "bot", "content": "Could you please provide your order number? It should look something like DBO453230. This will help me find the status for you."}, {"type": "user", "content": "I want to talk to a human"}, {"type": "bot", "content": "Of course \u2014 could you give me your full name so I can connect you with the right person?"}, {"type": "user", "content": "Amine"}, {"type": "bot", "content": "Could you please provide your email address so I can pass your request to the right person?"}, {"type": "user", "content": "Aminesaada18@gmail.com"}]

TEXT NOT NULL

status

TEXT NOT NULL (default 'pending'

created_at

TEXT NOT NULL

resolved_at

TEXT

app.db — notifications

Update row 296 in notifications