SQLite Web: app.db

id

Primary key. INTEGER

conversation_id

INTEGER NOT NULL

message_id

TEXT NOT NULL

sender

TEXT NOT NULL

message_type

TEXT NOT NULL (default 'text'

content

[Image analysis] Image description: ```json
{
  "visible_domain": "non_dental",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image is a promotional or notification visual for Tanger Bay Dental Center. It features a light blue background resembling a modern dental clinic setting, with a blurred dental chair and equipment visible in the background. The main focus is a large, cartoon-style, anthropomorphic tooth character with expressive eyes, dark eyebrows, and a smiling mouth. The character is holding a small calendar or notepad with a thick black border, featuring a green checkmark inside a box, symbolizing confirmation. Above the character is the logo for Tanger Bay Dental Center, consisting of an abstract molar tooth shape and the text 'TANGER BAY DENTAL CENTER'. Overlaid in the upper middle is a bold, blue banner with white text reading: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' followed by a checkmark emoji. Below that, another blue bar contains the text: 'CHEZ TANGER BAY DENTAL CENTER'. The overall tone is cheerful and welcoming.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": null,
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_te

User message context: Salut *HARBOUCH Amin*👋
Nous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷

📅 Date : *jeudi 30 avril 2026*
🕘 Heure : *17:30*
📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)
📞 Pour toute question : 06 60 02 22 63
✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message

⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. 
Merci de votre compréhension.

TEXT

media_url

TEXT

media_mime_type

TEXT

chatbot_id

INTEGER NOT NULL

created_at

TEXT NOT NULL

status

TEXT (default 'sent'

delivered_at

TEXT

read_at

TEXT

sender_user_id

TEXT

metadata

TEXT

app.db — messages

Update row 20704 in messages