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 a high-quality intraoral photograph showing the upper arch of the mouth. The lips and cheeks are held away using a cheek retractor, providing a clear view of the upper teeth, the hard palate, and part of the lower front teeth. The image displays the upper molars, premolars, and anterior teeth as well as gingival tissues. The palate appears healthy and moist. The occlusal surfaces of the posterior teeth are well-illuminated, and there is no evident visual obstruction.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "upper_left_posterior",
        "observation": "All molars and premolars are present. Some teeth show light brownish occlusal staining or deep fissures, but no obvious cavitated lesions are visible.",
        "severity_signal": "mild"
      },
      {
        "location": "upper_right_posterior",
        "observation": "All molars and premolars are present. Some occlusal grooves show staining or deep fissures, no obvious large cavitations or missing tooth structure.",
        "severity_signal": "mild"
      },

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