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": "If you want to add a specific quick treatment for your tooth during this visit, could you please describe what you mean by \"get that tooth set\"?"}, {"type": "bot", "content": "This will help the team prepare for your care."}, {"type": "bot", "content": "If you need a separate appointment for another day, let me know your preferred time."}, {"type": "user", "content": "<reply_to>Your appointment for Saturday, May 23, 2026 at 14:30 with Dr.</reply_to> I hadn't come to that appointment"}, {"type": "bot", "content": "\u0634\u0643\u0631\u0627 \u0644\u0644\u062a\u0648\u0636\u064a\u062d Mourad. \u0648\u0627\u0634 \u0628\u063a\u064a\u062a \u062f\u0627\u0628\u0627 \u062a\u062d\u062c\u0632 \u0645\u0648\u0639\u062f \u062c\u062f\u064a\u062f \u0644\u0639\u0644\u0627\u062c \u0627\u0644\u0633\u0646 \u062f\u064a\u0627\u0644\u0643\u061f \u0625\u0630\u0627 \u0646\u0639\u0645\u060c \u0642\u0648\u0644\u064a \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0644\u064a \u0645\u0646\u0627\u0633\u0628\u0643 \u0648\u0634\u0646\u0648 \u0628\u0627\u0644\u0636\u0628\u0637 \u0627\u0644\u0639\u0644\u0627\u062c \u0627\u0644\u0644\u064a \u0645\u062d\u062a\u0627\u062c\u060c \u0648\u063a\u0627\u062f\u064a \u0646\u0628\u0644\u063a \u0627\u0644\u0641\u0631\u064a\u0642 \u0625\u0646 \u0634\u0627\u0621 \u0627\u0644\u0644\u0647."}, {"type": "user", "content": "In English please, I cannot read Arabic"}, {"type": "bot", "content": "Thank you for clarifying, Mourad."}, {"type": "bot", "content": "Would you like to book a new appointment to treat your tooth?"}, {"type": "bot", "content": "If yes, please let me know your preferred time and the specific treatment you need, and I will notify the team for you."}, {"type": "user", "content": "<reply_to>Would you like to book a new appointment to treat your tooth?</reply_to> Yes I had to get that implant"}, {"type": "bot", "content": "Thank you, Mourad. To help the team schedule your implant appointment, could you please let me know your preferred day and time for the visit?"}, {"type": "user", "content": "Tomorrow? As late as possible in the afternoon, please."}]

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