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": "moderate",
    "issues": ["slight_blur", "partial_view"]
  },
  "description": "The image shows an intraoral view of the lower left quadrant of the mouth. The person is using their finger to retract the lower lip, exposing the gum and teeth in the region. Several teeth are visible, including one with what appears to be significant structural loss and discoloration. The gum tissue near the affected tooth appears erythematous (red) and there is some irregularity or possible ulceration visible adjacent to the tooth with the major defect. The tongue and some adjacent teeth are also partially visible. The focus is primarily on a lower left molar or premolar region.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left_posterior",
        "observation": "There is a tooth with significant visible structural loss, dark discoloration, and irregular surface; large portion of the crown appears missing.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_left_anterior",
        "observation": "Teeth in the anterior segment appear intact with normal color and morphology.",
        "severity_signal": "none"
      }
    ],
    "gum

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