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": "moderate",
    "issues": ["partial_view", "slight blur"]
  },
  "description": "This is a panoramic dental X-ray image (orthopantomogram). The entire upper and lower jaws are visible, including both left and right sides. The roots, crowns, and surrounding bone are evident for most teeth. The third molars are visible, with the lower left third molar (impacted) positioned horizontally. Multiple dental restorations are present on molar teeth, including several radiopaque areas consistent with crowns or large fillings. Bone levels are visible, with some possible reduction in the posterior regions. Minor vertical and horizontal distortion is present, and the midline is slightly off. The X-ray is displayed on a computer screen, with some interface icons at the bottom partially visible but unrelated to the clinical content.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left_third_molar",
        "observation": "Tooth appears horizontally impacted and is partially within the jawbone.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_right",
        "observation": "Posterior teeth display crowns or extensive restorations; root structures visible but with

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