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 bright, well-lit promotional graphic featuring a cartoon-style anthropomorphic tooth with big smiling eyes, raised eyebrows, and a wide mouth, displaying a thumbs-up gesture with one hand. The tooth character is holding a small notepad with a large green checkmark on it, indicating confirmation. In the background is a stylized dental office with a blurry dental chair and equipment, contributing to the dental clinic setting. At the top center of the image is the 'Tanger Bay Dental Center' logo, featuring an abstract tooth in white lines. There are two bold blue bars with text: the upper bar reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark emoji, and the lower one reads 'CHEZ TANGER BAY DENTAL CENTER.' The overall color palette is shades of blue, white, and beige, giving a clean, welcoming dental environment. ",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": null,
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": null,
    "alignment": null,

User message context: Salut *BERTRAND CHARLES MAURICE Le Goff*👋
Nous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷

📅 Date : *jeudi 16 avril 2026*
🕘 Heure : *10:00*
📍 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 16206 in messages