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": "The image is a clinical intraoral photograph taken with a retractor in place, showing the mandibular (lower) anterior and premolar teeth in the mirror. There is significant yellow-brown calculus and plaque accumulation on the lingual surfaces of nearly all visible lower anterior teeth. The gum line is visible, and gingival margins appear slightly inflamed. Tooth color varies, with some visible staining. No obvious crowns, implants, or orthodontic appliances are present. The tissue background suggests a clinical setting with a blue dental bib present. There are no labels, date stamps, or identifying information visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_front",
        "observation": "All visible lower anterior teeth show extensive yellow-brown calculus and plaque on the lingual surfaces. Some teeth show discoloration and possible surface irregularity.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_left_premolar",
        "observation": "Lingual surface covered in calculus/plaque. Tooth color is yellowed.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_right

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