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": "dental_xray",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a digital panoramic dental X-ray (orthopantomogram). The entire maxilla and mandible are visible along with the maxillary sinuses, mandibular condyles, and surrounding bone structures. All teeth are visible except for the upper and lower left and right third molars, which appear to be missing or impacted. Several metallic dental restorations are seen, including crowns and/or large fillings present in the upper right and lower left posterior regions. Bone structures appear to have preserved density, without obvious severe bone loss. There are two radiopaque circular objects positioned laterally outside the dental arches on both the left and right, possibly ear or head-positioning markers. Some mild to moderate variations in crown-root morphology are visible. No obvious periapical radiolucencies or large lesions are present. The image displays a ruler scale on the right margin.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_right_posterior",
        "observation": "Presence of large metallic restoration (crown or large filling) on one or more molars. Adjacent teeth appear normal in shape and radiodensity.",
        "severity_signal": "

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