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] Image description: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a close-up view of an adult person's mouth open, displaying the upper and lower anterior teeth and adjacent gum tissue. The upper central incisors are spaced apart (midline diastema) and there is a missing upper right lateral incisor (tooth #12) and a missing upper left lateral incisor (tooth #22). Markings in the image (green lines and an arrow) highlight these points. Teeth are mostly present except for the upper lateral incisors. The lower anterior teeth are slightly crowded, and the teeth color appears to be natural with some mild discoloration. Gum tissue appears generally healthy without prominent redness or swelling. No visible caries, crowns, fillings, or dental prostheses are seen. No soft tissue lesions or acute injuries present. The lips and a portion of the surrounding skin are visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Missing both upper lateral incisors; central incisors present with a large gap between them (midline diastema)",
        "severity_signal": "significant"
      },
      {
        "location": "front_lower",

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "A close-up clinical intraoral photo of an adult's mouth, showing the upper and lower anterior and premolar teeth. The mouth is open, allowing visualization of the incisal and labial surfaces of the teeth, as well as the gingival margins. The upper arch displays a significant midline diastema and missing maxillary anterior teeth. Three green lines mark specific tooth areas, and a green arrow points to the region beneath the nose, apparently highlighting the absence of maxillary central incisors. The lower teeth are generally present and closely aligned, though slightly yellowed compared to the upper teeth. Gum tissue appears visible but only partially in the photo. No soft tissue lesions or overt swelling is noted.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Missing central and lateral incisors, large midline gap (midline diastema), remaining canines visible.",
        "severity_signal": "significant"
      },
      {
        "location": "upper_right",
        "observation": "Posterior teeth visible, appear intact with no obvious gross caries, minor staining possible.",
        "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 16330 in messages