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 shows a digitally created, cartoon-style tooth character with a smiling face, holding a notepad with a green checkmark. The background is a blurred dental office scene, including a dental chair and cabinetry. The upper area features the logo for Tanger Bay Dental Center (a stylized tooth with the words 'TANGER BAY DENTAL CENTER' below it). There are two blue banners with white text, with the top banner reading 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and the lower one 'CHEZ TANGER BAY DENTAL CENTER'. The overall color scheme is soft blue and white, conveying a clean and welcoming dental environment.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "unclear",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": "unclear",
    "alignment": "unclear",
    "calculus_plaque": "unclear",
    "periapical_areas": "unclear",
    "other_findings": ""
  },
  "text_visible": [
    "TANGER BAY

User message context: Salut *LINA AGHOUTANE*👋
Nous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷

📅 Date : *lundi 13 avril 2026*
🕘 Heure : *10:15*
📍 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 14221 in messages