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] ```json
{
  "visible_domain": "dental_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "Intraoral photo of the lower dental arch taken from an occlusal view. Teeth are generally clean but notable calculus and staining are present on the lingual surfaces of the lower anterior teeth, especially in the area around a fixed lingual retainer. There is a large metal restoration (possibly an amalgam or metal crown) on the left mandibular first molar. On the right mandibular posterior area, there is a tooth presenting significant dark discoloration and apparent crown destruction, possibly due to severe caries or failed restoration. Gingiva appears generally pink but with localized swelling or changes near the damaged posterior tooth. The photo is well-focused and provides a full view of the lower arch. No visible text, labels, or patient-identifying information.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "anterior_lower",
        "observation": "Notable green and brown calculus and staining around the lingual fixed retainer, especially between the canines and incisors.",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_left_first_molar",
        "observation": "Large metal restoration (crown

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 16303 in messages