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 is an intraoral photo showing the mandibular (lower jaw) arch. The photo displays the occlusal (top) surfaces of the lower teeth, as well as the palate and the supporting gum tissue. The right side of the image (clinically the patient's left) shows several molar teeth that are severely decayed with large areas of crown destruction and visible loss of tooth structure. There is a mix of colors including brown, yellow, and black associated with decay and necrotic debris. The gums in the area appear red and inflamed, possibly with loss of normal contour. The left side of the image (clinically the patient's right) shows posterior teeth with multiple darkly stained occlusal grooves, possible old restorations or deep carious lesions. The anterior teeth appear relatively intact. No text, labels, or identifiers are visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left_first_and_second_molars",
        "observation": "Severe crown destruction due to caries, brown/yellow/black necrotic debris, gross loss of tooth structure, possibly pulp exposure.",
        "severity_signal": "sign

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