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 a close-up intraoral photo of the lower left buccal vestibule. Part of the lower gum and alveolar ridge are visible, along with several posterior teeth (premolars and molars). Teeth appear yellowish white, and the gingival tissue looks moist, smooth, and pink in color. The gum contour is gently sloping, and the region is being retracted by a finger to expose the vestibular mucosa. There do not appear to be any obvious lesions, ulcers, or abnormal growths present in the mucosa. No dental appliances or obvious restorations are visible on the tooth surfaces. No active bleeding, pus, or swelling is noted.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left_posterior",
        "observation": "Several posterior teeth are visible with a generally intact crown surface; some yellowish discoloration is present, but there is no obvious visible large lesion or fracture from this angle.",
        "severity_signal": "mild"
      }
    ],
    "gum_condition": "Gum tissue appears moist, pink, and generally healthy with no visible swelling, redness, or ulcer

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a close-up intraoral photograph of the lower dental arch and adjacent soft tissues. The image is focused on the left or right buccal vestibule of the lower jaw. Three molar or premolar teeth are visible in the upper part of the image. The gingiva appears pink and moist. The mucosa overlying the alveolar ridge and vestibule is clearly visible and appears glistening and mostly healthy. No obvious lesions, ulcers, or swelling are present. There is a finger gently retracting the cheek, making the mucosa more visible. No visible appliances, sutures, or foreign bodies.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left (or lower_right) molar/premolar region",
        "observation": "Three teeth present with crowns visible; crowns have a yellowish hue and appear intact, no obvious cavitation or fractures visible in this view. No obvious staining or decay visible.",
        "severity_signal": "none"
      }
    ],
    "gum_condition": "Gingival tissue appears pink, moist, and firm with normal contour. No evidence of erythema, ulceration,

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