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 confirmation graphic for a dental clinic. The background appears to depict a dental office with a dental chair visible and light blue-green tones. The main foreground element is a cartoon tooth character with a happy facial expression, holding a small calendar or notepad that displays a large green checkmark. The character is also giving a thumbs-up gesture. At the top, the logo for 'Tanger Bay Dental Center,' featuring an abstract tooth outline, is prominently displayed. There are two blue banners with white text confirming an appointment at the clinic. The overall composition is clean and easy to read.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": "",
    "alignment": "",
    "calculus_plaque": "",
    "periapical_areas": "",
    "other_findings": ""
  },
  "text_visible": [
    "TANGER BAY DENTAL CENTER",
    "VOTRE RENDEZ-VOUS EST CONFIRMÉ",
    "CHEZ TANGER BAY D

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

📅 Date : *mercredi 24 juin 2026*
🕘 Heure : *18: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 47484 in messages