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": ["blur", "low_resolution"]
  },
  "description": "The image shows the lower face and mouth of an individual with their lips parted to expose the upper and lower anterior teeth. The gum tissue and teeth are visible. There is a green oval drawn around the lower front teeth. The teeth appear discolored with yellow to brown staining on the lower anterior teeth and some irregular spacing. The gums appear to have some redness, particularly around the lower front teeth. Several teeth have visible buildup near the gum line.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_lower",
        "observation": "Notable yellow-brown staining and visible calculus at the gum-line, irregular alignment, some crowding and spacing. One incisor appears severely stained or possibly decayed at the margin.",
        "severity_signal": "significant"
      },
      {
        "location": "front_upper",
        "observation": "Upper front teeth visible with staining along the gumline, some irregular alignment, and mild yellow discoloration.",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_right",
        "observation": "Adjacent to front teeth, increased

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "moderate",
    "issues": ["blur", "low_resolution"]
  },
  "description": "The image shows a close-up intraoral view of a person's mouth with the lips retracted to display the upper and lower front teeth. There is a green outline highlighting the central lower anterior region. Several teeth are visible, with significant yellow-brown staining, especially near the gum line. Plaque and calculus deposits are apparent on the lower front teeth. There are notable gaps between some of the upper and lower teeth, and alignment appears irregular. The gums appear pale pink in some areas but are partially obscured. There are no obvious soft tissue lesions or large swellings visible in this photo.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_lower",
        "observation": "Notable yellow-brown staining and substantial calculus at the gum line, irregular teeth spacing, at least one apparent missing tooth in the lower anterior segment.",
        "severity_signal": "significant"
      },
      {
        "location": "front_upper",
        "observation": "Discoloration present, especially around the incisal and cervical areas; irregular alignment and possible crowding.",
        "severity_signal": "moderate"
      },

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