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 intraoral photo shows the lower dental arch, including the lower teeth and some of the gum tissue. The teeth on the left side of the image appear mostly intact, with natural occlusal surfaces and mild discolorations. The right side shows several posterior teeth with dark lesions on their occlusal surfaces, suggestive of carious processes or old restorations. There are multiple amalgam or composite restorations present on the right side. The gum tissue appears generally healthy with no obvious swelling or active bleeding. The tongue and floor of the mouth are not visible, and the arch form is generally U-shaped. The upper front teeth (anterior) are partially visible at the top of the image.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "lower_left",
        "observation": "Teeth appear mostly intact with some mild occlusal staining or discoloration; no overt cavities or fractures evident.",
        "severity_signal": "mild"
      },
      {
        "location": "lower_right",
        "observation": "Multiple posterior teeth show dark occlusal lesions; evidence of carious processes and/or previously placed amalgam or composite restor

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