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 a close-up intraoral photo of an adult's mouth with a cheek retractor in place. The upper and lower anterior teeth as well as premolars are visible. The subject has a mustache, and the focus is primarily on the relationship of the teeth. The gums appear mostly healthy with light pink coloration but with some areas that may appear slightly red. The teeth overall are relatively well aligned, but there are noticeable color differences with the upper left and right central incisors appearing lighter/whiter and slightly more opaque compared to adjacent teeth. Slight crowding is present in the lower anterior teeth. Mild staining or discoloration is visible on the lower teeth towards the gum line. No large carious lesions or gross fractures are apparent. No obvious restorations, crowns, or braces are visible. No visible soft tissue swelling, ulcerations, or abnormal growths are seen. Posterior teeth and oral tissues in the back are not clearly visible. There is no visible pus, heavy plaque, or calculus. No text, labels, or identifying marks are visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation":

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