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": "This is an intraoral photo showing the upper dental arch and palate. The teeth are clearly visible, with significant brown discoloration, cavitated lesions, and areas of darkened decay on multiple molars and premolars on both sides. There is extensive loss of tooth structure especially on the left and right posterior teeth (molars and premolars). The anterior teeth (front upper teeth) also show brown staining, particularly along the edges near the gumline. The gingival tissue appears mostly pink with mild redness adjacent to the decayed areas. Soft tissue of the hard palate appears normal in color, with no visible lesions or swelling.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left posterior (molars & premolars)",
        "observation": "Multiple teeth exhibit large cavitated carious lesions with extensive brown-black decay. Structural loss is evident.",
        "severity_signal": "significant"
      },
      {
        "location": "upper_right posterior (molars & premolars)",
        "observation": "Large carious lesions with dark brown/black decay present on most teeth. Substantial loss of tooth structure observed

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