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 displays a close-up intraoral view of a person's mouth with a cheek retractor in place. The upper and lower anterior teeth and part of the premolars are revealed. Most teeth are visible from canine to canine in both arches, as well as partial visibility of premolars. The lips and facial skin around the oral cavity are also visible. The gum tissue appears generally pink but with mild reddish areas. The lower anterior teeth show yellowish and brown coloration at the cervical margins. Some mild crowding and overlapping of lower anterior teeth are evident, with uneven incisal edges.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper central incisors appear intact, have a whiter shade relative to other teeth, and minor translucency at the incisal edge.",
        "severity_signal": "none"
      },
      {
        "location": "front_lower",
        "observation": "Lower central and lateral incisors show brownish-yellow discoloration near gum line, crowding, and visibly uneven incisal edges.",
        "severity_signal": "mild"
      },
      {
        "location":

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