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 shows an intraoral view of the lower dental arch with the patient's mouth wide open and cheeks retracted using plastic retractors. Both lower left and lower right posterior regions are clearly visible. The anterior lower teeth (incisors and canines) appear aligned and are of similar shade. There are multiple teeth with white restorations or crowns, and the two most posterior teeth on each side appear to have large, brownish restorations, possibly old composite or amalgam fillings. The visible gum tissue is pink and does not demonstrate obvious swelling or redness. The oral mucosa (floor of mouth) is visible and appears moist and healthy, without notable lesions.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_right_posterior",
        "observation": "Most posterior molar exhibits a large brown restoration and moderate wear; adjacent tooth shows a white restoration/crown.",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_left_posterior",
        "observation": "Most posterior molar exhibits a large brown restoration and moderate wear; adjacent tooth shows a white restoration/crown.",
        "severity_signal

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