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

```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows an intraoral view of the lower posterior region, with the cheek retracted by a finger. Three molar/premolar teeth are visible, with the adjacent gum tissue and alveolar mucosa clearly exposed. The gum tissue appears moist and generally pink, with some mild variations in color. No obvious ulcers, swelling, or exudate are present. Teeth surfaces show evidence of wear and appear yellowish. The alveolar ridge area behind the last visible tooth is edentulous (lacking a tooth). The mucosa appears mostly smooth, with no apparent lesions or abnormal growths. There is a visible fold and some tension in the mucosa where the cheek is being retracted.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left",
        "observation": "Three teeth are visible, possibly molars and/or premolars. Surfaces appear slightly yellowed with evidence of some wear. No apparent large caries or fractures visible.",
        "severity_signal": "mild"
      }
    ],
    "gum_condition": "Gum tissue is pink and moist, generally healthy in appearance with no overt redness, swelling,

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