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": "good",
    "issues": []
  },
  "description": "The image shows the lower half of a person's face, focusing on the open mouth and teeth. Green markings are drawn on the skin above the upper lip and across an upper central incisor. The upper front teeth display diastema (a gap between the central incisors), and there is a noticeable space indicating a missing upper right lateral incisor. The upper right canine is present but the teeth alignment is irregular. The lower teeth appear intact, with minor crowding and mild discoloration. The gums appear light pink, though a detailed assessment of gum tissue is limited by the angle and lighting.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Diastema between the upper central incisors; upper right lateral incisor is missing; irregular tooth alignment; teeth appear clean with natural color",
        "severity_signal": "moderate"
      },
      {
        "location": "front_lower",
        "observation": "All lower front teeth appear present with minor crowding and mild discoloration, generally aligned",
        "severity_signal": "mild"
      }
    ],
    "gum_condition": "Gum

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image depicts an open mouth with visible upper and lower anterior teeth. The upper anterior teeth show a midline diastema (space) between the two central incisors. There is also a missing tooth (upper left lateral incisor). The alignment of both upper and lower teeth appears irregular, with noticeable crowding and spacing. The gum tissue is healthy pink but with slight redness near the missing tooth area. No clear soft tissue lesions or swelling are visible. The teeth generally appear slightly yellowed. There are green markings added to the image: one above the upper lip, and another over the gap in the upper arch.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Midline diastema between upper central incisors, and missing upper left lateral incisor.",
        "severity_signal": "moderate"
      },
      {
        "location": "front_lower",
        "observation": "Lower anterior teeth show mild crowding and appear intact with no obvious fractures or caries.",
        "severity_signal": "mild"
      }
    ],
    "gum_condition": "Gums appear mostly healthy pink

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