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 an intraoral clinical photograph showing the anterior and some posterior teeth of an adult patient. A cheek retractor is in place to provide clear visualization of the teeth and gums. The upper and lower front teeth are visible, as well as parts of the premolars and molars on the sides. The upper teeth appear generally lighter than the lower teeth, which show notable yellow-brown discoloration, particularly on the cervical and interproximal areas. There is visible plaque or calculus accumulation, especially on the lower anterior teeth. The gum tissue appears pink but there is mild erythema (redness) in some areas, more pronounced in the lower front region. Tooth alignment is irregular, especially in the lower anterior segment where there is crowding and mild rotation. Some posterior teeth in the right and left quadrants appear partially visible and may show signs of restoration or decay, but evaluation is limited by the angle. No overt signs of gross caries or fracture are visible in the anterior teeth.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper anterior teeth appear relatively intact, some mild yellow discoloration and transluc

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