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": "This is a high-quality intraoral clinical photograph showing both upper and lower anterior and lateral teeth. A cheek retractor is in place, providing a clear view of the teeth and surrounding gum tissue. The upper teeth appear to have crowns or possibly veneers, as indicated by their uniform shape and color. The lower teeth exhibit yellowish-brown deposits along the gum line, especially on the anterior surfaces. The gum tissue appears pink with some localized redness, particularly in the lower anterior region. There is evidence of crowding and mild misalignment of the lower anterior teeth. No obvious soft tissue lesions or swelling are visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Teeth covered with crowns or veneers; uniform color and shape; appear well-aligned.",
        "severity_signal": "none"
      },
      {
        "location": "front_lower",
        "observation": "Natural teeth with visible yellow-brown calculus and staining near the gumline; mild crowding and overlapping.",
        "severity_signal": "moderate"
      },
      {
        "location": "upper_left",
        "observation": "

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