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": "oral_photo",
  "image_quality": {
    "score": "moderate",
    "issues": ["partial_view", "slight_blur"]
  },
  "description": "This is a close-up, side-profile oral photo of a child with their mouth wide open, possibly crying or distressed. The photo shows the left side of the face, including part of the upper and lower teeth. The skin shows some tiny white spots and a minor superficial mark on the forehead. Several upper teeth are visible, with marked yellowish discoloration and what appears to be notable debris or deposit, especially on the upper left posterior teeth. The upper and lower gums are partially visible; lips are parted. No visible dental appliances. The inner cheek, tongue, and most of the occlusal surfaces are not clearly visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left",
        "observation": "Significant yellow-white deposit is present on most of the visible upper left posterior teeth. Enamel appears irregular in color.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_left",
        "observation": "Lower teeth are visible; no obvious large debris, but fine details not clear. Teeth appear aligned without obvious fracture.",
        "severity_signal

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "moderate",
    "issues": ["partial_view", "slight_blur"]
  },
  "description": "The image shows a close-up of the left side of a child's face with their mouth wide open, as if crying or yelling. The upper and lower teeth in the left side of the mouth are partially visible. The skin shows some tears or moisture on the cheek and forehead, along with minor skin irregularities. Hair and part of the nose are visible. The main focus is on the dentition.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left",
        "observation": "Irregular edges and multiple yellowish/white areas or deposits visible on molars/premolars; possible signs of enamel deterioration, decay, or plaque/calculus accumulation.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_left",
        "observation": "Anterior and posterior teeth partially visible; appear whiter and more regular than upper left but full detail not clear.",
        "severity_signal": "unclear"
      }
    ],
    "gum_condition": "Gum tissue above upper teeth partially visible; appears pale pink but detailed evaluation limited.",
    "bone_level

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