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": "This is a close-up intraoral photograph showing the lower posterior region of the mouth. The image captures part of the lower lip, gum tissue, and two adjacent teeth. The teeth are natural in color with minor visible plaque at the gumline. The adjacent gum tissue appears erythematous (red) and swollen, particularly at the edentulous (toothless) area next to the visible teeth. The surface of the gum in this area appears irregular, with some whitish areas and a shiny, moist appearance. No obvious restorations, braces, or appliances are present. The remainder of the oral mucosa in the visible region appears moist. A gap is clearly visible where a tooth is missing.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left",
        "observation": "Two teeth visible, normal color, mild plaque near gumline.",
        "severity_signal": "mild"
      }
    ],
    "gum_condition": "Gum tissue near edentulous area appears erythematous, swollen, and irregular with some shiny and whitish areas.",
    "bone_level": null,
    "root_canals": null

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a close-up intraoral photo showing the lower posterior left mucosa and gingiva, two adjacent natural teeth (likely premolars), and part of the alveolar ridge. The teeth appear intact with visible anatomic crown structure. The gums appear erythematous (red) and somewhat swollen in the area distal to the teeth, especially in the edentulous region behind the visible teeth. There are some translucent/white raised areas visible on the edentulous ridge, potentially consistent with mucosal changes or healing tissue. No active bleeding is seen. No visible dental restorations, crowns, or appliances in this view.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left",
        "observation": "Two natural teeth visible with normal crown morphology; no gross caries, fractures, or obvious discolorations are seen.",
        "severity_signal": "none"
      }
    ],
    "gum_condition": "Gum tissue is erythematous and moderately swollen around the edentulous area, with some translucent/white raised mucosal areas suggestive of tissue change or possible healing.",
    "bone_level": null,
    "root

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