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": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image is an intraoral clinical photo showing the lower dental arch and the posterior regions of the upper arch. The patient's mouth is open with the use of cheek retractors. There are visible gloved fingers holding a device or retractor at the top of the image. The tongue is visible and appears unremarkable. Several teeth on both the left and right posterior upper arch present with large carious lesions and extensive structural loss. The lower anterior teeth are present and appear yellowish, with some calculus and staining. The lower left and right posterior teeth show signs of decay, discoloration, and plaque accumulation. The gum tissue appears inflamed and redder around the areas with severe caries.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left_posterior",
        "observation": "Severe decay with large cavities and structural loss on molars; dark brown/black discoloration; possible root remains.",
        "severity_signal": "significant"
      },
      {
        "location": "upper_right_posterior",
        "observation": "Severe decay with large cavities, dark discoloration, extensive loss of crown structure, and

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